IBM Netezza
| Type of Support: | Read & Write; In-Database |
| Validated On: | Database version 4, 4.5, 7.0 ODBC client version 4.05.00.7623 ODBC client version 7.00.00.26407 (In-DB) OLEDB client version 4.05.0.7443 |
| Connection Type: | ODBC and OLEDB (32-bit), ODBC (64-bit) |
| Driver Details: | The ODBC or OLEDB driver can be downloaded from IBM Netezza. In-DB processing requires ODBC driver version 7 or later. In-Database processing requires 64-bit database drivers. |
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (For standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing).
Additional Details
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 (may 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.