Teradata Data Warehouse system components

Teradata Database Server

Teradata Database Server is optimized for viewing and managing large amounts of data. It is fully scalable, implements parallel processing, is fault tolerant and ensures integrity of the data.

The Teradata Database is comprised of a number of modules which are represented by:

Teradata Database Window

Database Window application controls the operation of the Teradata Database

Teradata Gateway

Teradata Gateway provides and controls communications, client messages and encryption

Parallel Data Extensions

Parallel Data Extensions (PDE) is a software that enables parallel processing in the Teradata database

Teradata Database management software

Teradata Database management software includes Parsing Engine (PE), Access module processor (AMP) and the Teradata file system

Teradata Tools and Utilities (TTU)

TTU is a set of client applications to facilitate access to the Teradata Database. The most widely used Teradata client tools are:

Teradata SQL Assistant

Teradata SQL Assistant - a graphical tool that provides quick and easy database development and administration access


BTEQ (Basic Teradata Query) is a batch query processing facility

Teradata loading tools

The Teradata loading and unloading applications include MultiLoad (MLoad), TPump, FastExport, FastLoad, Parallel Transporter

Teradata ODBC driver

ODBC Teradata Driver is used to access Teradata Database from other tools and environments. An JDBC Interface for accessing Java applications is also available

Teradata OLE DB

Teradata OLE DB Provider is an interface for manipulating data

Teradata Administrator

Teradata Administrator is a database administration interface for DBA's

Teradata CLIv2

Teradata Call-Level Interface (CLIv2) is an interface between applications and the Teradata Gateway

Teradata Database administration, monitoring and other tools

Teradata Manager

Teradata Manager is a set of graphical database management and controlling tools

Teradata Performance Monitor

Teradata Performance Monitor is an application used for monitoring database sessions, resources usage and performance statistics

Teradata Visual Explain

Teradata Visual Explain produces graphical presentation of SQL scripts

Teradata Index Wizard

Teradata Index Wizard tool helps increase the indexes performance

Teradata Statistics Wizard

Teradata Statistics Wizard automates statistics generation

Teradata ARC

Teradata ARC (Archive and Recovery) utility provides tape archive and recovery process for the Teradata Databases

Teradata MDS

Teradata MDS (Meta Data Services) is a metadata management system. The components of MDS include centrally managed Metadata Repository, an MDS engine, Metamodels and Teradata MetaSurf web based view into the metadata repository.

Teradata Warehouse Builder

Teradata Warehouse Builder (Teradata WB) is an object-oriented software system that executes multiple instances of ETL (extract-transform-load) processes in a scalable, parallel Teradata environment.

Teradata Resources

Teradata MultiLoad Guide
Teradata MultiLoad GuideThe Teradata MLoad tutorial guides through the process of importing, updating and deleting data on Teradata RDBMS using Teradata MultiLoad loading tool. The tutorial recommends...
Teradata TPump Tutorial
Teradata TPump TutorialThe Teradata tutorial presentation of using Teradata TPump in an Active Data Warehouse Environment shows the use, features and architecture of using TPump in great detail. It...
Teradata Presentation
Teradata PresentationThe Teradata presentation starts with a brief overview of data warehousing concepts and is followed by a complete illustration of the Teradata RDBMS architecture with an overview...
Teradata express
Teradata expressTeradata Express Edition is a free developer version of Teradata Software for Evaluation and Development, testing and learning. It is a fully featured installation of teradata. ...
Teradata MDS
Teradata MDSTeradata Meta Data Services (Teradata MDS) is an application which helps manage both business and technical metadata in an Enterprise Data Warehouse environment. The article...
Teradata EDW - Enterprise Data Warehouse
Teradata EDW - Enterprise Data WarehouseVendors information on the robust Teradata enterprise business intelligence framework. It provides high level information on the new features of the latest version, such as...
Teradata tutorial
Teradata tutorialA good Teradata tutorial which is divided into the following sections: Teradata components and introduction to Teradata database model Fundamental information on Teradata SQL...
String operations in Teradata
String operations in TeradataA tutorial article on how to handle character variables (strings) in Teradata SQL. The tutorial show how to concatenate strings, convert strings to hexadecimal value using...
Date and time manipulation in Teradata
Date and time manipulation in TeradataA tutorial article on how to handle date and time variables in Teradata (including discrapancies listing between V2R4 and V2R5). It contains information on timestamp data type...
Useful SELECT queries in Teradata SQL
Useful SELECT queries in Teradata SQLA quick tutorial on Select Queries in Teradata SQL. It describes the syntax of select statement, its use, a few useful examples and users' comments....
Microsoft and Teradata Solutions
Microsoft and Teradata SolutionsInformation page on combined Microsoft and Teradata Business Intelligence solutions. The page includes latest Teradata release features, a video on how enterprise data warehousing...
Teradata interview questions
Teradata interview questionsThe page contains around 20 interview questions with short answers. The page should be treated as a complementary source of information and may give a brief overview on questions...
Teradata certification materials
Teradata certification materialsGood source of information on Teradata trainings and certification. The site offers all in one Teradata certification course packages that will cover all the Teradata...
Teradata Magazine
Teradata MagazineTeradata magazine online. The magazine is a good source of information for the future of Teradata data warehousing, contains latest news, technical articles, viewpoints and case...
NCR: Teradata Forum
NCR: Teradata ForumThe Teradata forum contains over 2500 members and sometimes may result useful when used as an alternative to the bigger Teradata forums. Unfortunately, the threads are not...
Teradata.com Forum
Teradata.com ForumThe biggest and mostly visited Teradata forum on the vendor's webpages. It is divided into several sections, where the most popular and worth visiting are: Data Warehousing forum,...
The TeradataForum
The TeradataForumThe Teradata Forum has been established for people to share their interest in the Teradata product. The Forum is a privately owned, semi-moderated discussion group that is open to...
Teradata Support
Teradata SupportNCR Information Products Home provides information about Teradata applications, such as overview of all the products, information not included in the manuals, list of operating...