Skip to main content

Teradata Aster

Connection Type

ODBC, OLE DB (64-bit)

Driver Details

The ODBC driver can be downloaded from Teradata Aster.

Type of Support


Validated On

5.0, 6.0

Alteryx tools used to connect

Standard workflow processing

Input Data Tool

Input Data Tool Icon


Output Data Tool

Output Data Tool Icon


In-Database workflow processing

Connect In-DB Tool

Blue icon with database being plugged in.


Data Stream In Tool

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


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


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 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.