17.10 - Overview - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

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 the 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 a database with data from an OLE DB data source) or a quick, one-time import from an OLE DB data source to a 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 > Database
  • Database > Teradata export utility > Teradata PT > Teradata Access Module for OLE DB > OLE DB provider > data source
  • Database > Teradata PT > 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 between databases than to use the Teradata Access Module for OLE DB as an intermediary.