Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.

Expand All Subscribe to Teradata Developer Exchange - Tools content The Latest
Period data type support in Teradata MultiLoad

The Period data type is supported by Teradata Multiload as of TTU 13.0. A period represents an interval of time. It indicates when some particular event starts and when it ends. It has a beginning bound and an (optional) ending bound (the period is open if there is no ending bound). The beginning bound is defined by the value of a beginning element. The ending bound is defined by the value of an ending element. Those two elements of a period must be of the same type that is one of the three DateTime data types: DATE, TIME, or TIMESTAMP.

Teradata TPump dynamic buffer filling

TPump has been enhanced to dynamically determine the PACK factor and fill up data buffer if there is variable-length data. This feature is available in Teradata TPump,, and higher releases.

Data Mover User Pool

Data Mover currently uses ARC, TPTAPI and JDBC to extract data from a source system and load data to the target system. Based on different scenarios, Data Mover may choose to use one of the 3 mentioned load utilities.

When copying data from source to target, the user provides the login information for the source and target systems as part of the job definition that is used to login to the source and target systems to extract/load the data. There are certain limitations in providing the login information for each job that is executed:

iBatis (MyBatis) Custom Data Type Wizard

iBatis and MyBatis support custom types to override JDBC and other types when using the iBatis or MyBatis frameworks. A custom data type gives you the ability to deal with any kind of special input and output handling you may need for a database data type. For example, a User Defined Type (UDT)  that represents a point would require an X and Y Position to be entered for input and an X and Y position to be retrieved from the database. The custom data type gives you a clearly defined programmatic mechanism to do this.

Setting up your test environment with Teradata Data Mover

When it comes time to test your latest database application, Teradata Data Mover (DM) can easily be used to grab real world data from your production system to populate your test system.

Conquering Big Data with Teradata Data Mover parallelism

One of the big advantages that Teradata Data Mover (DM) provides is built-in parallelism. The underlying utilities that Teradata DM uses such as Teradata Parallel Transporter API do have methods available for users to do parallel work but either are limited to a single client machine or require the user to build their own code framework. Teradata DM takes care of all the hard work and puts the world of multiple client machine parallelism at your finger-tips.

But how to make best use of this parallelism for your big jobs? There’s a lot of power under the hood but it might not be obvious how to put that power to work. Here we’ll talk about what parallelism features are available and provide tips for how to use those to get your big data moving faster.

Selecting the right operator to use for your TPT job

Teradata Parallel Transporter (Teradata PT) has fourteen different operators. Each behaves differently. This article provides a table to help you in selecting the right operator to use for your Teradata PT job. You can view the table as Excel .xls or PDF.

Creating a Web Service with MyBatis and User Generated Keys

iBatis is now called MyBatis (iBatis 3.0). MyBatis is no longer sponsored by Apache. It is now supported on Google code. The MyBatis framework is a lightweight data mapping framework and persistence API. It couples objects with stored procedures or SQL statements using an XML descriptor.  The Teradata Plug-in for Eclipse allows you to switch between creating projects that use MyBatis or iBatis using the Teradata Project preferences. When you switch to use MyBatis, you can use new features like User Generated Keys.

User Generated Keys are unique identifiers returned from MyBatis during an insert operation. This tutorial will go through creating a Web service using user generated keys with MyBatis.

Using Teradata PT To copy from other databases

This article will show you how to use Teradata PT to copy data from one or more non-Teradata table(s) (e.g. Oracle table) to a Teradata table without using any intermediate disk storage. Teradata PT uses an ODBC operator as a producer to extract data from an Oracle table (as an example) and a Load operator as a consumer to load data into a Teradata table. You can modify the script to use other consumer operators such as Update, Stream or Inserter operator.

Tenacity / Sleep automatic adjustment in FastLoad

Teradata FastLoad has a feature named Tenacity that allows user to specify the number of hours that FastLoad continues trying to log on when the maximum number of load operations is already running on the Teradata Database.

By default the Tenacity feature is not turned on. The feature is turned on by the script command: