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 Subscribe to Teradata Developer Exchange - All content The Latest
Statistics Collection in Teradata 14.0

Statistics about tables, columns and indexes are a critical component in producing good query plans.

Using the Apache Derby ij tool with the Teradata JDBC Driver

Oracle (Sun) JDK 6.0 and JDK 7.0 include the Apache Derby database, which is implemented in 100% Java. 

This article is not about the Apache Derby database; instead, this is about a command-line interactive SQL tool that is included with Apache Derby. 

The Apache Derby "ij" interactive SQL tool is quite useful. It is a command-line SQL tool similar to BTEQ, and it works with any JDBC Driver and any database, not just the Apache Derby database. 

The following instructions show how to use the ij tool with the Teradata JDBC Driver. 

Hands-on with Teradata Aster Express

The new Teradata Aster Express virtual images bring the powerful analytics of the Aster platform to any PC or workstation. 

Limiting BTEQ's Verbosity via ECHOREQ ERRORONLY

Do you need to reduce the amount of informational messages that BTEQ produces? Then try out the enhanced version of the BTEQ 14.10 command "SET ECHOREQ".

This article explains how to use ECHOREQ command's ERRORONLY option to instruct BTEQ to only echo back SQL requests that fail.

Teradata Mapping Manager

Teradata Mapping Manager is a Java-based desktop application/tool used by our professional services consultants to aid in the mapping of data and requirements. The mapping metadata is stored in a Teradata database.

Teradata Viewpoint 14.10 Release

This article is the official release announcement of Teradata Viewpoint 14.10 with an effective release date of May 6th 2013. With new enhancements in Alerting, Workload Management and Monitoring areas, this release of Viewpoint 14.10 continues to expand its scope and provide ability to monitor Hadoop systems along with Aster and Teradata systems.

TTU Install Documentation

The TTU Install Documentation explains how to install Teradata Tools and Utilities software from delivery media, configure the applications when required, and verify installation. Additionally, instructions for deploying software with SMS, SCCM, and TAR are provided. The documentation is available as HTML for all platforms and use cases (complete installation, deployment, and installation of specific applications). Links to PDF versions of the documents are also provided.

 

Teradata Connector for Hadoop now available

The Teradata Connector for Hadoop (TDCH) provides scalable, high performance bi-directional data movement between the Teradata database system and Hadoop system.

MultiLoad Notify Exit Routine issues in 14.00 and 14.10

The Teradata MultiLoad Notify Exit Routine has some issues in the 14.00 and 14.10 releases because of enhancements to the MultiLoad notify events logic. This document discusses the enhancements and issues in detail.

Teradata Database Architecture Overview

The Teradata Database system is different from other databases in a number of fundamental ways.

Pages