Skip to main content

[en] IBM Netezza

[en] Connection Type

[en] OLEDB, ODBC (64-bit)

[en] Type of Support

[en] Read & Write; In-Database

[en] Validated On

[en] Database Version: 7.2.10-P0-F1-Bld46322

[en] ODBC Client Version: 1.0.13.1012

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

[en] Alteryx Tools Used to Connect

[en] Standard Workflow Processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database Workflow Processing

[en] Connect In-DB Tool

Blue icon with database being plugged in.

[en] Link

[en] Data Stream In Tool

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

[en] Link

[en] Limitations

[en] Data Type Character String Limitations

  • [en] The maximum character string size for vstring data types is 64,000.

  • [en] The maximum character string size for wvstring data types is 16,000.

[en] Database Version: 4.0 / 4.5

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

  • [en] Maximum Column Name Length: 128 Characters

  • [en] Maximum Row Size: 65535 Bytes

  • [en] No CLOB/BLOB Datatype

[en] OLE DB (Version 4.5.0.7443)

[en] Unicode® characters cannot be written but can be read.

: