IBM Netezza
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.18.1017 |
For more information about the Simba Athena ODBC driver, see the Simba ODBC documentation.
Alteryx Tools Used to Connect
Standard Workflow Processing
Input Data Tool
![Input Data Tool Icon](../../image/uuid-44c39077-2b45-df80-e69b-b71155470a81.png)
Output Data Tool
![Output Data Tool Icon](../../image/uuid-c3b315b4-79eb-aeec-b68a-2dca910b2a6f.png)
In-Database Workflow Processing
Connect In-DB Tool
![Blue icon with database being plugged in.](../../image/uuid-1a9d955f-dda6-bb9b-293b-18f515ee9c40.png)
Data Stream In Tool
![Blue icon with a stream-like object flowing into a database.](../../image/uuid-44c7f9d3-5dab-b8e3-89e0-b62d271e5a7d.png)
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.
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
Unicode® characters cannot be written but can be read.