Configuring an Oracle ODBC Data Source Name

To configure an Oracle Data Source Name (DSN), you must have specified a TNS Service Name for the database in which your workspace repositories will be stored. This is the TNS Service Name you entered when you installed the repository client.

Check the file tnsnames.ora in Repository_Client_HOME to make sure the TNS Service Name exists. The entry should look like this, where RMWPROD is the TNS Service Name:

     RMWPROD
         (DESCRIPTION=    
             (ADDRESS_LIST=      
                 (ADDRESS=(PROTOCOL=TCP)(HOST=tiger)(PORT=1521))
              )    
             (CONNECT_DATA=      
                 (SID=lnx)    
              )  
          )

You will also need to obtain a database user ID and password from your DBA to configure the Oracle DSN.

Note: Keep the DSN handy. You will need to specify it when you create an CA workspace. For instructions on how to create a workspace, see Getting Started in the CA documentation set.

In the Windows Control Panel, double-click Administrative Tools. The Administrative tools window opens.
Double-click Data Sources (ODBC). The ODBC Data Source Administrator window opens.
Select the System DSN tab and click Add. The Create New Data Source dialog opens.
Select an appropriate Oracle driver and click Finish. The Oracle ODBC Driver Configuration window opens.
Specify the following information in the Oracle ODBC Driver Configuration window:
- In the Data Source Name field, enter a name of your choice to identify the data source. If your DBA has supplied a common DSN for use across the enterprise, enter it here.
- In the Description field, enter an optional description for the data source.
- In the TNS Service Name drop-down, select the TNS Service Name for the database in which your workspace repositories will be stored. If no choices are shown, or if you are unsure which name to select, contact your DBA.
- In the User ID field, enter the database user ID supplied by your DBA.
Click Test Connection. The Oracle ODBC Driver Connect window opens.
In the Oracle ODBC Driver Connect window the Service Name and User ID fields are prefilled with the information you supplied in the Oracle ODBC Driver Configuration window. Enter the password for your user ID and click OK. You are notified that the connection was created successfully. Click OK.
Note: If you receive an error, verify the driver configuration settings and retest the connection. See your DBA if the problem persists.
Click OK to exit the Driver Configuration window. Then click OK again to exit the ODBC Data Source Administrator window.