Teradata
| Teradata | Teradata Aster | |
|---|---|---|
| Type of Support: | Read & Write; In-Database | Read |
| Verified On: | 15, 15.10 | 5.0, 6.0 |
| Connection Type: |
ODBC, OLE DB (64-bit) OLE DB with version 15 only supports 32-bit. |
ODBC, OLE DB (64-bit) OLE DB with version 15 only supports 32-bit. |
| Driver Details: | The ODBC driver can be downloaded from Teradata. Bulk read and write support is available for standard workflows. Bulk write support is available for in-database workflows. In-Database processing requires 64-bit database drivers. |
The ODBC driver can be downloaded from Teradata Aster. |
Alteryx tools used to connect:
- Input Data Tool and Output Data Tool (For standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing).
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
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.