Configuring the ODBC driver and creating the data source (Linux and UNIX)

To configure the ODBC driver on Linux or UNIX, you set environment variables and specify parameters for the cac.ini file.

1. On the IBM® InfoSphere™ Information Server, set the following environment variables:

   LIBPATH=$LIBPATH:/install_path/cli/lib
   PATH=$PATH:/install_path/cli/bin
   CAC_CONFIG=/directory/cac.ini

   where install_path is /opt/ibm/wsclassic95 for Linux and /opt/IBM/wsclassic95 for UNIX and directory is any directory.
2. To create the data source, open the cac.ini file, as shown in the following example:

   ****************************************************
   *  Sample CLI Client Configuration File            *
   ****************************************************
   * messages and codes catalog
   NL CAT = /opt/IBM/wsclassic95/cli/lib
   NL = US English
   * user id/pwd needed for catalog security
   USERID = cacuser
   USERPASSWORD = cacpwd
   * default datasource location
   DEFLOC = CACSAMP
   DATASOURCE = CACSAMP tcp/machine.url.com/5001
   * performance and memory parameters
   FETCH BUFFER SIZE = 32000
   MESSAGE POOL SIZE = 16777216
   * codepage parameters
   SERVER CODEPAGE = IBM-037
   CLIENT CODEPAGE = IBM-850

   The configuration file resides in the installation directory /opt/IBM/wsclassic95/cli/lib/cac.ini for UNIX or /opt/ibm/wsclassic95/cli/lib/cac.ini for Linux. For the 64-bit version, the configuration file resides in the 64-bit lib subdirectories.
3. Modify the DATASOURCE parameter. DATASOURCE is a required parameter that specifies the hostname, IP address, port, and name of the data source that the client attempts to connect to. The data source name that you enter ("CACSAMP" in the cac.ini example above) must match the name of the query processor service on the data server.
4. To configure the data source for the DataDirect ODBC driver manager, complete the following steps:
   1. Edit the odbc.ini file to add the new data source for the client:

      [ODBC data sources]
      CACSAMP=WebSphere Classic Federation client
      ...
      [CACSAMP]
      Driver=/opt/IBM/wsclassic95/cli/lib/lib64/client

      where client is cacsqlcli (UNIX) or libcacsqlcli.so (Linux).
   2. Make sure that the ODBCINI environment variable, which specifies the location of the odbc.ini file, is defined to the IBM InfoSphere DataStage®environment.
5. Use the DataDirect "example" application that comes with InfoSphere Information Server to test the connection to the data server.