Teradata Connector stage

The Teradata Connector includes the following features of the ODBC Connector:

• Source, target and lookup context

• Reject links

• Passing LOBs by reference

• Arrays

• SQL Builder

• Pre/post run statements

• Metadata import

It supports Teradata server versions V2R6.1 and V2R6.2 and Teradata client

TTU versions V8.1 and V8.2. The Connector uses CLIv2 API for immediate

operations (SELECT, INSERT, UPDATE, DELETE) and Parallel Transporter

Direct API (formerly TEL-API) for bulk load and bulk extract operations.

Parallel bulk load is supported through LOAD, UPDATE, and STREAM operators

in Parallel Transporter. This corresponds to the functionality provided by the

FastLoad, MultiLoad, and TPump Teradata utilities, respectively. When the

UPDATE operator is used it supports the option for deleting rows of data

(MultiLoad delete task).

Parallel bulk export is supported through the EXPORT operator in Parallel

Transporter. This corresponds to the functionality provided by the FastExport

Teradata utility. The Connector persists the bulk-load progress state and provides

sophisticated support for restarting the failed bulk-load operations. The

Connector uses a designated database table for synchronization of distributed

Connector instances in the parallel bulk-load.