Teradata Connector > Introduction to Teradata Connector

Introduction to Teradata Connector

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.