Configuring the odbc.ini file

The odbc.ini file provides information about connecting to all the databases and database client applications that you use. You must configure this file so that IBM® InfoSphere® Information Server can access ODBC data sources.

About this task

The /opt/IBM/InformationServer/Server/branded_odbc/IBM_Tools directory contains example odbc.ini files for each supported platform. Use the contents of these files to create the odbc.ini file for the $DSHOME directory. The $DSHOME variable identifies the InfoSphere DataStage® installation directory.

Procedure

  1. Navigate to the <installation-directory>/Server/DSEngine directory, where <installation-directory> is the directory where you installed InfoSphere Information Server.
  2. Run the following command to create an odbc.ini soft link pointing to the .odbc.ini sample file. 
    ln -s .odbc.ini odbc.ini
  3. Modify the .odbc.ini file to match your database environment.