IBM Netezza

Version:
2023.1
Last modified: May 17, 2023
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

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.