Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(15 Ratings)
facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Configure DataDirect ODBC on UNIX with PowerCenter

Do the following to install DataDirect ODBC drivers on UNIX:

  1. Install the Informatica Services which include the DataDirect ODBC drivers for UNIX.

  2. Set the ODBCHOME environment variable to the location where the ODBC drivers have been installed.
    By default, ODBC is installed in the <INFA_HOME>/ODBCx.y directory.  Where x.y is the ODBC version number.


    $​ ODBCHOME=/opt/Informatica/10.2.0/ODBC7.1; export ODBCHOME

  3. Add the $ODBCHOME/bin directory to the PATH environment variable:

    Using a Bourne shell:

    $ PATH=${PATH}:$ODBCHOME/bin; export PATH

    Using a C shell:

    $ setenv PATH ${PATH}:$ODBCHOME/bin 

  4. Add the $ODBCHOME/lib to the library path variable.
    The library path will vary by operating system:
    • Solaris - LD_LIBRARY_PATH
    • Linux - LD_LIBRARY_PATH


  5. (OPTIONAL) Copy the odbc.ini file to the location where you would like this file to be used.
    Typically the Informatica home directory is used.

    cp $ODBCHOME/odbc.ini $HOME/.odbc.ini

  6. Set the ODBCINI environment variable to the location of the .odbc.ini (or odbc.ini) file: 

    $ ODBCINI=$HOME/.odbc.ini; export ODBCINI


    $ ODBCINI=$ODBCHOME/odbc.ini; export ODBCINI

  7. Edit the odbc.ini file (specified by the $ODBCINI environment variable) as follows:

    1. Set the InstallDir to the ODBC installation directory ($ODBCHOME).



    2. Add an entry for the ODBC data source (DSN) under the section [ODBC Data Sources] and configure the data source.
      For specific examples of commonly used ODBC connections refer to the related article for that database:

  8. Restart the Informatica Services.


To use these ODBC connections in PowerCenter sessions you will need to configure ODBC relational connections in the Workflow Manager.

More Information

For more information, see Informatica Installation and Configuration Guide > "Connecting to Databases from UNIX" > "Connecting to an ODBC Data Source"

Applies To
Product: PowerCenter
Problem Type:
User Type: Developer
Project Phase:
Product Version: PowerCenter 8.x; PowerCenter 9.x; PowerCenter 10.0; PowerCenter 10.1
Database: ODBC
Operating System: AIX; HP-UX; Linux; Solaris
Other Software:
Last Modified Date:11/26/2018 1:23 AMID:14684
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)