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

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

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.



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.