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:
- Go to RI_InstallDir\dataconfig\odbc\ directory.
- 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.
- Edit the odbc.ini file to make sure
that the string value of the Configuration parameter
is the path of your configuration file.
- 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
- Copy the RI_InstallDir\dataconfig\odbc\odbc.ini file
in the directory of the system DSN file.
- Copy the RI_InstallDir\dataconfig\odbc\odbcinst.ini file
in the directory of the driver configuration file.