|Oracle® GoldenGate Veridata Administrator's Guide
11g Release 2 (220.127.116.11.0)
Part Number E29092-01
|PDF · Mobi · ePub|
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.
You can use these same steps to edit or verify an existing DSN.
Run one of the following ODBC clients:
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).
In the ODBC Data Source Administrator dialog box of the ODBC client, select the System DSN tab.
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.
(New data source only) Under Create New Data Source, select either the SQL Server or SQL Native Client driver.
Click Finish. A new wizard is displayed.
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
Click the Client Configuration button.
In the Edit Network Library Configuration popup:
Enter a server alias name (optional).
Under Network Libraries, make certain that TCP/IP is selected (default).
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.
You can leave all of the Microsoft SQL Server DSN Configuration settings to their default values.
You can leave all of the Create New Data Source to SQL Server settings to their default values.
Click Test Data Source to test the connection.
Close the confirmation box and the Create a New Data Source box.