Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

HOW TO: Configure DataDirect ODBC on UNIX with PowerCenter
Solution

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.

    Example

    $​ 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
    • HP-UX - SHLIB_PATH
    • AIX - LIBPATH

     

  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

    OR

    $ 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).

      Example

      InstallDir=/apps/Informatica/10.2.0/ODBC7.1

    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.
Note

 

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

More Information
Reference

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:
Attachments
Last Modified Date:11/26/2018 1:23 AMID:14684
People who viewed this also viewed

Feedback

Did this KB document help you?



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