Teradata

Version:
2023.1
Last modified: May 17, 2023
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.10
ODBC Client Version: 17.10.00.014

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

Alteryx Tools Used to Connect

Standard Workflow Process 

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

In-Database Workflow Process

Link
Blue icon with database being plugged in.

Connect In-DB Tool

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

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

Supported Versions

Database Version: 14.0, 14.10, 15.10.08, 16.20

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-bit and 64-bit drivers)

Fixed Numeric is supported in this version of the driver.

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

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.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.