Configure a DSN Connection in Windows

Before creating a database connection for Oracle GoldenGate processes running on Windows, install the latest version of either Microsoft ODBC Driver 17 for SQL Server or the Microsoft ODBC Driver 18 for SQL Server.

Follow these steps to create a system DSN on the Windows server where Oracle GoldenGate is installed.

To create a SQL Server DSN:

Open the ODBC Data Sources (64-bit) application.
In the ODBC Data Source Administrator dialog box, select the System DSN tab, and then click Add.
Under Create New Data Source, select the ODBC Driver {version} for SQL Server and then click Finish. The Create a New Data Source to SQL Server wizard appears.
Enter the following details, and click Next:
- Name: Can be of your choosing. In a Windows cluster, use one name across all nodes in the cluster.
- Description: (Optional) Type a description of this data source.
- Server: Type the SQL Server connection string or server\instance name. For Always On connections, use the listener\instance name of the Always On Availability Group.
For login authentication, select SQL Server authentication, specify the Login ID and Password information, and then click Next.
If configuring a connection using the Microsoft ODBC Driver 18 for SQL Server, click Next again to go to the last configuration page. Select the option for Trust server certificate and then click Back to proceed as you need to first enable the Trust server certificate before selecting the default database in the next step.
Select Change the default database to, and then select the source or target database from the list. Enable the Use ANSI settings, and click Next.
Leave the next page of the wizard as-is and click Finish.
Click Test Data Source to test the connection.
If the test is successful, close the confirmation box and the Create a New Data Source box.
Repeat this procedure for each SQL Server source and target database, where Oracle GoldenGate process will connect.