Last modified: May 17, 2023
ODBC, OLE DB (64-bit)
The ODBC driver can be downloaded from Teradata Aster.
|Type of Support||
Alteryx tools used to connect
Standard workflow processing
In-Database workflow processing
The Teradata bulk loader does not support BLOB or spatial objects. These field types can be written with standard ODBC.
The following dependent products are automatically installed:
- Shared ICU Libraries for Teradata
- Teradata Call-Level Interface version 2
- Teradata Data Connector API
- Teradata Generic Security Services Client
Database Version: 14.0, 14.10
Maximum Columns In Table: 2048
Maximum Column Name Length: 30 characters
Maximum Row Size: 64256 bytes (does not include LOB size)
ODBC Version 14 (32- and 64-bit drivers)
Fixed Numeric is supported in this version of the driver
OLEDB Client Version 14 (32- and 64-bit drivers)
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.