17.00 - Product Descriptions - Teradata Tools and Utilities

Teradata® Tools and Utilities for Linux Installation Guide Amazon Linux 2, CentOS, OEL, RedHat, SLES, Ubuntu

prodname
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Installation
featnum
B035-3160-220K
Product Description
Basic Teradata Query

General-purpose utility that allows users on a workstation to communicate with one or more Vantage systems and 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

Enables ODBC applications running on Microsoft Windows, UNIX/Linux, and Apple macOS operating systems to communicate with the database using the open standard ODBC interface.

Shared ICU Libraries for Teradata

Library of routines based on IBM International Components for Unicode. The library provides Unicode support.

Teradata Access Module for S3 Component that allows to export data from S3 and to import data to S3. This utility works with the Teradata Parallel Transporter products.
Teradata Access Module for Azure Blob Component that allows to export data from Microsoft Azure Blob Storage and to import data to Microsoft Azure Blob Storage. This utility works with the Teradata Parallel Transporter products.
Teradata Access Module for GCS Component that allows to export data from Google Cloud Storage (GCS) and to import data to GCS. This utility works with the Teradata Parallel Transporter products.
Teradata Access Module for JMS

Command line utility that provides a fast, reliable, asynchronous way to transfer data between any JMS-enabled messaging system and Vantage. This utility works with the Teradata Parallel Transporter products as well as Teradata FastExport, Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump.

Teradata Access Module for Kafka Component that allows to export data from Apache Kafka and to import data to Apache Kafka. This utility works with the Teradata Parallel Transporter products.
Teradata Access Module for Named Pipes

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 as well as Teradata FastExport, Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump. It is accessible from the command line.

Teradata Access Module for WebSphere MQ

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 as well as Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump. It is accessible from a command line.

Teradata C Preprocessor2

Command line utility that provides the programmer of a C-based application a simplified way to read and change information stored in Vantage. This utility interprets and expands SQL statements that have been incorporated in an application program.

Teradata Call-Level Interface version 2

Library of routines that enable an application program to access data in Vantage.

Teradata Data Connector API 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

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

Teradata FastLoad

Quickly loads large amounts of data to empty tables in Vantage. This utility uses multiple sessions to load data into only one table in the database per job. This utility is accessible from the command line or a script.

Teradata GSS Administrative Package

Collection of tools used to configure the embedded TeraGSS and debug those configurations when configuration is required.

Teradata JDBC Driver

Library of routines that enables Java applications to connect to Vantage.

Teradata MultiLoad

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

Teradata Parallel Data Pump

Data loading utility that maintains (update, delete, insert, and atomic upsert) data in Vantage. 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

Package containing 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 perform high-speed, parallel data operations (extraction, loading, and updating) on Vantage.

Teradata Studio Express

Formerly known as Teradata SQL Assistant Java Edition, an information discovery tool that retrieves data from Vantage systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP). This allows the product to take advantage of the RCP framework for building and deploying native GUI applications to a variety of desktop operating systems.

Teradata Wallet

Package containing a library and a command line tool (tdwallet) that lets users securely store private information such as Vantage passwords on client computers. The stored information can then be recalled when logging in to Vantage.