IBM Netezza

Type of Support: Read & Write; In-Database
Validated On: Database version 4, 4.5, 7.0
ODBC client version 4.05.00.7623
ODBC client version 7.00.00.26407 (In-DB)
OLEDB client version 4.05.0.7443
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

Limitations

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 4.5.0.7443)

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