Configuring TSS ODBC Connection String on UNIX - trillium_discovery - trillium_quality - Latest

In this example, you are configuring the TSS ODBC connection string for UNIX. You will not need to install the Oracle Client.

To add a data source entry to connect to Oracle database

1. Make a backup copy of the original file in case you delete or overwrite the file with a new installation or update.

2. Open the .odbc.ini file using a text editor like Notepad plus. Only the Trillium administrator has permissions to configure the  .odbc.ini file.

3. Locate and copy the example section pertaining to the Oracle driver, for example:

   [Oracle]
   Driver=/home/.../tsq17.0.0/RepoServer/TSS/lib/HTo­ra25.so
   Description=TSS 17 Oracle Driver
   ....
   HostName=
   PortNumber=
   ServiceName=
   TNSNamesFile=<tnsnames.ora_file­name>
   ........

4. Paste the section at the end of the list of definitions listing.

5. In the copied definition, change the data source name. The data source name is between square brackets at the beginning of the definition, for example, [Oracle1].

   Modify as follows:

   Change data source name to [Oracle1].

   Change HostName to reflect the Oracle TNS and installation.

   Change PortNumber to reflect the Oracle TNS and installation.

   Change ServiceName to reflect the Oracle TNS and installation.

   Note: When using ServiceName, clear the default comments (shown below) for ServerName and SID as defined in the .odbc.ini including the opening and closing brackets “<>”. That is: ServerName=<server_name in tnsnames.ora>

   SID=<Oracle_System_Identifier>

   Note: The information you provide here is defined in the tnsnames.ora file. You can get this information from the Oracle database administrator.

6. Go to the beginning of the file to the [ODBC Data Sources] section. Add a new data source name as shown below:

   Oracle1=TSS 17 Oracle Driver

   This is how the changed sections will look like:

   [ODBC Data Sources]
   ...
   Oracle=TSS 17 Oracle Driver
   Oracle1=TSS 17 Oracle Driver
   ....
   [Oracle1]
   Driver=/home/.../tsq17.0.0/RepoServer/TSS/lib/HTora25.so
   Description=TSS 17 Oracle Driver
   ....
   HostName=orasys-1
   PortNumber=1500
   ServiceName=oracle.yourcompany.com
   TNSNamesFile=<tnsnames.ora_filename>
   ........

7. Save the changes and close the file.