Downloads

Version: 7.2 - Created: 27 Apr 2016

Announcing: TdBench 8.0 for any DBMS has been released! It works with any DBMS that supports JDBC.  The commands are very similar to earlier releases but there are many new features to improve simulation of data warehouse workloads.  Click here for TdBench 8.0 for any DBMS TdBench had originally been created to improve productivity in the setup and execution of competitive benchmarks. A 5.0 version that ran on MS/DOS was published in 2010 in conjuction with a Partners Presentation.  The product has evolved considerably since then, first moving to Linux, and then adding new productivity features and tools.  With the 7.0 release, we added integration with PDCR data and this most recent release adds the ability to analyze data from a current and prior release of Teradata. We are making the 7.2 release available on DevX for two reasons: To allow customers where we have built "Upgrade Impact Benchmarks" to download updates to the query driver and its tools To make the software available to other customers who want to build their own benchmarks to assess the impact of new software releases as Teradata moves to quarterly software updates.   This latest version: Easily simulates complex workloads with simple commands Tracks tests, captures DBMS/TASM configurations and archives logs Provides analysis views and macros that select DBQL and Resusage data by RunID Setup builds analysis views  from Resusage/DBQL in  DBC, or DBC unioned to PDCR, or current DBC release vs prior release DBC Open architecture in Linux allows running other applications including “brand x” query drivers to leverage tdbench reporting Support OS workers to support non-query activities such as data loading. Can be used to prepare benchmark in parallel. tdb.sh for command & control of active tests plus integration of tools like speedtest, backup_work, wrapup, and setting upTPC-DS and TPC-H benchmarks There are 2 download versions for Linux and one for Windows: Complete functionality query driver that installs on Linux, provides SETUP to create databases on Teradata, executes tests and provides analysis views Same as #1, but also includes scripts data generator for TPC-DS and TPC-H built into the tools of tdb.sh and TdBench Excel template which allows selection of runs from the testtracking table, selection of macros/views beginning with RPT% in the benchmark database, allows additional constraints to be added for selects against views will create spreadsheets for the select views/macros and runids has buttons to update the Conditions and Notes columns in the testtracking table   Supplimental Materials: (See "Packages" above for software) Installation Instructions (extracted from above zip files) /sites/all/files/files/TdBenchV7_2_Installation_Instructions(1).docx All Help on TdBench commands (extracted from above zip) /sites/all/files/files/TdBenchV7_2_all_help(1).txt Powerpoint presentation with speaker notes describing TdBench use & analysis /sites/all/files/files/tdbenchv7_2_intro(2).pptx Running TPC-DS and TPC-H benchmarks under TdBench 7.2 /sites/all/files/files/TdBench_Support_for_TPC(2).docx tdb.sh overview - benchmark setup, monitoring, and support tools /sites/all/files/files/TdBench_7_2_tdb_sh_overview.pptx YouTube videos:  TdBench - A Data Warehouse Query Driver - Video 1 of 4 0:05:03 TdBench simplifies simulating complex data warehouse workloads composed of queries and data loading and integrates tools for quickly analyzing results. This is 1 of 4 videos, describing what is TdBench and how it has been used. How To Run TdBench - Video 2 of 4 0:06:35 This describes the scripting language of TdBench and how to execute tests interactively and in batch. It also provides an overview of the advanced commands for simulating a workload and creating multi-step test suites. How Does TdBench Work - Video 3 of 4 0:07:25 This describes how TdBench is setup on Linux and in Teradata, and describes how files, databases, and processes work. How To Use TdBench Analysis - Video 4 of 4 0:05:20 This video describes the analysis tools in TdBench including queries against views and the TdBench Excel Reporting Template.  It also provides download and support information. Play all of the above 0:24:05    

Version: 3.01.00.009 - Created: 23 Feb 2016

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. It is available for use by Teradata licensees at no charge although it is not covered by normal Teradata software maintenance and support agreements. Other documentation: A list of new features and/or bug fixes in the latest release is available in the "What's new in TMM?" article. A high-level list of application features is available in the Data Sheet (link above) Installation and other information is available in the TMM Getting Started guide (link above). Self-paced, hands-on training available in TMM Tutorial (link above) For community support, please visit the Tools Forum.

Version: 15.10.01.00 - Created: 24 Jan 2016

The Teradata Debugger for C/C++ UDF (CUDB) Eclipse Plug-in provides a Graphical User Interface for CUDB on the Eclipse IDE. Refer to the Installation Guide for instructions on installing CUDB Eclipse via the Eclipse Update Site process. You can either download the zip file, or use the Debugger URL (specified in the Installation Guide) in the install process. To ask questions or discuss issues with CUDB Eclipse, please use the Teradata Debugger Forum. Not recommended for use on production systems. Debugging directly on a production system could potentially affect the overall system performance and cause other issues. Teradata does not support issues caused by use on a production system.

Version: - Created: 15 Jul 2015

The XML Data type, introduced in Teradata 14.10, provides the following new capabilities: •A new XML data type that allows you to store XML content in a compact binary form that preserves the information set of the XML document, including the hierarchy information and type information derived from XML validation •Functions and methods on the XML type that support common XML operations like parsing, validation, transformation (XSLT) and Query (XPath and XQuery) •Supports the XQuery query language for querying and transforming XML content •Supports the following SQL/XML functions and stored procedures:     •XMLDOCUMENT •XMLELEMENT •XMLFOREST •XMLCONCAT •XMLCOMMENT •XMLPI •XMLTEXT •XMLAGG •XMLPARSE •XMLVALIDATE •XMLQUERY •XMLSERIALIZE •XMLTABLE •AS_SHRED_BATCH •XMLPUBLISH •XMLPUBLISH_STREAM Benefits •Removes the requirement to map between hierarchical and relational models prior to storing the XML contents. Previously, this was required when using the XML shredding and publishing functionality in Teradata XML Services. •Provides the ability to preserve document identity. In contrast, the shredding facility that Teradata XML Services supports only extracts the values out of the XML document without retaining the document identity. •Provides a compact method for storing XML content where the internal representation is 5~10 times smaller than the original text representation. •Provides standard query language support for querying XML using XQuery 1.0 and XPath 2.0. •Provides a more efficient method for parsing, transforming and querying XML content. •Integrates the functionality in the Teradata XML Services offering into Teradata Database using syntax that conforms to the ANSI SQL/XML specification.   Considerations •The XML type accommodates values up to 2GB in size. However, operations like XSLT and XQuery, which load documents into memory, are only supported on documents that are smaller in size, where the processing operation does not require more memory than specified by the XML_MemoryLimit DBS Control field. This field caps the amount of memory available for XML operations so that these operations do not strain memory resources. A pseudo-streaming version of XQuery is allowed on large documents via the XMLEXTRACT method on the XML type. •XML path indexes are not supported. •XML schemas and XSLT stylesheets are not managed by Teradata Database.   Schema and Stylesheet Consolidation Utility The Schema and Stylesheet consolidation utility  is available for download as a zip file on this page. There is one significant change in this utility compared to the user documentation. The user documentation speaks of two executables ConsolidateSchema.exe and ConsolidateStylesheet.exe. In this version of the utility the two have been combined into a single executable csldgen.exe. The Readme.txt file included in the zip file gives more details regarding the need for schema and stylesheet consolidation and how to perform such consolidation. This utility is only relevant if your schemas and stylesheets use imports and includes.

Version: - Created: 16 Mar 2015