Teradata Parallel Transporter (TPT) is a flexible, high-performance Data Warehouse loading tool, specifically optimized for the Teradata Database, which enables data extraction, transformation and loading. TPT incorporates an infrastructure that provides a parallel execution environment for product components called “operators.”  These integrate with the infrastructure in a "plug-in" fashion and are thus interoperable.

TPT operators provide access to such external resources as files, DBMS tables, and Messaging Middleware products, and perform various filtering and transformation functions. The TPT infrastructure includes a high performance data transfer mechanism called the data stream, used for interchanging data between the operators.

With today's businesses directly tied to mission-critical applications for decision making, continuity and availability are vital requirements for the success of Active Data Warehousing. As such, plans for recovery from any failure must be introduced into the design and deployment of ETL jobs as early as possible. One of the main challenges for such a plan or ETL design is how to quickly recover from a failure.

“Yum” is a package-management utility for RPM-compatible Linux operating systems that can be utilized by the Teradata Client packaging to allow an administrator to manage a repository of packages for network installation and software distribution.  “YUM” stands for “Yellowdog Updater, Modified” and is an open-source, command-line product included with RedHat Enterprise Linux, and Fedora Linux.    This document will explain how to set up a simple Yum repository with the Linux Teradata Client packages, and how to use the resulting repositories to install packages across the network.

Teradata provides advanced Workload Management capabilities through Teradata Active System Management (TASM). However, some customers are still relying on only Priority Scheduler, without TASM's added capabilities. These customers can easily move forward to TASM. This article shows how to use Teradata Workload Analyzer (TWA) to migrate existing Priority Scheduler settings into TASM.

Apache Ant allows the user to run a SQL task using JDBC. The Teradata SQL Ant Wizard allows you to wrap selected SQL Statements into an Ant build script from the Eclipse DTP SQL Editor.

The XML Ant build script generated from the Wizard runs the selected SQL statements inside or outside of Eclipse. The Ant build script will facilitate a consistent setup of test or base production environments. This creates a mechanism to run SQL reports and to integrate with build or schedule tools. 

CRUD is defined as the following functions of persistent storage:

• Create — Insert a row into a Database Table
• Read — Selecting information from a Database Table
• Update — Update a row for a Database Table
• Delete — Remove a row from a Database Table

The iBatis CRUD Wizard will generate the SQL and the iBatis code for all the CRUD operations for a selected database table in the Teradata Plug-in for Eclipse.  The generated iBatis SQL map can then be used to create a Web Service or used to create a Java application that uses the iBatis frame work. This will give you a quick and easy way to create an application that can do basic operations on a Teradata database table.

When it comes to establishing Teradata Database sessions, you may find that using BTEQ’s LOGON command by itself is not sufficient to pass along your credentials for user authentication. This article will explain what other commands you might need to use.