Welcome! Teradata Developer Exchange is a community-oriented tech website that connects Teradata engineers with developers and customers who are building and deploying solutions on our platforms. Think of it as a digital community of technical experts sharing ideas, code, best practices and lessons on solving problems. Sounds great doesn't it? So sign up and join the community now!

Expand All Syndicate content The Latest
Teradata Mainframe Client Utilities update

Teradata has completed a major compiler conversion effort that should be completely transparent to customers, yet they are the main beneficiaries.  This article:

  • Provides some historical background and context,
  • Discusses the reasons we switched compilers,
  • Identifies certain behavioral changes that were unavoidable,
  • And, finally, answers a few technical questions related to the overall process.

The venerable IBM mainframe was the original client platform developed for the Teradata RDBMS via channel-attached connections way back in the 1980s. Although we now support a wide range of client platforms using network-attached connections, a significant segment of our customer base continues to use mainframe clients.

lasca.js, custom Unicode sorting for internationalized web applications

A common problem with web applications is that sorting results are inconsistent between the front-end and back-end because the browser and server collation tables differ. These differences force a developer to do all sorting either in the front-end or back-end, which is not very good solution. An application should not have to pay a penalty of a network call just to sort and the server should not get pinged for every sort either. A developer should have the ability to select the best solution for a given problem.

A reliable rebooting mechanism for Data Mover Services

Data Mover is a Teradata Application that allows users to copy databases or tables between Teradata systems. It is a JEE based application that is composed of three major code components: the Client (Command-line interface or Viewpoint portlet), the Daemon, and the Agent. The Daemon is the central piece of the application and the Agent is a worker unit that does the actual job of moving data. Both the Damon and the Agent are deployed in a Linux managed server.

The Life of a Teradata Query

This presentation will follow a Teradata SQL query from its origin at the client...

Using Aster Express: Act 3, On the Road to nPath

The foundations of the Aster platform are a parallel database with all the features you'd expect from a SQL platform.  However the power of the Aster platform really shines once you start using its library of SQL-MR analytic components.  With these components, complex data analysis that is difficult to code in SQL becomes much, much easier.  A clear example of this can be seen with Aster's nPath module.

.NET Data Provider Reference

The following reference documentation is available:

DBQL Scripts

The DBQL setup and maintenance documents provides scripts, as well as information on how to perform DBQL logging, maintenance, and upgrade, now including Teradata 14.0.

Episode IV: A New Platform (Backbone.js + Require.js)

This is the final installment of a four part series on modularizing the Backbone.js Todos application using Require.js. It examines porting the application to the Pokki platform. 

.NET Data Provider for Teradata

The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET specification. It provides direct access to the Teradata Database and integrates with the DataSet. .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.

9.2 Quintillion? What's that all about?

A quintillion is 10 raised to the power of 18 (that is, 1 followed by 18 zeros).  9.2 quintillion (or more precisely, 9,223,372,036,854,775,807) is the new limit in Teradata Database 14.0 for the number of combined partitions.  Note that this is the same as the maximum BIGINT value (which is a signed 8-byte integer).  While tables that are defined with 65535 or less combined partitions still use 2-byte partitioning, if the number of defined combined partitions exceeds 65535 for a table, the table is created with 8-byte partitioning.