Teradata Connector integrates

Data Integration

and Teradata Parallel Transporter Application Programming Interface (Teradata PT API) for data extraction and loading.

Teradata PT is a load and unload utility that extracts, transforms, and loads data from multiple sources in parallel. Teradata PT API provides high-speed, scalable, parallel data extraction, and bulk data load and update to the Teradata database.

To use Teradata Connector, create a task with a Teradata source

or target

. Use a Teradata connection in the task to connect to the Teradata tables that you want to export or load in a task. The Secure Agent uses the Teradata PT API infrastructure to connect to Teradata.

You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.

The Secure Agent loads data into Teradata using one of the following system operators that you specify in the mapping:

Load

Bulk loads data into an empty Teradata database table.

Update

Performs update, insert, upsert, and delete operations against Teradata database tables.

Stream

Performs update, insert, upsert, and delete operations against Teradata database tables in near real-time mode.