Features
A basic knowledge of WebSphere MQ and its APIs is required before attempting to configure and use the Teradata WebSphere MQ Access Module. However, no direct access to APIs exists in the WebSphere MQ Access Module.
The Teradata WebSphere MQ Access Module allows Teradata utilities to import data using IBM WebSphere MQ message queuing middleware. The Teradata WebSphere MQ Access Module transfers data between the WebSphere MQ client or server and the Data Connector. The Data Connector is the interface between the Teradata WebSphere MQ Access Module 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 WebSphere MQ Access Module 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:
The Teradata WebSphere MQ Access Module 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:
Supported Utilities are denoted in Table 8.
Note: Teradata WebSphere MQ Access Module is compiled with the Sun Studio 11 version of compiler on Solaris SPARC platform. Use the same compiler for any application using Teradata WebSphere MQ Access Module.
Operating System |
BTEQ |
FastLoad |
FastExport |
MultiLoad |
TPump |
Teradata PT |
|
Linux |
32‑bit |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
UNIX |
HP‑UX |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
IBM AIX |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
|
IBM MVS |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
|
Oracle Solaris |
SPARC |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
AMD Opteron |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
|
Windows |
32‑bit |
Yes |
Yes |
No |
Yes |
Yes |
Yes |