15.10 - Features - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

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:

  • Faster application development time
  • Transactional integrity (which means that messages are assured delivery)
  • Asynchronous delivery of messages
  • 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:

  • 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 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.

     

    Table 8: Teradata Utilities Supported by the WebSphere MQ Access Module 

    Operating

    System

    BTEQ

    FastLoad

    FastExport

    MultiLoad

    TPump

    Teradata PT

    Linux

    32bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    UNIX

    HPUX
    32bit and 64bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    IBM AIX
    32
    bit and 64bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    IBM MVS
    32
    bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    Oracle Solaris

    SPARC
    32
    bit and 64bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    AMD Opteron
    32
    bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    Windows

    32bit

    Yes

    Yes

    No

    Yes

    Yes

    Yes