Installation guide

mxODBC - Python ODBC Database Interface
Netezza and Unicode
Unicode data exchange doesn't work well when using the Netezza driver with the
DataDirect manager.
The unixODBC manager interface does not have these issues and works fine with
Unicode if the Netezza driver is configured for UTF-16 data using the
UnicodeTranslationOption = utf16 driver configuration option.
Example Configuration for Unix
• Edit your ~/.odbcinst.ini file and add the Netezza driver (the location of
the driver and setup file may be different on your system):
[ODBC Drivers]
NetezzaSQL = Installed
[NetezzaSQL]
Driver = /usr/local/nz/lib64/libnzodbc.so
Setup = /usr/local/nz/lib64/libnzodbc.so
APILevel = 1
ConnectFunctions = YYN
Description = Netezza ODBC driver
DriverODBCVer = 03.00
DebugLogging = false
LogPath = /tmp
# For unixODBC, use the following setting:
UnicodeTranslationOption = utf16
# For DataDirect, use this setting:
#UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch = 256
Socket = 8192
• Edit your ~/.odbc.ini file and add a Netezza section (the location of the
driver may be different on your system). It is also necessary to point
LD_LIBRARY_PATH to the directory where the driver itself is located.
[netezza]
Driver = /usr/local/nz/lib64/libnzodbc.so
Description = NetezzaSQL ODBC
Servername = netezza.example.net
Port = 5480
Database = mydb
Username =
Password =
ReadOnly = false
ShowSystemTables = false
LegacySQLTables = false
LoginTimeout = 0
QueryTimeout = 0
DateFormat = 1
NumericAsChar = false
SQLBitOneZero = true
StripCRLF = false
securityLevel = preferredUnSecured
caCertFile =
# Needed by the DataDirect ODBC manager, values:
# 1=UTF-16, 2=UTF-8
DriverUnicodeType = 1
• Using these settings, you can then connect to Netezza using a simple
connection string such as:
"DSN=netezza;UID=username;PWD=password"
60