The ODBC Operator Function in a Teradata PT Job - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The ODBC Operator Function in a Teradata PT Job

When you use the ODBC operator in a Teradata PT job, Teradata PT directs one instance of the operator to do the following:

1 Log on to a SQL session with an ODBC-compliant data source.

2 Send the SELECT request specified in the operator attribute 'SelectStmt' to the data source.

3 Retrieve the data returned from the data source.

4 Send data to the Teradata PT data streams.

5 Log off the SQL session.

6 If the ODBC operator job is successful, terminate the job and report the total number of records exported from Teradata Database.

7 If the job is unsuccessful, terminate the job and provide information about the job so that you can correct any problem and restart the job.

The ODBC operator does the following:

  • Accesses many ODBC-compliant data sources, for example, Oracle, SQL Server, DB2, etc.
  • Runs on all Teradata PT supported platforms
  • Reads data close to the sources (from the same machine where Teradata PT is running, as opposed to across a network)
  • Feeds data (via a data stream) directly to the Teradata Database without the need of an intermediate staging platform.