Glossary - Access Module

Teradata Tools and Utilities Access Modules User Guide

Product
Access Module
Release Number
15.10
Language
English (United States)
Last Update
2018-06-06
Product Category
Teradata Tools and Utilities

A

application programming interface (API)

The calling conventions by which an application program accesses the operating system and other services. An API is defined at source code level and provides a level of abstraction between the application and the kernel to ensure the portability of code. May also provide an interface between a high‑level language and lower‑level services.

B

Basic Teradata Query (BTEQ)

A utility that allows users on a workstation to access data on a Teradata Database, and format reports for both print and screen output.

A CLI application program used to interact with the Teradata Relational Database Management System (RDBMS). BTEQ commands are used for controlling sessions, submitting Teradata SQL requests, formatting results, and handling output data. BTEQ may also be used to verify the installation of Teradata client utilities.

D

Domain Name Services (DNS)

Data query service chiefly used on the Internet for translating hostnames into Internet addresses. Also, the style of hostname used on the Internet, though such a name is properly called a fully qualified domain name. DNS can be configured to use a sequence of name servers, based on the domains in the name being looked for, until a match is found.

F

FIFO

First in, first out An access method for a queue data structure pertaining to how data is loaded and retrieved.

O

open database connectivity (ODBC)

An application programming standard that defines common database access mechanisms to simplify the exchange of data between a client and server. ODBC‑compliant applications connect with a database through the use of a driver that translates the application’s ODBC commands into database syntax.

OLE DB

A set of Microsoft COM interfaces that allow uniform and consistent access to diverse data sources.

OLE DB Access Module

See Teradata OLE DB Access Module.

OLE DB Provider

A software module that exposes OLE DB interfaces to allow access to a specific data source. For example, Microsoft OLE DB Provider for SQL Server is an OLE DB provider that provides access to data located in a Microsoft SQL Server database.

OleLoad

The GUI for the Teradata OLE DB Access Module, used to create, view, and edit .amj files. Teradata OleLoad can launch a Teradata utility.

S

structured query language (SQL)

An industry‑standard language for creating, updating, and querying relational database management systems. Originally developed by IBM, it is often embedded in general‑purpose programming languages.

T

Teradata OLE DB Access Module

An access module created by Teradata that provides a basic input/output interface between Teradata load and export utilities and OLE DB data sources. It supports load operations to and export operations from a Teradata Database.

Teradata OLE DB Access Module allows you to select a data source from OLE DB data sources, create and save an access module job (.amj) file, and then use the .amj file to load the source data to a Teradata Database.

U

universal naming convention (UNC)

Used in IBM PC networking to completely specify a directory on a file server.