
The ODBC driver is used for providing data in
relational form to the extract, transform, and load framework of
Rational® Common Reporting for returning the result sets for ETL jobs and live reports.
If the driver is installed at a location other than the default location,
you must to configure the library path of the driver so that you can
connect to the data source.
Before you begin
Make sure that your system has an ODBC driver manager installed.
The version of the driver manager must be 2.2.14 or later. You can
download any UNIX® ODBC driver
manager of your choice and install it according to the installation
instructions contained at the download site for the driver manager.
About this task
During the installation process, the ODBC driver is configured
to use the JDBC jar files in the
[rational_common_reporting_directory]/dataconfig/jdbc directory. If your 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 configure the ODBC drivers
for a Linux® environment:
Procedure
- Go to [rational_common_reporting_installation_directory]\dataconfig\odbc\ directory.
- Edit the odbcinst.ini file to make
sure that the string value of the Driver parameter
is the path of [rational_common_reporting_directory]\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.
Example code: [RQM]
Driver = IBM Rational Common Reporting XML ODBC Driver
DataSource = RQM
Description =
Configuration = /opt/ibm/RationalCommonReporting/dataconfig/configs/live data config/rqm.xdc
- 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 odbcinst.ini file:
odbcinst -j
- The odbcinst.ini file starts and ends
with an empty line. Add the following lines to the file.
[IBM Rational Common Reporting XML ODBC Driver]
Description =
Driver = {path of libratlxml.so}
Setup = {path of libratlxmlS.so}
MaxActiveStatements = 100
QueuingTimeout = 100000
DefaultPageSize = 1000
LibPath = {the path of jdbc directory}
Example code: [IBM Rational Common Reporting XML ODBC Driver]
Description =
Driver = /opt/ibm/RationalCommonReporting/dataconfig/odbc/libratlxml.so
Setup = /opt/ibm/RationalCommonReporting/dataconfig/odbc/libratlxmlS.so
MaxActiveStatements = 100
QueuingTimeout = 100000
DefaultPageSize = 1000
LibPath = /opt/ibm/RationalCommonReporting/dataconfig/jdbc
- Copy the [rational_common_reporting_installation_directory]\dataconfig\odbc\odbc.ini file in the directory of the
system DSN file.
- Copy the [rational_common_reporting_directory]\dataconfig\odbc\odbcinst.ini file in the directory of
the driver configuration file.
- Connect to a data source to verify that the DSN is working. For example, if you are using Rational Quality Manager as a data source, and the DSN name for the data source
is RQM, you can use the following command to connect
to the Rational Quality Manager driver.
isql ClearCase