Wednesday, 13 May 2015

Prerequisite for Using Informatica ODBC 7.0

Problem : To load a oracle table using ODBC relational Connection 

Solution:

In order to utilize the ODBC connection option , we need to add the following environment variables as below:

Step 1: Open the vi .bash_profile 

Step 2: Set the following variables 

ODBCHOME=/opt/informatica/9.5.1/ODBC7.0
LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH
ODBCINI=$ODBCHOME/odbc.ini; export ODBCINI
PATH=$PATH:$ODBCHOME/bin; export PATH
and Save it.

 Step 3:  Execute the following command to take effect 

. ./.bash_profile 



Inclusion of Netezza  Driver : 

NZ_ODBC_INI_PATH=/opt/informatica/ODBC7.1; export NZ_ODBC_INI_PATH
ODBCHOME=/opt/informatica/ODBC7.1; export ODBCHOME
LD_LIBRARY_PATH=$ODBCHOME/lib:$ODBCHOME/lib64:$LD_LIBRARY_PATH export LD_LIBRARY_PATH
ODBCINI=$ODBCHOME/odbc.ini; export ODBCINI

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




No comments:

Post a Comment