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

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

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.