16.10 - Exporting from an ODBC-Compliant Data Source (Using Teradata PT) - Access Module

Teradata Tools and Utilities Access Module Reference

Access Module
July 2017
Programming Reference

The Teradata Access Module for JMS can also be transparently used with any Teradata Parallel Transporter (PT) producer operator, such as the ODBC Operator, through the Teradata PT DataConnector Operator.

Exporting from ODBC-Compliant Data Sources

The figure shows an overview of the data flow between any ODBC-compliant data source and a JMS client application using the Teradata Access Module for JMS. In general, the process is as follows:
  1. Teradata PT ODBC Operator connects to an ODBC-compliant data source, for example, Oracle, SQL Server, or DB2.
  2. The operator reads data close to the sources (from the same machine where Teradata PT is running, as opposed to across a network).
  3. The operator feeds the data (via data stream) to Teradata PT Data Connector.
  4. Teradata PT Data Connector transfers the database records to the Teradata Access Module for JMS.
  5. The Teradata Access Module for JMS uses the JMS connection calls to access configured JMS-administered objects, and connects to the JMS server.
  6. The Teradata Access Module for JMS composes database records into messages (the export utility defines the database record format), and sends the messages to a JMS server.
  7. The JMS server puts the messages on a specified queue or a certain destination, called a topic.
  8. The JMS server stores the messages until any other JMS-compliant application reads and removes them.