IBM Netezza

Type of Support: Read & Write; In-Database
Validated On: Database version 4, 4.5, 7.0
ODBC client version
ODBC client version (In-DB)
OLEDB client version
Connection Type: ODBC and OLEDB (32-bit), ODBC (64-bit)
Driver Details: The ODBC or OLEDB driver can be downloaded from IBM Netezza.

In-DB processing requires ODBC driver version 7 or later.

In-Database processing requires 64-bit database drivers.

Alteryx tools used to connect

Additional Details


Data Type Character String Limitations

  • The maximum character string size for vstring data types is 64,000.
  • The maximum character string size for wvstring data types is 16,000.

Database Version: 4.0 / 4.5

  • Maximum Columns In Table: 1600 (may be smaller because of tuple-lengths)
  • Maximum Column Name Length: 128 characters
  • Maximum Row Size: 65535 bytes
  • (No CLOB/BLOB datatype)

OLE DB (Version

  • UnicodeĀ® characters cannot be written but can be read.