Skip to main content

[en] Teradata Aster

[en] Connection Type

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

[en] Driver Details

[en] The ODBC driver can be downloaded from Teradata Aster.

[en] Type of Support

[en] Read

[en] Validated On

5.0, 6.0

[en] Alteryx tools used to connect

[en] Standard workflow processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] In-Database workflow processing

[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] Limitations

[en] Database Version: 14.0, 14.10

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

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

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

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

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

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

: