17.10 - Teradata Access Module for WebSphere MQ Features - 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

A basic knowledge of WebSphere MQ and its APIs is required before attempting to configure and use the Teradata Access Module for WebSphere MQ. However, no direct access to APIs exists in the Teradata Access Module for WebSphere MQ.

The Teradata Access Module for WebSphere MQ allows Teradata utilities to import data using IBM WebSphere MQ message queuing middleware. The Teradata Access Module for WebSphere MQ transfers data between the WebSphere MQ client or server and the Data Connector. The Data Connector is the interface between the Teradata Access Module for WebSphere MQ and Teradata utilities.

WebSphere MQ provides connectivity between different types of applications that might be written in different languages or on different operating systems or networks. Platform-specific versions of the Teradata Access Module for WebSphere MQ provide the appropriate connectivity between different operating systems. This connectivity capability eliminates the need for the application developer to write code that provides this connectivity. Eliminating the need to write that code results in the following benefits:
  • Faster application development time
  • Transactional integrity (which means that messages are assured delivery)
  • Asynchronous delivery of messages
The Teradata Access Module for WebSphere MQ supplements the reliability and convenience of message queues with checkpoint and restart capability by caching data in a fallback data file. When used with utilities such as TPump to transfer data, the access module allows quick recovery from the following:
  • Restarts in the destination database
  • Crashes on the system running the import utility
  • Crashes on the data source, subject to the limitations of WebSphere MQ technology

Supported Utilities are listed in the following table.

Teradata Access Module for WebSphere MQ is compiled with the Sun Studio 11 version of compiler on Solaris SPARC platform. Use the same compiler for any application using Teradata Access Module for WebSphere MQ.
Operating System BTEQ FastLoad FastExport MultiLoad TPump Teradata PT
Linux 64-bit Yes Yes No Yes Yes Yes
UNIX
  • IBM AIX
  • 64-bit
Yes Yes No Yes Yes Yes
IBM z/OS 31-bit Yes Yes No Yes Yes Yes
Oracle Solaris
  • SPARC
  • 64-bit
Yes Yes No Yes Yes Yes
  • AMD Opteron
  • 64-bit
Yes Yes No Yes Yes Yes
Windows 64-bit Yes Yes No Yes Yes Yes
MacOS 64-bit Yes No No No No Yes