Prerequisites: Go to the TIBCO's edelivery website https://edelivery.tibco.com/storefront/index.ep and download the driver for the required TIBCO Data Virtualization version. E.g. "TIB_tdv_drivers_8.5.2_all.zip"

Once the zip file for the driver has been downloaded, it needs to be extracted for the ODBC driver. The user can create these directories: /opt/odbc/linux64 and /home/release
 

This article emphasizes the point of how to install the ODBC driver and configure the DSN on a Linux machine. This article also explains how to connect to the published resource in TIBCO Data Virtualization using an ODBC connection.

All supported environment

1. Open the bash file to set the required environment variables.
========================
vi ~/.bash_profile
========================

Hit "i" to insert these variables into the bash profile:
--------------
export COMPOSITE_HOME=/home/release
export ODBCINI=/opt/odbc/linux64/odbc.ini
export ODBCINSTINI=/opt/odbc/linux64/odbcinst.ini
export LD_LIBRARY_PATH=/opt/odbc/linux64/lib
export TDV_ODBC_UODBC="TRUE"
--------------
To exit the vi editor, hit Esc and then :wq!

2. To make the changes permanent hit the below command:
==========================
source ~/.bash_profile
==========================

3. Go to the path where ODBC driver exists
--------------
cd /opt/odbc/linux64/bin
--------------

4. If the driverConfig is not an executable file then need to make it executable (If in grey it's not executable, if in blue it's executable). Run the below command to make it executable:
--------------
chmod +x driverConfig
--------------

Make the installer executable as well. Go to /opt/odbc/linux64/lib and execute the below command:
--------------
chmod +x libcomposite85_x64.so
--------------

5. Install the driver:
--------------
cd /opt/odbc/linux64/bin
./driverConfig -installDriver $LD_LIBRARY_PATH/libcomposite85_x64.so
--------------

6. Configure the DSN using the below command:
--------------
./driverConfig -configdsn 'DSN=test;host=172.31.24.17;port=9401;uid=admin;pwd=<password>;domain=composite;datasource=mercer-odbc;catalog=cat'
--------------

DSN:  Can be given any meaningful name.
host: The hostname/IP for the TIBCO Data Virtualization where the resource has been published to connect.
port: Base_port of TIBCO Data Virtualization where the resource has been published to connect + 1.
uid: username for TIBCO Data Virtualization's user.
pwd: password for the TIBCO Data Virtualization user.
domain: TIBCO Data Virtualization's domain. 
datasource: Name of published resource in TIBCO Data Virtualization.
catalog: Name of the catalog given while creating a catalog for published resource in TIBCO Data Virtualization.