Downloads

Version: 14.00.00.04 - Created: 15 Oct 2014

Teradata XML Services provide assistance in database transformation of XML structures to and from relational structures. This is primarily an enterprise fit feature. XML in this context is regarded as a data format that is used to describe incoming or outgoing warehouse data. A key concept for this feature is that we are not transforming to store XML but rather to maintain a relational data model or to integrate relational data into an enterprise XML message structure! The relational data model is bested suited for enterprise analytics. XML structures are best suited for enterprise integration. Teradata XML Services is supported on Database Versions 13, 13.10 and 14. As of Teradata Database version 14.10, much of the XML Services functionality has been implemented as part of the XML data type in the database, and Teradata XML Services as a separate download will not be supported for 14.10 and future versions. Mappings created for XML shredding and publishing can be used for 14.10 as well (except for XSLT shredding),  but the names of the stored procedures will change. Please see the Teradata XML book in the database user documentation for further details. This feature will be delivered asynchronously from any specific Teradata warehouse release. The delivery format will be as a web download, available for each Teradata server platform. The feature is considered a part of the Teradata product and will be supported through normal support channels. Teradata XML Services consists of the following components: Xerces XML parser and Xalan XSLT transformer packaged as a platform specific operating system library. Shredding Framework which consists of a combination of stored procedures and functions. A stored procedure controls the shredding process. When shredding one to a few documents the stored procedure directly invokes the data maintenance DML. When shredding many documents, the stored procedure uses a set-based approach through the invocation of a table generation function. Parallel Publishing Framework which consists of a combination of stored procedures and functions. A stored procedure will control the publishing process. The stored procedure can either return a string representing an XML object type or a SQL statement that represents the XML data stream. The SQL statement can be reused in views, macros, fast export, etc. General purpose XSLT transformation function. Two XPATH search functions, one that returns a scalar character value and one that returns an XML fragment character value. XML schema validation function. XML Schema and Stylesheet loading and dependency resolution. XML schema generation procedures. Perl based installation process. For community-based support and to share your implementation ideas and concerns, please visit the Extensibility forum.

Version: 15.00.00.00 - Created: 06 Aug 2014

"udaSQL" provides a DevOps focused SQL Execution Engine that allows the developer to focus on their SQL and Procedural algorithms while ensuring that the needs of the Operations team are addressed by embedding operational and query logging directly into the engine. For details on how to use udaSQL please see the associated article.

Version: 12.00.00.13 - Created: 04 Jul 2014

This release of the Teradata ODBC driver for MP-RAS supports Teradata 12.0 features in both Teradata and (Entry Level) ANSI modes, and is backwards compatible with previous releases back to Teradata Database V2R6.0. To get started, see the README files. You can get community support for this download in the Connectivity forum.

Version: 15.00.00.00 - Created: 15 May 2014

TTU Windows Package This Teradata Tools and Utilities (TTU) 15.00 package is the full collection of Teradata client tools for Windows. This includes SQL Assistant, load & unload utilities, database management, administration and drivers, and much more to be used to connect to your Teradata Express database instance (downloaded separately).  Installation is easy and simple using a Windows installer.  The size of the download zip file is 500 MB.  To install, extract the zip file into a temporary folder and run the setup.exe program. For feedback, discussion, and community support, please visit the Tools forum.  

Version: 2014.01.28 - Created: 28 Jan 2014

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.

Version: 32 - bit - Created: 03 Sep 2013

TD Geo Import/Export tool lets you translate ESRI Shape and KML files to TD format.

Version: 2012.02.13 - Created: 13 Feb 2012

Teradata 13.10 features Block Level Compression (BLC), which provides the capability to perform compression on whole data blocks at the file system level before the data blocks are actually written to storage. Like any compression features, BLC helps save space and reduce I/O. This BLC utility is for Teradata users to run against TD 13.10 system to select the list of BLC candidate tables and evaluate BLC impact on space and speed for each specific table in interest, to get information for selecting appropriate tables to apply BLC. To learn how to use the BLC Utility package, please see the article Block Level Compression evaluation with the BLC utility.   For community support for this package, please visit the Extensibility Forum.

Version: 14.00.00.00 - Created: 13 Jul 2011

ODBC Learning Examples are a suite of applications designed to provide an informative guide to developing ODBC applications as well as providing simple building blocks for ODBC applications. Please see the ODBC Learning Examples article for details on usage.

Version: 1.0.0.2 - Created: 12 Nov 2010

The ALC (ALgorithmic Compression) test package contains UDFs simulating TD13.10 built-in compression functions, test templates for Latin and Unicode character columns and step-by-step instructions. It is intended for TD users to run over specific data at column level to determine compression rates of TD 13.10 built-in compression algorithms. The test results provide information for selecting an appropriate algorithm for specific data. These tests use read-only operations and they can be executed on any release that supports UDFs (V2R6.2 & forward). It is recommended to run these tests off peak hours - they will use a significant amount of system resources (CPU bound). Usage To learn how to install and use the test package, please see Selecting an ALC compression algorithm. For community support for this package, please visit the Extensibility forum.

Version: 5.00 - Created: 26 Oct 2010

New Release!! TdBench V7.2 is now available for Linux at http://downloads.teradata.com/download/tools/tdbench7-2 TdBench 5.0 Description (MS DOS version from 2010) This package provides a framework for executing benchmarks driven by a Windows Server or PC and reporting on the results using DBQL. There are also tools for extracting a cohesive set of queries and tables from DBQL to define the benchmark. TdBench helps you compare performance within a data warehouse: before/after a new release of the DBMS before/after changes to the PDM (indexes, compression, etc) relative performance of a new database platform To get started, please read the Teradata Benchmark Query Driver reference. These tools are provided free of charge in the belief that good benchmarks are an accurate reflection of your real or planned production load. If Teradata customers and prospects can do a better job of executing such tests with the use of this software, they will be able to make better decisions on selection of tools, planning for rollout, and managing system growth. For community support, please visit the Tools forum.