Configuring other ODBC drivers

You can use ODBC drivers from other vendors to connect to data sources. However, you can use only one ODBC Manager, so you cannot use drivers from other vendors if you use the InfoSphere® DataStage® drivers.

1. Install the ODBC manager and drivers. Use the documentation that the driver vendor provides.
2. Configure the computer to connect to the driver.
   1. In the dsenv file, add the required environment variables.
   2. In the odbc.ini file, set up the connection to the database or to the database client application. You must specify the Data Source Name (DSN), driver name, and login information.
   3. In the uvodbc.config file, specify the DSN to use to connect to the database.
3. Include the shared library libodbc.sl for the ODBC Manager in the InfoSphere DataStage load library path. (On HP-UX, the suffix is so.) Edit the dsenv file and ensure that the path to the ODBC Manager precedes the path to $DSHOME/../branded_odbc/lib in the shared library path environment variable.
4. After you install and configure the driver, test the connectivity.