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.13.1012

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

Alteryx Tools Used to Connect

Standard Workflow Processing

Input Data Tool

Input Data Tool Icon

Link

Output Data Tool

Output Data Tool Icon

Link

In-Database Workflow Processing

Connect In-DB Tool

Blue icon with database being plugged in.

Link

Data Stream In Tool

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

Link

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.