IBM Netezza

Last modified: October 19, 2020
Connection Type

ODBC and OLEDB (32-bit), ODBC (64-bit)

Type of Support

Read & Write; In-Database

Validated On

Database version 4, 4.5, 7.0
ODBC client version
ODBC client version (In-DB)
ODBC Client Version 7.2.10-P0-F1-Bld46322
OLEDB client version

Alteryx Tools Used to Connect

Standard Workflow Processing

Input Data Tool Icon

Input Data Tool

Output Data Tool Icon

Output Data Tool

In-Database Workflow Processing

Blue icon with database being plugged in.

Connect In-DB Tool

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

Data Stream In Tool


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 (might 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.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.