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.
| Operating System | BTEQ | FastLoad | FastExport | MultiLoad | TPump | Teradata PT | |
|---|---|---|---|---|---|---|---|
| Linux | 64-bit | Yes | Yes | No | Yes | Yes | Yes |
| UNIX |
|
Yes | Yes | No | Yes | Yes | Yes |
| IBM z/OS | 31-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 |