IBM Netezza

Version:
2019.3
Last modified: September 26, 2019
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.

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

Alteryx tools used to connect

Standard workflow processing

In-Database workflow processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

Link
Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

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.
Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.