Exporting with Teradata Export Utilities - 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
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities


The figure shows an overview of how data is exported from the database to a JMS-enabled client application through a Teradata export utility, namely FastExport or BTEQ. In general, the data flow is as follows:
  1. The Teradata export utility retrieves data from a database and transfers the data to Teradata Data Connector.
  2. Data Connector transfers the data to the Teradata Access Module for JMS.
  3. The Teradata Access Module for JMS uses JMS connection calls to access configured JMS administered objects, and connects to the JMS server.
  4. 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.
  5. The JMS server puts the messages on a specified queue or a certain destination, called a topic.
  6. The JMS server stores the messages until any other JMS-compliant application reads and removes them.