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
0Awesome Comments!