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
Working with Stored Procedures in Unity Director

Working with Stored Procedures and Unity Director

Unity Director currently has a number of limitations regarding the use of stored procedures. These limitations are often misunderstood, and mistakenly lead to the assumption that stored procedures are not currently supported by Unity Director. This is not the case – while there are a number of considerations to be aware of, most stored procedures can be used with no issues.

Teradata Database Architecture Overview

The Teradata Database system is different from other databases in a number of fundamental ways. If you want to know what these differences are and how they make it possible for Teradata to deliver unlimited scalability in every dimension, high performance, simple management, Query Grid to Hadoop and other databases and all the other requirements of the Active Data Warehouse and structured Big Data, then this is the session for you.

Teradata Express for VMware Player

Download Teradata Express for VMware, a free, fully-functional Teradata database, that can be up and running on your system in minutes. For TDE 14.0, please read the launch announcement, and the user guide. For previous versions, read the general introduction to the new Teradata Express family, or learn how to install and configure Teradata Express for VMware.

A Structured Method for Tuning Teradata SQL

SQL performance is vital for driving value from a data warehouse. With today's growing query complexity, optimizing SQL can be a daunting task ...

Best Practices for Writing and Tuning Teradata SQL

This session is intended for those already familiar with writing SQL but who are somewhat new to Teradata.

Identifying Java Client Software

Beginning with Teradata Database 14.0 and Teradata JDBC Driver 13.10.00.21, the Client Attributes feature records a variety of information about the client system and client software in the system tables DBC.SessionTbl and DBC.EventLog.

The Client Attributes are recorded at session logon time. Subsequently, the system views DBC.SessionInfoV and DBC.LogOnOffV can be queried to obtain information about the client system and client software on a per-session basis.

Teradata Studio

Teradata Studio is a client based graphical interface used to perform database administration tasks on the Teradata Database. It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio, refer to the article Teradata Studio.

Teradata Studio Express

Teradata Studio Express provides an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio Express, refer to the article Teradata Studio Express.

Teradata Plug-in for Eclipse

The Teradata Plug-in for Eclipse is based on the Eclipse plug-in framework and Data Tools Platform (DTP). Teradata Plug-in for Eclipse enables Eclipse DTP to operate with the Teradata Database and value-added features.

Text Search pattern in Teradata with Java , SQLJ

Unstructured data can be dealt with effortlessly in Teradata. Regular expression has been around for many years in software fields. With the advent of Big data, hadoop, NO SQL, columnar, graph database, document  databases the usage of Regex is becoming more and more increasingly popular. The example highlighted below is just a tip of an iceberg of usage. There are umpteen features that can be incorporated into the databases.

Pages