IBM Netezza

Version:
2021.2
Last modified: July 12, 2021
Connection Type

ODBC and OLEDB (32-bit), 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.12.1012

For more information about the Simba Netezza ODBC driver, see the Installation and Configuration Guide on Simba portal.

Alteryx Tools Used to Connect

Standard Workflow Processing

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

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

Unicode® characters cannot be written but can be read.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.