Skip to main content

[en] Teradata

[en] Connection Type

[en] ODBC, OLE DB (64-bit)

[en] Driver Configuration Requirements

[en] Bulk read and write support is available for standard workflows. Bulk write support is available for in-database workflows.

[en] Type of Support

[en] Read & Write, In-Database

[en] Validated On

[en] Database Version: 17.20 (driver 17.10 may not work).

[en] ODBC Client Version: 17.10.00.014

[en] For more information about the Simba Athena ODBC driver, see the Simba ODBC documentation.

[en] Alteryx Tools Used to Connect

[en] Standard Workflow Process

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database Workflow Process

[en] Connect In-DB Tool

Blue icon with database being plugged in.

[en] Link

[en] Data Stream In Tool

Blue icon with a stream-like object flowing into a database.

[en] Link

[en] Additional Details

[en] The Teradata bulk loader does not support BLOB or spatial objects. These field types can be written with standard ODBC.

[en] The following dependent products are automatically installed:

  • [en] Shared ICU Libraries for Teradata

  • [en] Teradata Call-Level Interface version 2

  • [en] Teradata Data Connector API

  • [en] Teradata Generic Security Services Client

[en] Supported Versions

[en] Database Version: 14.0, 14.10, 15.10.08, 16.20

[en] Maximum Columns In Table: 2048

[en] Maximum Column Name Length: 30 Characters

[en] Maximum Row Size: 64256 Bytes (does not include LOB size)

[en] ODBC Version 14 (32-bit and 64-bit drivers)

[en] Fixed Numeric is supported in this version of the driver.

[en] OLEDB Client Version 14 (32-bit and 64-bit drivers)

[en] Fixed Numeric is transported as a String. DBTYPE_NUMERIC is not supported.

[en] Date, Time, and Timestamp transported as a DBTYPE_STR. Native formats are not standard.

[en] LOB data types can be read from a table but can't be written.

[en] ODBC Version 15.10.08

[en] Limitations

[en] 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.

: