16.20 - Product Descriptions - Teradata Tools and Utilities

Teradata® Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-09-23
dita:mapPath
agd1527114222312.ditamap
dita:ditavalPath
windows_No_ie.ditaval.ditaval
Product Description

.NET Data Provider for Teradata

Library of routines that Microsoft .NET Framework applications use for uniform and standard-based (ADO.NET) access to data sources such as a Teradata Database. This is the data access component of the .NET Framework Class Library.

Basic Teradata Query

General-purpose utility that allows users on a workstation to communicate with one or more Teradata Database 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 OS X operating systems to communicate with the Teradata 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 JMS

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 as well as Teradata FastExport, Teradata FastLoad, Teradata MultiLoad, and Teradata Parallel Data Pump.

Teradata Access Module for Kafka Teradata Access Module for Kafka is a 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 OLE DB

Command line utility that acts as an interface between Teradata load and export utilities (Teradata FastLoad, Teradata FastExport, Teradata MultiLoad, Teradata Parallel Data Pump, Teradata Parallel Transporter, and Basic Teradata Query) and data sources for which an OLE DB provider is available. The access module quickly moves data between an OLE DB data source and a Teradata Database without requiring intermediate storage.

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 Archive/Recovery Utility

Command line utility that writes and reads sequential files on a Teradata client system to archive, restore, recover, and copy data in a Teradata Database table. Through its associated script language, it also provides an interface between the Teradata backup applications solutions and the Teradata Database.
Teradata Archive/Recovery Utility is included to support Teradata third-party backup applications.

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 a Teradata Database. 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 a Teradata Database.

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

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

Quickly loads large amounts of data to empty tables in a Teradata Database. 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 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.

Teradata GSS Administrative Package

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

Teradata Index Wizard

Windows-based GUI application that allows a Teradata Database administrator to create or identify a workload, perform index analysis for a workload, and verify and apply index recommendations. This utility increases efficiency and maximizes system performance.

Teradata JDBC Driver

Library of routines that enables Java applications to connect to a Teradata Database.

Teradata 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 Parallel Data Pump

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

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 a Teradata Database.
The following Teradata Parallel Transporter Operators are installed as part of the Teradata Parallel Transporter Base:
  • DataConnector Operator
  • DDL Operator
  • Export Operator
  • FastExport OUTMOD Adapter Operator
  • FastLoad INMOD Adapter Operator
  • Load Operator
  • MultiLoad INMOD Adapter Operator
  • ODBC Operator
  • Operator Support Library
  • OS Command Operator
  • Schema Mapping Operator
  • SQL Inserter Operator
  • SQL Selector Operator
  • Teradata Parallel Transporter API
  • Teradata Parallel Transporter ICU Library
  • Teradata Parallel Transporter Wizard
  • Update Operator

Teradata Parallel Transporter 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 Query Scheduler Administrator

Windows-based GUI application that enables the database administrator to manage workloads submitted to a Teradata Database.

Teradata Query Scheduler Client

Windows-based GUI application that lets you submit scheduled SQL requests to Teradata Query Scheduler Server and view information about scheduled jobs.

Teradata Query Scheduler Server

Windows service that saves, processes, and executes requests that are scheduled from the Teradata Query Scheduler Client.

Teradata SQL Assistant

Windows-based GUI application that lets you retrieve, manipulate, and store data from ODBC-compliant database servers.

Teradata Studio Express

Formerly known as Teradata SQL Assistant Java Edition, an information discovery tool that retrieves data from Teradata Database 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 System Emulation Tool

Windows-based GUI application that emulates Optimizer-generated data from a target system, generates query plans, and then imports that information to a test system where queries can be run without impacting the production system.

Teradata Visual Explain

Windows-based GUI application that adds another dimension to the EXPLAIN modifier by depicting the execution plan of complex SQL statements in a simplified manner. It presents a graphical view of the statement broken down into discrete steps that show the flow of data during execution.

Teradata Wallet

Package containing a library and a command line tool (tdwallet) that lets users 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 Workload Analyzer

Windows-based GUI application that analyzes and generates candidate workloads. This utility provides three major areas of guidance:
  • Recommends workload group definitions (the database administrator guides these definitions based on business knowledge and existing workload mix and characteristics)
  • Recommends appropriate workload goals
  • Recommends mapping of workloads to allocation groups (AGs) and priority scheduler weights