Before creating a database connection for Oracle GoldenGate processes running on Windows, install the latest version of Microsoft ODBC Driver 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

1. Open the ODBC Data Sources (64-bit) application.

2. In the ODBC Data Source Administrator dialog box, select the System DSN tab, and then click Add.

3. 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.

4. 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.

5. For login authentication, select one of the following options, and then click Next:

   1. With Integrated Windows Authentication

   2. With SQL Server authentication using a login ID and password entered by the user

6. Select Change the default database to, and then select the source or target database from the list. Enable the Use ANSI settings. Click Next.

7. Leave the next page set to the defaults. Click Finish.

8. Click Test Data Source to test the connection.

9. If the test is successful, close the confirmation box and the Create a New Data Source box.

10. Repeat this procedure for each SQL Server source and target database.