Installation guide

4. Accessing Popular Databases

# SessionMode can be Teradata or ANSI

SessionMode =

# Cursor open checks

StCheckLevel = 0

# Enable TCP_NODELAY ?

TCPNoDelay = Yes

# Port to use on the database servers

TDMSTPortNumber =

# Use BLOB and CLOB ?

UseNativeLOBSupport = Yes

Also see the above driver notes regarding how to format the .odbc.ini file.

• Using these settings, you can then connect to Teradata using a simple

connection string such as:

"DSN=teradata;UID=username;PWD=password"

DataDirect ODBC Driver for Teradata

Homepage: http://www.datadirect.com/

4.10 Netezza

4.10.1 Available ODBC Drivers

Netezza ODBC Driver

Homepage: http://www.netezza.com/

Tested with Netezza 4.6.6 ODBC driver.

The Netezza ODBC driver is available to Netezza customers or partners.

eGenix.com partnered up with Netezza to make sure that mxODBC performs well

with Netezza's driver.

Recommended Setup

The recommended setup is to use the mx.ODBC.unixODBC subpackage together

with a unixODBC 2.3 or later ODBC manager.

The Netezza driver will also work with the DataDirect ODBC manager that ships

with the Netezza driver. If you use this setup, please interface to the DataDirect

ODBC manager using the

mx.ODBC.DataDirect subpackage.

Also note that when using the DataDirect ODBC Manager we have seen segfaults

related to the .odbc.ini file being too big. You can work around this by either

keeping the file short, or by setting up a separate netezza-odbc.ini file and

pointing the driver manager to it using the ODBCINI environment variable.