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.