ODBC, OLE DB (32- and 64-bit)
OLE DB with version 15 only supports 32-bit.
The ODBC driver can be downloaded from Teradata Aster.
|Type of Support||
Alteryx tools used to connect
Standard workflow processing
Maximum Columns In Table: 2048
Maximum Column Name Length: 30 characters
Maximum Row Size: 64256 bytes (does not include LOB size)
Fixed Numeric is supported in this version of the driver
Fixed Numeric is transported as a Strings; DBTYPE_NUMERIC is not supported.
Date, Time, and Timestamp transported as a DBTYPE_STR; native formats not standard.
LOB datatypes can be read from a table but can't be written.