15.00 - Product Descriptions - Teradata Tools and Utilities

Teradata Tools and Utilities for Oracle Solaris on AMD Opteron Systems Installation Guide

prodname
Teradata Tools and Utilities
vrm_release
15.00
created_date
March 2014
category
Installation
featnum
B035-3126-034K
Product Description
Basic Teradata Query

Basic Teradata Query (BTEQ) is a general-purpose utility that allows users on a workstation to communicate with one or more Teradata Database systems and to format reports for output to print and screen. This utility is accessible from the command line or a script.

Open Database Connectivity (ODBC) Driver for Teradata

The Open Database Connectivity (ODBC) Driver for Teradata enables ODBC applications running on Microsoft Windows, UNIX/Linux and Apple OS X operating systems to communicate with the Teradata Database using the open standard ODBC interface.

Shared ICU Libraries for Teradata

Shared ICU Libraries for Teradata is a library of routines based on IBM International Components for Unicode. The library provides Unicode support.

Teradata Access Module for JMS

Teradata Access Module for JMS is a command line utility that provides a fast, reliable, asynchronous way to transfer data between any JMS-enabled messaging system and a Teradata Database. This utility works with the Teradata Parallel Transporter products and with Teradata FastExport, Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump.

Teradata C Preprocessor2

Teradata C Preprocessor2 (PP2) is a command line utility that provides the programmer of a C-based application a simplified way to read and change information stored in a Teradata Database. This utility interprets and expands SQL statements that have been incorporated in an application program.

Teradata Call-Level Interface version 2

Teradata Call-Level Interface version 2 (CLIv2) is a library of routines that enable an application program to access data in a Teradata Database.

Teradata COBOL Preprocessor2

Teradata COBOL Preprocessor2 is a command line tool that provides the programmer of a COBOL-based application with a simplified way to read and change information stored in a Teradata Database. This utility interprets and expands SQL statements that have been incorporated in an application program.

Teradata Data Connector API
Teradata Data Connector API is a component that reads and writes flat files to provide the input/output interface for access modules and BTEQ. For additional information about Teradata Data Connector API, see the following documents:
  • Teradata Tools and Utilities Access Module Programmer Guide, B035-2424
  • Teradata Tools and Utilities Access Module Reference, B035-2425
Teradata FastExport

Teradata FastExport uses multiple sessions to quickly transfer large amounts of data from tables and views of a Teradata Database to a client-based application. This utility is accessible from the command line or a script.

Teradata FastLoad

Teradata FastLoad quickly loads large amounts of data to empty tables in a Teradata Database. This utility uses multiple sessions to load data. However, it loads data into only one table in the database per job. This utility is accessible from the command line or a script.

Teradata Geospatial Utilities

Teradata Geospatial Utilities loads Shape file data into tables in a Teradata Database. It uses multiple sessions to load data, but it loads data into one table per layer on a Teradata Database.

Teradata GSS Client

Teradata GSS Client is the Teradata implementation of industry-standard Generic Security Services APIs in C language. This utility provides enhanced security services interfaces between Teradata network clients and a Teradata Database.

Teradata JDBC Driver

Teradata JDBC Driver is a library of routines that enables Java applications to connect to a Teradata Database.

Teradata MultiLoad

Teradata MultiLoad (MultiLoad) provides an efficient way to deal with batch maintenance of large databases. Useful for performing fast, high-volume maintenance on multiple tables and views of a Teradata Database. This utility is accessible from the command line or a script.

Teradata Named Pipes Access Module

Teradata Named Pipes Access Module is a component that provides an interprocess communication link between a writer process (such as Teradata FastExport) and a reader process (such as Teradata FastLoad). This utility works with the Teradata Parallel Transporter products and with Teradata FastExport, Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump. It is accessible from the command line.

Teradata Parallel Data Pump

Teradata Parallel Data Pump (TPump) is a data loading utility that helps maintain (update, delete, insert, and atomic upsert) the data in a Teradata Database. This utility uses standard Teradata SQL to achieve moderate to high data loading rates. Multiple sessions and multi-statement requests are typically used to increase throughput. It is accessible from the command line.

Teradata Parallel Transporter Base

Teradata Parallel Transporter Base is a package that contains the script-driven interface (Teradata Parallel Transporter) and the application programming interface (Teradata Parallel Transporter API). Teradata Parallel Transporter is an object-oriented and scalable client application that allows you to perform high-speed, parallel data operations (extraction, loading, and updating) on a Teradata Database.

Teradata Parallel Transporter Stream

Teradata Parallel Transporter Stream (Teradata PT Stream) contains the Teradata Parallel Transporter Stream Operator. Before you install Teradata Parallel Transporter Stream, Teradata Parallel Transporter Base must be installed. The Stream Operator emulates the Teradata Parallel Data Pump utility to perform high-speed DML transactions (SQL INSERT, UPDATE, DELETE, or UPSERT). Transactions are executed in a near-real-time mode on one or more tables in a Teradata Database while queries are performed on those tables.

Teradata Wallet

Teradata Wallet is a package that contains a library and a command line tool (tdwallet) that allows users to securely store private information such as Teradata Database passwords on client computers. The stored information can then be recalled when logging in to a Teradata Database.

Teradata WebSphere MQ Access Module

Teradata WebSphere MQ Access Module is a component that allows Teradata utilities to import data using IBM WebSphere MQ Access Module message queuing middleware. This utility works with the Teradata Parallel Transporter products and with Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump. It is accessible from a command line.