Welcome! Teradata Developer Exchange is a community-oriented website that connects Teradata Associates with Customers and others interested in the related technologies. Think of it as a technical collaborative community for sharing ideas, asking questions, learning, and solving problems related to Teradata solutions and beyond. Sounds great doesn't it? So sign up and join the community now!

Expand All Subscribe to Teradata Developer Exchange - All content The Latest
Hitchhikers' Guide to using Excel with Teradata

It is believed that the computer called Deep Thought in the famous Douglas Adams' novel, “The Hitchhiker’s Guide to the Galaxy,” used Excel in the last step of figuring out the meaning of life. It is too bad Deep Thought couldn’t access the data in Teradata Database and let Teradata do the analytics because it would've figured out the meaning of life much sooner.

Throttlepedia: A Detailed Look at Teradata Concurrency Control

Throttles are the most popular Teradata workload management option today. This webinar provides a simple yet thorough explanation of how these concurrency control rules actually work, reviewing the basics as well as focusing on important enhancements in the Teradata 13.10 and 14.0 releases.

Preserving Data Integrity when TPT Export to Stream Job Restarts

This article describes how to preserve data integrity when a Teradata Parallel Transporter (Teradata PT) export to stream job restarts.

Database Tasks that Run on the Parsing Engine

Most of us are aware of AMP worker tasks, and some of us are even obsessive about not running out of this finite resource.  But that’s on the AMP.  What about the tasks supporting user work on the parsing engine (PE)?  Should we be just as vigilant about what’s happening with tasks at the PE level?

Not really.  Here’s why.

Teradata Parallel Transporter: Leveraging Customer Focused New Features

Teradata Parallel Transporter is the premiere client load/unload tool, providing parallel extraction and loading of critical data.

A Day in the Life of a Unity Data Mover Job

Unity Data Mover (DM) is built to handle multiple requests to move objects concurrently. Understanding how DM processes these requests is benefitial to those looking to get the most out of their DM installations.

The easiest way to explain how DM handles work is to take a user request to move data and follow it through its life cycle. Along the way, we'll see how various user controlled settings affect the request and provide suggestions for how one might improve work throughput.

Large and Cheap: 3D Printing

I’ve written a few blogs on the future of 3D printing and its impact on manufacturing and data analytics in the future, or as Chris Anderson stated, “The long tail of things.”  But, up to now, 3D printing has been expensive and mostly for small objects.

How to Support "Resizing" for Viewpoint Portlets

Teradata Viewpoint 14.01 introduces a wider, more flexible layout, which better utilizes space on wide screen monitors, and gives the user more flexibility in controlling how much information is being displayed.


Extended Object Names in the .NET Data Provider

In Teradata Database Release 14.10 object names have been lengthened from 30 bytes of a Latin or KANJISJIS character set to 128 Unicode characters. This capability supports a richer set of characters to compose object names. While using a session character set that may contain limitations due to the supported set of characters, Unicode delimited identifiers are supported in all SQL text statements. Please see the SQL Data Types and Literals manual for information on Unicode delimited identifiers.

Displaying Tabular Data using the DataGrid and BigNumbers Widget

The following tutorial is a guide on how to implement the Viewpoint DataGrid and BigNumbers Widget.  In this example we will show how these widgets were incorporated into the SkewedSessions Portlet.  The actual source code can be found in the SkewedSessions Portlet supplied in PDK version 14.01.