Using Access Modules to Read Data from an External Data Source - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Access modules are dynamically attached software components of the Teradata standalone load and unload utilities. Some access modules are usable with Teradata PT and provide the input/output interface between operators and various types of external data storage devices. Any operator that uses access modules can interface with all available access modules.

Be careful to specify the Teradata Parallel Transporter version of any access module you use.

The following access modules can be used as part of a job to move data from an external data source to Teradata Database.

 

Access Module

Description

Java Message Service (JMS)

Provides access to any JMS-enabled messaging system. Reads JMS transaction messages and sends the data to the DataConnector producer operator for transfer to a Teradata Database.

Teradata JMS Access Module caches the message throughput data stream in a fallback data file that supports checkpoint and restart functions.

Named Pipes

Provides access to data from a named pipe and sends it to a DataConnector producer operator.

The Teradata Named Pipes Access Module also caches the data input from a pipe in a fallback data file that supports checkpoint and restart functions.

This access module is not available on z/OS platforms.

OLE DB

Provides read access to data from an OLE DB provider application, such as Connix or SQL Server, which can access flat files, spreadsheets, and databases in an external data store.

WebSphere MQ

Provides access to transactional data from IBM WebSphereMQ.

The Teradata WebSphere MQ Access Module also caches the output message stream in a fallback data file that supports checkpoint and restart functions.