Please first read how to use the Discovery Application.
Discover a Microsoft SQL Server database
To discover a Microsoft SQL Server database with the Discovery Application, please choose the following source system type:
Then, fill in the following information:
The value examples below correspond to the source example explained in the Microsoft SQL Server target environment.
- Name: discovery name
- Example: ADW2019_Sales
- Server: the host and the port (optional) to connect to the Microsoft SQL Server database
- Example: localhost,1460
If you want to discover data from a Microsoft SQL Server database on Azure, put here the name of the Azure server, for example bgsqlserver.database.windows.net
- Database: database name
- Example: AdventureWorks2019
- Schema: schema name
- Example: Sales
- Authentication Type:
- Example: SQL Server Authentication
- User (optional):
- Example: sa
- Password (optional):
- Example: Admin2022!
You need to enable the TCP/IP protocol to discover your SQL Server database.
If you want to connect to another SQL Server instance than the default one (which is by default accessible on port 1433 as shown in the example below), you need to:
- Open the SQL Server Manager for the version of this other instance. For this, execute the following command:
- sqlservermanager15.msc for SQL Server 2019
- sqlservermanager14.msc for SQL Server 2017
- Under SQL Server Network Configuration > Protocols for + instance name, double-click on TCP/IP and open the IP Addresses tab
- At the end of the list, assign a port other than the default one (1433) for IPAll in TCP Dynamic Ports:
- Under SQL Server Services, right-click the service SQL SERVER (instance name) and choose Restart
The host_port value in the YAML configuration file should look similar to this:
host_port: 127.0.0.1:1451 #Adapt the post value