16.10 - Overview - 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

The Teradata Access Module for OLE DB is a dynamic link library (DLL) that acts as an interface between Teradata load and export utilities (Teradata FastLoad, Teradata FastExport, Teradata MultiLoad, TPump, Teradata Parallel Transporter [PT], and BTEQ) and data sources for which an OLE DB provider is available. The access module quickly moves data between OLE DB data sources and Teradata Database without requiring intermediate storage.

The access module can be used to view, edit, and re-run access module job (.amj) files, or to perform a quick, one-time copy (to create a new table in Teradata Database with data from an OLE DB data source) or a quick, one-time import from an OLE DB data source to Teradata Database.

The Teradata Access Module for OLE DB offers the following options to move data:
  • Data source > OLE DB provider > Teradata Access Module for OLE DB > Teradata load utility / Teradata PT > Teradata Database
  • Teradata Database > Teradata export utility > Teradata PT > Teradata Access Module for OLE DB > OLE DB provider > data source
  • Teradata Database > Teradata PT > Teradata Database

The Teradata Access Module for OLE DB creates a new table during load operations if no target table already exists, and adds (imports) to existing tables. The exception is when FastLoad/Teradata PT load operator is used for imports, in which case the load operation only works on an empty table. In other words, a load operation that uses FastLoad/Teradata PT load operator cannot load to existing tables.

You can use the Teradata Access Module for OLE DB to accomplish the following processes:
  • Use the access module graphical user interface (GUI):
    1. Open the GUI for the Teradata Access Module for OLE DB (nicknamed Teradata OleLoad), and select a data source and destination.
    2. Save the job as an .amj file.
    3. Select a Teradata utility to transfer (load or export) the data, generate a script, and run the job.

    For more information, see Loading and Exporting with OleLoad.

  • Run the access module from a Teradata load and export utility at the command prompt:
    1. In a Teradata utility, write a script that references the Teradata Access Module for OLE DB and a previously saved .amj file.
    2. Run the script.

    For more information, see Loading and Exporting at the Command Prompt.

It is more efficient to use load/unload utilities directly while doing copy operations from Teradata Database to Teradata Database than to use the Teradata Access Module for OLE DB as an intermediary.