Configuring the ODBC driver

LinuxThe 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

  1. Go to [rational_common_reporting_installation_directory]\dataconfig\odbc\ directory.
  2. 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.
  3. 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 
  4. 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
  5. 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
  6. Copy the [rational_common_reporting_installation_directory]\dataconfig\odbc\odbc.ini file in the directory of the system DSN file.
  7. Copy the [rational_common_reporting_directory]\dataconfig\odbc\odbcinst.ini file in the directory of the driver configuration file.
  8. 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

Feedback