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
Make a backup copy of the original file in case you delete or overwrite the file with a new installation or update.
Open the .odbc.ini file using a text editor like Notepad plus. Only the Trillium administrator has permissions to configure the .odbc.ini file.
Locate and copy the example section pertaining to the Oracle driver, for example:
[Oracle] Driver=/home/.../tsq17.0.0/RepoServer/TSS/lib/HTora25.so Description=TSS 17 Oracle Driver .... HostName= PortNumber= ServiceName= TNSNamesFile=<tnsnames.ora_filename> ........
Paste the section at the end of the list of definitions listing.
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 usingServiceName
, 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.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> ........
Save the changes and close the file.