16.10 - Teradata Access Module for WebSphere MQ Features - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K

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.
Teradata Utilities Supported by the Teradata Access Module for WebSphere MQ
Operating System BTEQ FastLoad FastExport MultiLoad TPump Teradata PT
Linux 32-bit Yes Yes No Yes Yes Yes
UNIX
  • HP-UX
  • 32-bit and 64-bit
Yes Yes No Yes Yes Yes
  • IBM AIX
  • 32-bit and 64-bit
Yes Yes No Yes Yes Yes
  • IBM MVS
  • 32-bit
Yes Yes No Yes Yes Yes
Oracle Solaris
  • SPARC
  • 32-bit and 64-bit
Yes Yes No Yes Yes Yes
  • AMD Opteron
  • 32-bit
Yes Yes No Yes Yes Yes
Windows 32-bit Yes Yes No Yes Yes Yes
Mac 32-bit & 64-bit Yes No No No No Yes