Teradata Aster
Connection Type | ODBC, OLE DB (64-bit) |
Driver Details | The ODBC driver can be downloaded from Teradata Aster. |
Type of Support | Read |
Validated On | 5.0, 6.0 |
Alteryx tools used to connect
Standard workflow processing
Input Data Tool
Output Data Tool
In-Database workflow processing
Connect In-DB Tool
Data Stream In Tool
Additional Details
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
Limitations
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.