Netezza ODBC config in Linux
Netezza
ODBC config in Linux
1)
Configuration ODBC
Modify
.odbc.ini file under $DSHOME and add 2 entries:
a)
in the [ODBC Data Sources] section add an entry with the name of the
DSN. Example:
NZSQL=NetezzaSQL
[NZSQL]
Driver=/usr/local/nz/lib/libnzsqlodbc.so
Description=NetezzaSQL
ODBC
Servername=netezza.server.com
Port=5480
Database=asctest
Username=admin
Password=password
CancelAsFreeStmt=false
CommLog=false
Ksqo=false
Lie=false
Optimizer=false
Parse=false
PreFetch=256
Protocol=7.0
ReadOnly=false
ShowSystemTables=false
Socket=16384
DateFormat=1
TranslationDLL=
TranslationName=
TranslationOption=
b)
Update the uvodbc.config with the entry you created above.
2)
Create a soft link to the .odbc.ini and call it odbc.ini (the Netezza
client looks for an odbc.ini file, it won't find the .odbc.ini)
3)
Modify the dsenv file
a)
Add the variable NZ_ODBC_INI_PATH -
b)
Add the variable NETEZZA. This should point to the place where the
Netezza
client
has been installed.
c)
Add $NETEZZA/bin to PATH
d)
Add $NETEZZA/lib to the LD_LIBRARY_PATH OR LIBPATH or SHLIB_PATH
Example:
########
Add Netezza path information ########################
Netezza_Home=/usr/local/nz/lib64
NZ_ODBC_INI_PATH=/opt/InformationServer/Server/DSEngine
PATH=$PATH:$NZ_ODBC_INI_PATH
export
PATH NZ_ODBC_INI_PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$Netezza_Home
export
LD_LIBRARY_PATH
Reference:
Troubleshooting: