Wednesday 25 January 2017

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 
    > ODBCHOME=/opt/Informatica/9.6.1/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.


  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).
  8. Re-Start the Informatica Node services.

No comments:

Post a Comment