Skip to main content

IBM Netezza

Connection Type

OLEDB, ODBC (64-bit)

Type of Support

Read & Write; In-Database

Validated On

Database Version: 7.2.10-P0-F1-Bld46322

ODBC Client Version: 1.0.18.1017

For more information about the Simba Athena ODBC driver, see the Simba ODBC documentation.

Alteryx Tools Used to Connect

Standard Workflow Processing

In-Database Workflow Processing

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.

  • Maximum Columns In Table: 1600 (might be smaller because of tuple-lengths)

  • Maximum Column Name Length: 128 Characters

  • Maximum Row Size: 65535 Bytes

  • No CLOB/BLOB Datatype

Unicode® characters cannot be written but can be read.