C Configuring an ODBC connection for a SQL Server Repository

This appendix describes how to define a connection to an SQL Server repository.

To use a SQL Server database as a repository, you must establish a system data source name (DSN). A DSN stores information about how to connect to the database.

1. Run one of the following ODBC clients:

   • If using a 32-bit version of Oracle GoldenGate Veridata on a 64-bit system, create the DSN by running the ODBCAD32.EXE client from the %SystemRoot%\Windows\SysWOW64 folder.

   • If using a 64-bit version of Oracle GoldenGate Veridata on a 64-bit system, create a DSN by running the default ODBCAD32.EXE client in Control Panel, Administrative Tools, Data Sources (ODBC).

   • If using a version of Oracle GoldenGate Veridata other than the preceding, use the default ODBC client in Control Panel, Administrative Tools, Data Sources (ODBC).

2. In the ODBC Data Source Administrator dialog box of the ODBC client, select the System DSN tab.

3. Do one of the following:

   • To create a new DSN, click Add.

   • To verify an existing DSN, select the name from the System Data Sources list and then click Configure.

4. (New data source only) Under Create New Data Source, select either the SQL Server or SQL Native Client driver.

5. Click Finish. A new wizard is displayed.

6. Supply or verify the following:

   • Name: Can be of your choosing.

   • Description: (Optional) Type a description of this data source.

   • Which SQL Server do you want to connect to: Select (or type) the name of the SQL Server instance. To create the DSN for a named instance, specify the host name and instance name in this format: host\instance. To create a DSN for the default instance, just the host name is sufficient. If the instance is on the local machine, you can select the localhost option.

7. Click Next.

8. Click the Client Configuration button.

9. In the Edit Network Library Configuration popup:

   • Enter a server alias name (optional).

   • Deselect the Dynamically determine port box, and then enter the name of a port number to use (the default of 1433 is acceptable). Oracle GoldenGate Veridata requires the use of a static port.

   • Under Network Libraries, make certain that TCP/IP is selected (default).

10. Click OK.

11. Based on your SQL Server configuration, select either With Windows NT authentication to require a network login or select With SQL Server authentication using a login to require database credentials. If you select SQL Server authentication, supply a login and password to test the DSN. This is for test purposes, only. This is not necessarily the user that will be used by Oracle GoldenGate Veridata.

12. Click Next.

13. You can leave all of the Microsoft SQL Server DSN Configuration settings to their default values.

14. Click Next.

15. You can leave all of the Create New Data Source to SQL Server settings to their default values.

16. Click Finish.

17. Click Test Data Source to test the connection.

18. Close the confirmation box and the Create a New Data Source box.