Configuring the ODBC and JDBC drivers

The ODBC and JDBC drivers are used to provide data in relational form to the extract, transform, and load framework of IBM® Rational® Insight for returning the result sets for ETL jobs and live reports. If you have installed the JDBC driver in a non-default location, you need to configure the library path of the ODBC driver so that you can use it with the JDBC driver.
About this task
During the installation process, the ODBC driver is configured to use the JDBC jar files in the [INSTALLDIR]/dataconfig/jdbc directory. If your JDBC driver files are located in a different directory, change the LibPath parameter of the ODBC driver. See the Related reference links for a list of parameters and their explanation.

To enable the ODBC drivers for a Linux® environment:

  1. Go to RI_InstallDir\dataconfig\odbc\ directory.
  2. Edit the odbcinst.ini file to make sure that the string value of the Driver parameter is the path of RI_InstallDir\dataconfig\odbc\libratlxml.so file.
  3. Edit the odbc.ini file to make sure that the string value of the Configuration parameter is the path of your configuration file.
  4. Make sure that your system has an ODBC driver manager installed. Find out the path of your driver configuration file (odbcinst.ini) and system DSN file (odbc.ini).
    You can use the following command to find out the path of the odbc.ini and odbcinst.ini files:
    odbcinst -j
  5. Copy the RI_InstallDir\dataconfig\odbc\odbc.ini file in the directory of the system DSN file.
  6. Copy the RI_InstallDir\dataconfig\odbc\odbcinst.ini file in the directory of the driver configuration file.

Feedback