Importing Data - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-05-14
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
lifecycle
latest
Product Category
Teradata Tools and Utilities


The figure shows an overview of how data is imported from a JMS client application to the database. In general, the data flow is as follows:
  1. The client component sends a data message to a MOM service provider.
  2. Depending on the messaging model, the JMS message server retrieves the data message from a queue or topic within a MOM service provider.
  3. At the software code level, the Teradata Access Module for JMS uses JMS connection calls to access the configured JMS-administered objects to connect to the JMS server.

    Each service provider has its own proprietary implementation of connections to communicate with the JMS server and an administrative tool to configure the connection and queue objects. The Teradata Access Module for JMS is expected to use the Java Naming Directory Interface (JNDI) namespace to locate those JMS-administered objects.

  4. The Data Connector initiates a sequence of instructions so the Teradata Access Module for JMS can get the data messages from the queue or topic. This sequence of instructions may include the access module Initialize, File Open, File Read, File Get Position, and Shutdown commands. See also Interface with the Data Connector.
  5. The Teradata Access Module for JMS reads the data from the queue or topic. It copies the data to a fallback data file for checkpoint and restart purposes and then delivers it to the Data Connector.
  6. The Data Connector transfers the data to a Teradata utility, such as BTEQ, FastLoad, MultiLoad, or TPump.
  7. The Teradata load utility processes and loads the data into a table in the database.