ODBC and OLEDB (32-bit), ODBC (64-bit)
The ODBC or OLEDB driver can be downloaded from IBM Netezza.
In-DB processing requires ODBC driver version 7 or later.
|Type of Support||
Read & Write; In-Database
Database version 4, 4.5, 7.0
Alteryx tools used to connect
Standard workflow processing
- 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 (may 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.