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

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.