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 (32- and 64-bit) OLE DB with version 15 only supports 32-bit. |
ODBC, OLE DB (32- and 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 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.