Teradata
Connection Type | ODBC, OLE DB (64-bit) |
Driver Configuration Requirements | Bulk read and write support is available for standard workflows. Bulk write support is available for in-database workflows. |
Type of Support | Read & Write, In-Database |
Validated On | Database Version: 17.20 (driver 17.10 may not work). ODBC Client Version: 17.20.00.08 |
For more information about the Simba Athena ODBC driver, see the Simba ODBC documentation.
Alteryx Tools Used to Connect
Standard Workflow Process
Input Data Tool
![Input Data Tool Icon](../../image/uuid-44c39077-2b45-df80-e69b-b71155470a81.png)
Output Data Tool
![Output Data Tool Icon](../../image/uuid-c3b315b4-79eb-aeec-b68a-2dca910b2a6f.png)
In-Database Workflow Process
Connect In-DB Tool
![Blue icon with database being plugged in.](../../image/uuid-1a9d955f-dda6-bb9b-293b-18f515ee9c40.png)
Data Stream In Tool
![Blue icon with a stream-like object flowing into a database.](../../image/uuid-44c7f9d3-5dab-b8e3-89e0-b62d271e5a7d.png)
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
Supported Versions
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 String. DBTYPE_NUMERIC is not supported.
Date, Time, and Timestamp transported as a DBTYPE_STR. Native formats are not standard.
LOB data types can be read from a table but can't be written.
Limitations
Alteryx does not explicitly define either PRIMARY INDEX, PRIMARY AMP INDEX, or NO PRIMARY INDEX when creating a table. This means the Primary Index Default will be chosen by the system. For more information on Teradata Primary Index, see Teradata Online Documentation.