Downloads

Version: 17.20.00.00 - Created: 23 May 2022

Teradata R Package Product Overview Note: Teradata recommends to install tdplyr from https://github.com/Teradata/tdplyr. Download from downloads.teradata.com location if your organization does not allow you to download directly from https://github.com/Teradata/tdplyr. The Teradata R package (tdplyr) combines the benefits of open source R language environment with the massive parallel processing capabilities of Teradata Vantage, which includes the Teradata Machine Learning Engine analytic functions and the Teradata NewSQL Engine in-database analytic functions. It allows users to develop and run R programs that take advantage of the Big Data and Machine Learning analytics capabilities of Vantage. This package interface makes available to R users a collection of functions for analytics that reside on Vantage, so that they can perform in-database analytics with no SQL coding required. Specifically, the Teradata R package provides functions for data manipulation and transformation, data filtering and sub-setting, on remote Teradata database table and can be used in conjunction with open source R capabilities. Moreover, the Teradata R package conforms and works with the functions of the dbplyr package and most of the verbs of the dplyr package. The Teradata R package depends on rlang, dplyr, dbplyr, DBI, magrittr, jsonlite, purrr, bit64 (which are available from CRAN) and teradatasql (which is available from Teradata's Github repository and downloads.teradata.com) packages. To download and install tdplyr along with its dependencies automatically, specify the Teradata R package repository and CRAN in the repos argument for install.packages. Rscript -e "install.packages('tdplyr',repos=c('https://r-repo.teradata.com','https://cloud.r-project.org'))" Documentation and Support For Teradata R package documentation, please visit Teradata R Package Documentation For Teradata customer support, please visit Teradata Access or email Analytic-Clients Support at SA230577@teradata.com. General product information is available in the Teradata Documentation Website. Teradata R Package User Guide – B700-4005 Teradata R Function Reference – B700-4007

Version: 1.0.0 - Created: 15 Dec 2021

The Teradata BYOM plugin facilitates "bringing your own model" to the Vantage Advanced SQL Engine Database and scoring your data that are stored in Database tables with saved models in select formats. This plugin's features enable Dataiku users to take advantage of the Vantage massively parallel scoring capabilities by using models previously trained in Dataiku or other platforms. Specifically, the Teradata BYOM plugin contains 2 Dataiku recipes to      1. Enable you to store PMML-formatted Dataiku models into Vantage tables.      2. Score data in Database tables from the convenience of your Dataiku project. The plugin currently supports PMML- and H2O MOJO-formatted models you have previously          stored in the Database.   The present plugin has been tested with Vantage 2.0. For system requirements and further details, refer to the README file and the plugin user guide PDF document.

Version: 17.10.12.00 - Created: 08 Dec 2021

Teradata Call-Level Interface Version 2 is a collection of callable service routines that provide the interface between applications and the Teradata Gateway. Gateway is the interface between CLI and the Teradata Database. This download package is for the Windows platform.

Version: 20.00.22.31 - Created: 18 Nov 2021

Developer Tier is a SUSE Linux Enterprise Server (SLES) operating system and the Analytics Database packaged into a virtual container that runs in a VMware vSphere ESXI virtualized environment on third-party hardware. There are two variants of the Developer Tier including a Preconfigured version and the regular version. Developer Tier (Preconfigured) is a simplified version of VantageCore VMware Developer Tier that allows you to deploy the Analytics Database quickly and easily using the OVA template. Networking is already configured to use DHCP, and you can add storage to the system. The Preconfigured version enables you to deploy only the Database and the instructions are available in a separate user manual on this download page. The full Developer Tier consists of an OVA file template and associated property files and scripts for deploying the Teradata Database and the associated Teradata ecosystem products. Once deployed by the VMware administrator, Developer Tier can be used to evaluate the VantageCore VMware and the Analytics Database and the associated ecosystem products.   Note: You must have administrative privileges on the destination VMware environment to install and configure Developer Tier virtual machines.   The Linux OVA contains Teradata Studio, Teradata version of Jupyter Lab, Apache Superset and instructions (with a script) to install Precog on the OVA after it's installed.  To get the Jupyter access token, login as user "tdc" and run "docker ps" to view the running images. Next run "docker logs <jupyter image id>" to view the Jupyter access token.  The login and password for the Linux OVA is tdc/teradata2022 For feedback, discussion, and community support, please visit the Cloud Computing forum. Getting Started The first task is to decide whether you want to deploy the preconfigured version or the regular version of Developer Tier. Then, you must download the Developer Tier template and the manual for the version you wish to deploy. If you are deploying the full version, you'll need to also download the install scripts and desired ecosystem products from the download center. You will need the following technical requirements and components to run Developer Tier.   Component Requirements VMware ESXi version ESXi 6.x, 7.x   Datastore space for template deployment:  Teradata Database: 30 GB minimum   vCenter management • VMware administrator privileges • vCenter Standard version (must support ESXi 6.x or 7.x servers) • vCenter 6.x or 7.x   Note: There is a known issue with tdvm-init on the 17.10 Developer Tier OVA image that causes the tdvm-init script to fail. To work around this issue, run the command "mkdir -p /etc/opt/teradata/telm/tmp" and then run the command "touch /etc/opt/teradata/telm/tmp/.dttmpp" After running those commands run "python tdvm-init" to configure VantageCore VMware Developer Tier.  

Version: 17.05 - Created: 12 Aug 2021

This is a VMware OVA that contains Teradata Studio, Teradata version of Jupyter Lab, Apache Superset and instructions (with a script) to install Precog on the OVA after it's installed.  To get the Jupyter access token, login as user "tdc" and run "docker ps" to view the running images. Next run "docker logs <jupyter image id>" to view the Jupyter access token.  For feedback, discussion, and community support, please visit the Cloud Computing forum.   NOTE: The login and password for the OVA is tdc/teradata2022.

Version: 1.0.3 - Created: 29 Jul 2021

The Teradata SCRIPT Table Operator (STO) plugin for Dataiku allows end users to leverage the STO object in the Vantage Advanced SQL Engine Database. STO enables pushing R and Python scripts into the Database, and executing the scripts natively in the Database nodes. One thus benefits from scaled performance through execution of script instances across all Database processing units. The Teradata SCRIPT Table Operator plugin for Dataiku facilitates pushing down and execution of STO custom-built R or Python code from      (a) notebooks built in Dataiku DSS, or      (b) external script files stored in DSS managed folders. The plugin also allows you to push down to the Database any supplementary files that may be needed by your script, such as R or Python model files. For system requirements and further details, refer to the README file and the plugin user guide PDF document.  

Version: 2.0.3 - Created: 29 Jul 2021

The Teradata Advanced SQL Engine Functions Plugin for Dataiku The Teradata Advanced SQL Engine Functions Plugin for Dataiku integrates a set of analytic functions that reside in the Vantage Advanced SQL Engine, by providing a user-friendly, easy-to-use, no-SQL interface for these functions in the Dataiku DSS environment. The Teradata Advanced SQL Engine Functions Plugin for Dataiku allows end users to leverage Vantage analytics within their DSS data science workflows. This plugin provides support for most of the Advanced SQL Engine analytic functions in 16.20. The present plugin has been tested with Vantage 2.0. For system requirements and further details, refer to the README file and the plugin user guide PDF document.

Version: 17.10.06.00 - Created: 23 Jun 2021

Teradata Call-Level Interface Version 2 is a collection of callable service routines that provide the interface between applications and the Teradata Gateway. Gateway is the interface between CLI and the Teradata Database. This download package is for the Windows platform.

Version: 17.10.00.12 - Created: 22 Jun 2021

Teradata Call-Level Interface Version 2 is a collection of callable service routines that provide the interface between applications and the Teradata Gateway. Gateway is the interface between CLI and the Teradata Database. This download package is for the Solaris platform.

Version: 17.10.00.12 - Created: 22 Jun 2021

Teradata Call-Level Interface Version 2 is a collection of callable service routines that provide the interface between applications and the Teradata Gateway. Gateway is the interface between CLI and the Teradata Database. These download packages are for Linux platforms.

Version: 09.01.00.00 - Created: 31 Aug 2020

Teradata Vantage Machine Learning Engine Analytics examples for ML Engine version 8.00, 8.10 && 9.01

Version: 16.10.00.05 - Created: 09 Sep 2019

Teradata Call-Level Interface Version 2 is a collection of callable service routines that provide the interface between applications and the Teradata Gateway. Gateway is the interface between CLI and the Teradata Database. This download package is for the HP-UX platform.

Version: tdbench-8.01.04 - Created: 06 Sep 2019

  TdBench is a tool designed to simulate realistic database workloads for applications and platforms.This tool can be used with any DBMS supporting JDBC to:Measure performance before vs after a change to add indexes, partitioning, compression, etcMeasure the impact to your DBMS of changes to settings, a patch, or a new software releaseSimulate a workload for a new application or a proof of conceptCompare the performance of one platform to anotherCompare performance of different data base vendor’s productsGetting Software and Help for TdBench:You can download the latest package of the TdBench jar file and setup information with scripts for Teradata and non-Teradata DBMSs from this page and unzip it in a directory on a server of PC with connectivity to your DBMSTerdata's JDBC driver is included.  Search the web for other vendor's JDBC drivers and save them on your server or PCAdditional DBMS setup scripts and information may be found at https://github.com/Teradata/tdbenchYou can submit issues, questions or contribute DBMS setup information at https://github.com/Teradata/tdbench/discussionsManuals, white papers and videos are reference at the bottom of this page. What does TdBench do?TdBench simulates realistic production systems by allowing definition of the different types of work and adjusting the number of concurrent executions for each type of work;It captures the results each query execution in its internal database.It facilitates analysis host DBMS resource consumption by maintaining test metadata on the host DBMS to join with its query logs.Tests are defined with:queues of SQL queries and scripts or OS commandsvariable number of execution threads (workers) per queuecommands to pace queries by time or percentageparameterized queries to simulate different usersoptional query prepare reducing DBMS parsingscheduled start of processes or individual queriesFixed work or fixed period execution modelsScripting language to automate multiple testsTests can be defined as simply as 4 statements. Analysis capabilities have been used to track individual query performance over hundreds of runs during projects with constraints like:WHERE RunID in (79, 81, 105)Example:  Basic test of all queries in 1 worker session:define serial Test of queries executed seriallyqueue thequeries scripts/queries/*.sqlworker thequeries mydbmsrunExample:  Fixed period test of 10 minutes with 2 queues and a total of 5 worker sessions:define workload5 Test of 1 heavy and 4 reporting worker sessionsqueue hvy scripts/queries/hvy*.sqlworker hvy mydbms 1queue rpt scripts/queries/rpt*.sql;worker rpt mydbms 4run 10mThere are nearly 60 commands for defining and scripting multiple tests.  You could use:the PACE command with an interval reference command to control arrival of queries on a queue, orPACE with a percentage  to limit the percentage of total queries executed from one queue, orAT command to schedule events, or QUERY LIST to replay query starting as the executed in production There are built-in variables, user variables, IF and GOTO statements.There are 69 built-in help files and a TdBench 8.01 User Guide to help you get started.TdBench Documentation:TdBench 8.01 User GuideTdbench 8.01 Tri-Fold Command ReferenceWhite Papers:1-Page Essential Guide to Benchmarks for ExecutivesEssential Guide to Benchmarks for DBAsBenchmark DeceptionBenchmark Deception And How to Avoid Benchmark TricksVideos:TdBench Overview  - Why it was created and what it does (0:10:09)TdBench Command Language - Shows how to construct tests using the TdBench command language (0:14:19)Design of a Good Platform Benchmark - Training session on constructing a benchmark or POC that models realistic database workloads to compare platforms (0:41:33)

Version: 16.10.00.10 - Created: 28 Jan 2019

The ODBC Driver for HP-UX allows you to connect to the Teradata database from HP-UX applications. To get started, see the README files. You can get community support for this download in the Connectivity forum.

Version: 07.00.03.00 - Created: 16 Jan 2019

This package contains the Aster Analytics POC Functions

Version: 07.00.03.00 - Created: 16 Jan 2019

Version: 16.10.00.14 - Created: 16 Jul 2018

Teradata Wallet provides secure storage for private information, such as Teradata Database passwords, on client computers.  The stored information can then be used when logging on to the Teradata Database. This download package is for the HP-UX platform.

Version: 16.20 - Created: 23 May 2018

Developer Tier is a SUSE Linux Enterprise Server (SLES) operating system and Teradata Database packaged into a virtual container that runs in a VMware vSphere ESXI virtualized environment on third-party hardware. Developer Edition software consists of a template and associated property files and scripts.    Teradata Developer Tier (Preconfigured) is a simplified version of Teradata Database Developer tier that allows you to deploy Teradata Database on VMware quickly and easily using the OVA template. Networking is already configured to use DHCP, and you can add storage to the system.  To enable additional Teradata Database features or use additional Teradata applications, see Teradata Database on VMware Developer Tier Getting Started Guide or Teradata Database on VMware Base, Advanced, Enterprise Tiers Getting Started Guide. Note: You must have administrative privileges on the destination VMware environment to install and configure Developer Tier virtual machines. Getting Started Please see the Teradata Database on VMware Developer Tier Preconfigured Getting Started Guide 

Version: 7.00.02.01 - Created: 04 Jan 2018

Version: 1 - Created: 04 Jan 2018

A download location for 'R Repository'. Download of this R software is only authorized for use with Teradata Aster software. For use with any other Teradata products, download the R software from http://cran.r-project.org/. Note - For some OS/browser combinations, the downloaded artifacts have filenames with modified extensions. This may be because your browser is trying to decompress the download for you. If you experience difficulties extracting the contents from such artifacts, renaming the files the way they show up on the download page can help solve the issue.

Version: 6.10 - Created: 20 Oct 2017

Aster Express is a fully functioning Aster Analytics environment. It will allow you to build tables, load data into those tables, and run over 100 prebuilt Aster Analytics functions. Aster Express can be used by developer, testers, and anyone who is interested in learning more about Aster Analytics functionality. Aster Express is not licensed for production use.   Aster Express VMware®: [Aster Express 6.10 for VMware] This version runs on Microsoft desktop on a couple of VMWare images. This software limits the amount of data you can move into the environment to 17GB of data. Aster Express 6.10 for VMware Getting Started Guide   Hardware requirements (minimum): 4 GB memory 20 GB free disk space CPU should be 64 bit support capable   Software requirements (minimum): OS: Microsoft® Windows® Operating System (7+) VMware Player: Open a browser to run the download and install the free VMware Player 7-Zip: To extract (or uncompressed) the Aster Express package   Aster Express for VMware Recommended Software The following software is strongly recommended to enrich the Aster Express for VMware experience. The great news is that most/all of it is free.   Visit this Link to download the following: VMware Player 7.0 Web Browser (FireFox) 7Zip FTP Tool (FireFTP) Teradata Studio SSH/Terminal Software   ========== Note** This is an old version. We recommend that you watch the page for a demo version of TDAP when it’s released, so you can bridge to TDAP when ready. An announcement will be posted in our Data Science Community once this is ready.   For more details, visit the Data Science Community   Related Links: Download Aster Analytics Trial Download Aster Express

Version: 7.00.02.00 - Created: 20 Sep 2017

An alternate location to download Aster Analytics examples for version AA6.21 and above.

Version: 7.00.02.00 - Created: 19 Sep 2017

An alternate location to download Aster Analytics uninstall scripts for version AA6.0 and above.

Version: 7.00.02.00 - Created: 19 Sep 2017

Create scripts to install Aster Analytics functions to a custom schema.

Version: 05.04.02.00 - Created: 01 Sep 2017

The Teradata Profiler Plug-in is based on the Eclipse plug-in framework and the Teradata Plug-in for Eclipse and Teradata Studio Data Source Explorer (DSE). Teradata Profiler Plug-in enables the user to Profile Teradata and Aster tables/columns via the DSE as well as create projects containing analyses. The descriptive statistics available with the Teradata Profiler Plug-in provide a variety of functions to statistically analyze and explore data tables in a Teradata or Aster database. This is a complete version of the Teradata Profiler for Eclipse, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data. (Note that the validation of the 40 GB limit for the Express Edition requires SELECT access to the dbc.allspace view in Teradata or EXECUTE permission on the nc_relationstats SQL-MR function in Aster for the user.) ► NOTE: This version requires the Teradata Plug-in for Eclipse 15.10.01.00 or greater (available here) if using with Eclipse. To install the Teradata Profiler Plug-in via the Eclipse Update Site process, bring up Eclipse and run the Software Updates process. From the main menu, select Help then Install New Software... In the Work with field, select the Add... button. Enter Profiler Update Site in the Name field and the Teradata Profiler Plug-in for Eclipse URL (http://downloads.teradata.com/download/cdn/applications/profiler/profiler-05.04.02/update/site.xml) as the Location. Click OK Select all of the Teradata Profiler Plug-in for Eclipse features to install. Click Next to proceed with the installation. When the Feature License Agreement appears, select I accept the terms in the license agreement, and then click Next. When prompted click Finish to continue the installation. A warning message may appear regarding unsigned JAR content. Click OK to continue. When a message appears asking if you want to restart Eclipse, click Yes. To install from a local Teradata Profiler Plug-in for Eclipse Update Site, download the zip file locally. Refer to the User Guide for further instructions on installing Teradata Profiler Plug-in for Eclipse. For installation in Teradata Studio or Teradata Studio Express, you will need the ProfilerPluginForEclipse.zip file (download above). Extract the files and simply copy thejar file from the "ProfilerPlugin-Express\update\plugins" folder and paste into the Teradata Studio or Teradata Studio Express "plugins" directory (ususally found under c:\Program Files\Teradata\Client\15.10). Note, with Teradata Studio Express the Profiler windows will all display in the bottom panel (next to the SQL History). This is because the Teradata Studio Express does not have a perspective that Profiler can open its windows in. If desired, you may drag the Profiler windows to other locations within Studio Express for better viewing. Teradata Profiler Plug-in for Eclipse contains open source components. The zip file contains the source code (as required) and licenses for these components. This package does not contain proprietary Teradata source code. For help getting started using the Teradata Profiler Plug-in, refer to the User Guide. Readme Teradata Profiler Plug-in for Eclipse 05.04.02 release information. Supported Platforms: =============================      Windows Server - Microsoft Windows Server 2008, 32-bit and 64-bit      Windows 7      - Microsoft Windows 7, 32-bit and 64-bit      Windows 8      - Microsoft Windows 8, 32-bit and 64-bit Dependent Eclipse Software: =============================      Eclipse IDE for Java JEE Developers (Kepler 4.3)      Eclipse IDE for Java JEE Developers (Luna 4.4.2)      Eclipse IDE for Java JEE Developers (Mars 4.5) Required Software: =============================      Java Runtime Environment (JRE) version 1.7 or greater      Teradata Plugin for Eclipse 15.10.01 or greater      Teradata Studio 14.10 or greater Supported Teradata Databases Versions: ======================================      Teradata Database 14.10      Teradata Database 15.00      Teradata Database 15.10 Supported Aster Databases Versions:  ======================================      Aster Database 6.0      Aster Database 6.10      Aster Database 6.20 Install Instructions: =============================      Once the dependent and required software has been installed, Teradata Profiler      Plug-in for Eclipse can be installed and configured. Follow this procedure to      install Teradata Profiler Plug-in for Eclipse 05.04.02 using the Eclipse Local      install procedure.      To install Teradata Profiler Plug-in for Eclipse 05.04.02:      1. From the Eclipse main menu, click Help and then click Install New Software….      2. Click the Add… button.      3. Type ”Profiler Local Install” in the Name field and and click on the Local…         button to select the ProfilerLocalInstall folder* as the Location.      4. Click OK to add the site.      5. Select the Teradata Profiler Plug-in for Eclipse and then click Next.      6. When the Feature License Agreement appears, select I accept the terms in the         license agreement, and then click Next. A list of features appears with the         feature version, size, and Eclipse install location.      7. Verify that the information is correct, and then click Finish to continue         the installation. A warning message appears regarding unsigned JAR content.      8. Click OK to continue.      9. When a message appears asking if you want to restart Eclipse, click Yes.      * If your installation contains the ProfilerPluginForEclipse.zip file you will        need to unzip the ProfilerPluginForEclipse.zip into a directory to extract        the ProfilerLocalInstall folder.     For installation in Teradata Studio or Teradata Studio Express, you will need     the ProfilerPluginForEclipse.zip file. Extract the files and simply copy the     jar file from the ProfilerPlugin-Express\update\plugins folder and paste into the     Teradata Studio or Teradata Studio Express plugins directory (ususally found     under c:\Program Files\Teradata\Client\15.10). Known Issues ==============================     TWM-1588: After running a scatter plot on the same column name from two different     tables (e.g. “age”) and attempting to drill down into a column from the graph, we     receive the error: “Duplication of column AGE in a table, derived table, view, macro     or trigger”.     TWM-1163: Profiler Perspective windows do not appear in the proper place in     Teradata Studio Express. This is an issue with Studio Express not having a     perspective for the Profiler Plug-in.

Version: 05.04.04.00 - Created: 27 Jul 2017

The latest software available for download here is Teradata Warehouse Miner 05.04.04 Express Edition. This is a complete version of the Teradata Warehouse Miner product set, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data. (Note that the validation of the 40 GB limit for the Express Edition requires SELECT access to the dbc.allspace view in Teradata or EXECUTE permission on the nc_relationstats SQL-MR function in Aster for the user.) To get started with TWM - Express Edition, please download the "TWM Express Introduction" PDF above. This introductory document provides the following information: Limitations of the Express Edition Overview of the TWM family of products General installation and configuration instructions Configuring the tutorial environment Examples of using the product The Release Definition (.pdf, available above) has a list of all new features, fixes, defects, restrictions and dependencies. The complete TWM User Guide 3 Volume documentation set is also included as pdf files above. Before installing TWM 05.04.04, follow these instructions, in sequential order: Uninstall any previous versions of Teradata Warehouse Miner or its derivative products if they were installed. Ensure that a supported 32-bit Teradata ODBC driver from TTU 14.10,15.0, 15.10, 16.0 or 16.10 is installed, available here: ODBC Driver for Windows.  If connecting to an Aster Database, ensure that a supported 32-bit Aster ODBC driver from Aster Client Tools 6.00, 6.10 or 6.20 is installed, available here: Aster Client Tools for Windows.  Install the Teradata Warehouse Miner 05.04.04 Express Edition. Refer to the Installation and Configuration section of the "TWM Express Introduction" document for additional instructions on configuring Teradata Warehouse Miner prior to your first use. For community support for this product, please visit the Analytics forum.

Version: 16.10.00.03 - Created: 06 Jul 2017

Teradata Call-Level Interface Version 2 is a collection of callable routines that provide the interface between applications and the Teradata Gateway.  Gateway is the interface between CLI and the Teradata database.  This download package is for the Ubuntu platform.

Version: 7.00.00.00 - Created: 11 May 2017

This package contains the Aster client tools for MacOS.   Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where: XX is a major release YY is a minor release ZZ is a maintenance release nn is an efix or hotpatch We use this terminology: major release: Major releases of Aster typically introduce new features. minor release: Point releases of Aster typically provide feature enhancements and bug fixes. A point release may also introduce new features. maintenance release: Maintenance releases of Aster typically provide only bug fixes. They may also include feature enhancements. efix or hotpatch: Hotpatch releases are introduced to address customer issues of an urgent nature.   Example of efix application to major/minor releases: An efix is a fix for part of the product. It may not function by itself. E.g., the AIX 64-bit AC 6.00.00.02 efix only includes the following: ACT, ADFS client, JDBC driver, and Third party licenses. It doesn't include other drivers and utilities such as ODBC. If you would like to use the latest drivers and utilities for AC 6.0, you will need to follow these steps: Install AC 6.00.00.00 with all its drivers and utilities. Check the AC 6.00.00.0x README to see whether any additional packages are needed then follow the README to apply the efix.

Version: 7.00.00.00 - Created: 11 May 2017

This package contains the Aster client tools for AIX.   Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where: XX is a major release YY is a minor release ZZ is a maintenance release nn is an efix or hotpatch We use this terminology: major release: Major releases of Aster typically introduce new features. minor release: Point releases of Aster typically provide feature enhancements and bug fixes. A point release may also introduce new features. maintenance release: Maintenance releases of Aster typically provide only bug fixes. They may also include feature enhancements. efix or hotpatch: Hotpatch releases are introduced to address customer issues of an urgent nature.   Example of efix application to major/minor releases: An efix is a fix for part of the product. It may not function by itself. E.g., the AIX 64-bit AC 6.00.00.02 efix only includes the following: ACT, ADFS client, JDBC driver, and Third party licenses. It doesn't include other drivers and utilities such as ODBC. If you would like to use the latest drivers and utilities for AC 6.0, you will need to follow these steps: Install AC 6.00.00.00 with all its drivers and utilities. Check the AC 6.00.00.0x README to see whether any additional packages are needed then follow the README to apply the efix.

Version: 7.00.00.00 - Created: 11 May 2017

This package contains the Aster client tools for Solaris.   Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where: XX is a major release YY is a minor release ZZ is a maintenance release nn is an efix or hotpatch We use this terminology: major release: Major releases of Aster typically introduce new features. minor release: Point releases of Aster typically provide feature enhancements and bug fixes. A point release may also introduce new features. maintenance release: Maintenance releases of Aster typically provide only bug fixes. They may also include feature enhancements. efix or hotpatch: Hotpatch releases are introduced to address customer issues of an urgent nature.   Example of efix application to major/minor releases: An efix is a fix for part of the product. It may not function by itself. E.g., the AIX 64-bit AC 6.00.00.02 efix only includes the following: ACT, ADFS client, JDBC driver, and Third party licenses. It doesn't include other drivers and utilities such as ODBC. If you would like to use the latest drivers and utilities for AC 6.0, you will need to follow these steps: Install AC 6.00.00.00 with all its drivers and utilities. Check the AC 6.00.00.0x README to see whether any additional packages are needed then follow the README to apply the efix.

Version: 7.00.00.00 - Created: 11 May 2017

This package contains the Aster client tools for Linux.   Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where: XX is a major release YY is a minor release ZZ is a maintenance release nn is an efix or hotpatch We use this terminology: major release: Major releases of Aster typically introduce new features. minor release: Point releases of Aster typically provide feature enhancements and bug fixes. A point release may also introduce new features. maintenance release: Maintenance releases of Aster typically provide only bug fixes. They may also include feature enhancements. efix or hotpatch: Hotpatch releases are introduced to address customer issues of an urgent nature.   Example of efix application to major/minor releases: An efix is a fix for part of the product. It may not function by itself. E.g., the AIX 64-bit AC 6.00.00.02 efix only includes the following: ACT, ADFS client, JDBC driver, and Third party licenses. It doesn't include other drivers and utilities such as ODBC. If you would like to use the latest drivers and utilities for AC 6.0, you will need to follow these steps: Install AC 6.00.00.00 with all its drivers and utilities. Check the AC 6.00.00.0x README to see whether any additional packages are needed then follow the README to apply the efix.

Version: 7.00.00.00 - Created: 11 May 2017

This package contains the Aster client tools for Windows.   Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where: XX is a major release YY is a minor release ZZ is a maintenance release nn is an efix or hotpatch We use this terminology: major release: Major releases of Aster typically introduce new features. minor release: Point releases of Aster typically provide feature enhancements and bug fixes. A point release may also introduce new features. maintenance release: Maintenance releases of Aster typically provide only bug fixes. They may also include feature enhancements. efix or hotpatch: Hotpatch releases are introduced to address customer issues of an urgent nature.   Example of efix application to major/minor releases: An efix is a fix for part of the product. It may not function by itself. E.g., the AIX 64-bit AC 6.00.00.02 efix only includes the following: ACT, ADFS client, JDBC driver, and Third party licenses. It doesn't include other drivers and utilities such as ODBC. If you would like to use the latest drivers and utilities for AC 6.0, you will need to follow these steps: Install AC 6.00.00.00 with all its drivers and utilities. Check the AC 6.00.00.0x README to see whether any additional packages are needed then follow the README to apply the efix.

Version: 16.00.00.00 - Created: 17 Mar 2017

The Teradata Debugger for Java UDF is a new feature of Teradata Database 16.0 and later designed to provide a full-featured, easy to use debugger for debugging UDFs and external stored procedures written in Java. It extends the abilities of the standard Eclipse Java IDE and addresses limitations of general debuggers, such as the inability to handle multiple, parallel JVM instances, a situation that is very common on Teradata Database systems.  Refer to the Installation Guide for instructions on installing JUDB 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 JUDB 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: 16.00.02.00 - Created: 16 Mar 2017

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. ► NOTE: This version requires Java Runtime Environment 1.8. ►NOTE:Neon JEE Eclipse bundle is missing the EMF Client Platform (ECP) 1.9.0 packages. Before installing the Teradata Plug-in, you must:      -  Install the EMF Client Platform 1.9.0 by going to the Eclipse Help menu, selecting Install New Software... and entering the EMF ECP 1.9.x Update Site: http://download.eclipse.org/ecp/releases/releases_19/. Note: If you have the previous version of EMF ECP installed, you want to remove it from Eclipse before installing the new version. To install the new version:      -  Press the Add... button to add the location of the EMF ECP 1.9.0 Update Site (see image below).      -  Choose this site and install the "ECP SDK 3.x" in the "All SDKs" category. Press Next to install EMF ECP.      -  Before letting Eclipse restart to finish the installation, remove the file             plugins\org.eclipse.emf.ecp.view.swt.layout_versionNumber.jar      - To remove this plugin, locate your Eclipse directory, and delete plugins                \org.eclipse.emf.ecp.view.swt.layout_<versionNumber>.jar      -  Restart Eclipse, File>Restart      -  Install Teradata Plug-in for Eclipse To install the Teradata Plug-in for Eclipse via the Eclipse Update Site process, bring up Eclipse and run the Software Updates process. From the main menu, select Help then Install New Software... In the Work with field, select the Add... button. Enter Teradata Update Site in the Name field and the Teradata Plug-in for Eclipse URL (http://downloads.teradata.com/download/cdn/tools/tdide/tdide-16.00.02.00/update) as the Location. Click OK   Select all of the Teradata Plug-in for Eclipse features to install. Click Next to proceed with the installation.   To install from a local Teradata Plug-in for Eclipse Update Site, download the zip file locally. Refer to the Installation Guide for further instructions on installing Teradata Plug-in for Eclipse. Teradata Plug-in for Eclipse contains open source components. A package containing the source code and licenses for these components is also available above for download. This package does not contain proprietary Teradata source code. For help getting started using the Teradata Plug-in, refer to the Getting Started with Teradata Plug-in for Eclipse article. Readme Teradata Plug-in for Eclipse 16.00.02 release information. Supported Platforms: =============================      Windows Vista  - Microsoft Windows Vista Enterprise, 32-bit and 64-bit      Windows Server - Microsoft Windows Server 2003, 32-bit and 64-bit                     - Microsoft Windows Server 2008, 32-bit and 64-bit      Windows 2000   - Microsoft Windows 2000, 32-bit      Windows 7      - Microsoft Windows 7, 32-bit and 64-bit      Windows 8      - Microsoft Windows 8 and 8.1, 32-bit and 64-bit      Windows 10     - Microsoft Windows 10, 32-bit and 64-bit      Apple Mac      - OSX 10.7, 10.8, 10.9, 10.10, and 10.11 Dependent Eclipse Software: =============================      Eclipse IDE for Java JEE Developers Neon (Eclipse 4.6)      NOTE: Neon JEE Eclipse bundles are missing the EMF Client Platform (ECP) 1.9.0 packages. You must:      Before installing the Teradata Plug-in, you must:      -  Install the EMF Client Platform 1.9.0 by going to the Eclipse Help menu,         selecting Install New Software... and entering the EMF ECP 1.9.x Update Site.         (Note that if you have the previous version of EMF ECP installed, you want to remove         it from Eclipse before installing the new version.)      To install the new version:      -  Press the Add... button to add the location of the EMF ECP 1.9.0 Update Site.         (http://download.eclipse.org/ecp/releases/releases_19)      -  Choose this site and install the "ECP SDK 3.x" in the "All SDKs" category.         Press Next to install EMF ECP.                 -  Before letting Eclipse restart to finish the installation, remove the file             plugins\org.eclipse.emf.ecp.view.swt.layout_versionNumber.jar      -  To remove this plugin, locate your Eclipse directory, and delete plugins                \org.eclipse.emf.ecp.view.swt.layout_<versionNumber>.jar      -  Restart Eclipse, File>Restart      -  Install Teradata Plug-in for Eclipse Supported Teradata Databases Versions: ======================================      Teradata Database 14.00      Teradata Database 14.10      Teradata Database 15.00      Teradata Database 15.10      Teradata Database 16.00 Supported Aster Databases Versions: ======================================      Aster Database 6.00      Aster Database 6.10      Aster Database 6.20      Aster Database 7.0 (Aster on Hadoop) Required Software: =============================      - Java Runtime Environment (JRE) version 1.8      - Mac OsX 10.7 or greater does not provide the Apple JRE. Users must      install Oracle's JDK (not JRE) 1.8. Install Instructions; =============================      Once the dependent software has been downloaded, Teradata Plug-in for Eclipse can      be installed and configured. Follow this procedure to install Teradata Plug-in for      Eclipse 15.12 using the Eclipse Update Site install procedure.      To install Teradata Plug-in for Eclipse 16.00.02:      1. From the main menu, click Help and then click Install New Software….      2. Click the Add... button.      3. Type ”Teradata Update Site” in the Name field and the Teradata Plug-in for        Eclipse update site URL as the Location:        http://downloads.teradata.com/download/cdn/tools/tdide/tdide-16.00.02.00/update      4. Click OK to add the site.      5. Select each of the Teradata Plug-in for Eclipse components, and then click Next.      6. When the Feature License Agreement appears, select I accept the terms in the         license agreement, and then click Next. A list of features appears with the feature         version, size, and Eclipse install location.      7. Verify that the information is correct, and then click Finish to continue the         installation. A warning message appears regarding unsigned JAR content.      8. Click OK to continue.      9. When a message appears asking if you want to restart Eclipse, click Yes. Support Notes: ==================================== Problem - Object lists displayed in the Data Source Explorer and shown in the wrong sort order. Resolution - In the eclipse.ini file (located in your install directory), add the following variable to the list of -vmargs      -Djava.util.Arrays.useLegacyMergeSort=true Bug Fixes ==================================== The following bugs were fixed in 16.00.02: IDE-17881     FastLoad with Unicode Pass Through needs to pass in RUNSTARTUP parameter IDE-18240     Disable SSL from Teradata Studio connection to hadoop through Knox The following bugs were fixed in 16.00.01: IDE-14512    TD Studio does not display details under the Teradata Labs tab IDE-17501    In SQL Editor star (*) is showing in editor tab even SQL save. Refer SQL.PNG IDE-17590    Presto enabled in Connection Profile if Knox selected IDE-17591    Cloudera Existing Connection Profile - Properties Page - Test Connection uses HortonworksConnection IDE-17617    Data Transfer: The process just hangs since the update to 15.10.02 15.12.00. Exporting few hundred rows and the process ran for hours. IDE-17712    Help table of contents missing IDE-17722    Copy table TD to TD showing 0 rows transferred when actually transferred 65533 IDE-17743    Load table data always uses FastLoad protocol, even if only 45 rows IDE-17888    SQL History SQL statement has lost the leading comment - Regression   The following bugs were fixed in 16.00.00: IDE-12705    Linux and Amazon Linux --> Data Sort/Filter, Export All and ‘Refresh table from Database’ toolbar options are not displayed IDE-12818    Redhat 7 and Amazon Redhat - Copy object Wizard --> Generated SQL is not displayed in the SQL Summary Page in Copy object Wizard IDE-12819    Redhat 7 and Amazon Redhat - Format the Result set --> Format the Result set is not working in Redhat 7 and Amazon Redhat IDE-14695    Row Count on more than 15 tables causes "Response limit exceeded." IDE-14791    Result Set Viewer preference error message IDE-15075    Transfer View Refresh is not refreshing after dropping table in Admin Perspective IDE-15209    Hadoop Refactoring --> Confirm Dialog message box is not displayed when clicking on OK button after updating the Hadoop Profile                   name in the Properties dialog and updated Hadoop Profile name in the Navigator/DSE with entered name IDE-15549    Project Explorer 'Execute SQL Files' does nothing when press OK IDE-15806    Property form is not closed when the table is dropped IDE-15824    Preconfigured Data Sources mechanism does not support JDBC HTTP Transport Mode property IDE-15878    Error when using default editor with previously imported Hadoop profile IDE-15935    Set Root Database for Navigator --> Perform the case insensitive validation for Root Database IDE-15937    JOIN/HASH --> Hash/Join Index is displayed without ‘Database name’ prefix when index dragged and dropped on SQL Editor IDE-15959    Drop - Delete Database.../Drop Database... --> Menu options for Drop/Delete are not displayed when selecting the Database/User IDE-16067    Result set Format settings lost on cancel operation IDE-16070    Aster Smartloader gets incorrect nullable information IDE-16156    Teradata ViewVX is not being used when loading Table Size information (DBC.TableSizeVX) IDE-16225    Getting NullPointException for Sample Contents on empty table from Hadoop system. IDE-16233    Certify CDH 5.8 with Studio Testing --> Unhandled event loop exception is thrown when clicking on ‘Toggle Result Set display as                   Text or Grid’ toolbar button in the ‘Teradata Result Set Viewer’ after selecting the Sample Contents option for a Hadoop table IDE-16302    Edit Data… - Teradata --> Unhandled event loop exception is thrown when clicking on ‘OK’ Button in the Filter/Sort Data dialog IDE-16440    Smartload table returned null right after create statement successfully ran in Aster IDE-16441    Only check for EXPLAIN for Teradata IDE-16517    Japanese Localization Bugs in the 15.12 release IDE-16604    Studio with ASTER on setting MAROWS is generating a pop up IDE-16755    Aster --> Schemas are not displayed in the OLV when double clicked on database in the Navigator tab IDE-16756    Aster --> Inform the user with proper message (or) Disable the ‘Add a Schema’ toolbar option as we cannot(other than login DB)                    create the schema directly under the ‘XX DB’ using ‘Create Schema’ form IDE-16774    Studio with ASTER treating "?" mark in reset function as query parameter IDE-16814    Teradata/Aster --> 'Row Count' tooltip is displayed incorrectly for Views IDE-16815    Spelling --> Message is displayed incorrectly in the ‘Drop Confirmation’ message box IDE-16833    Need to update wording on notification dialog IDE-16886    CDH 5.8 testing with TDCH 1.5 --> Unhandled event loop exception is thrown when clicking on Finish button after clicking on                   ‘Select None --> Select All --> Reset’ buttons when trying to transfer Teradata table to Hadoop IDE-16896    Teradata Studio 15.12 - Open SQL File does not work. IDE-16915    Label name is displayed as ‘Database’ instead of ‘Schema’ in the ‘Transfer Hadoop Table to Aster Table’ wizard IDE-16930    Unhandled event loop exception is thrown if the destination type contains unsupported data type as distribute by hash key                    when transferring a Hadoop table to Aster IDE-16931    Transfer Hadoop table to Aster -->Distribute by hash clause is not displayed when selecting hash key as other than first column                    after unselecting the first column in the Transfer Column field IDE-16996    Error Dialogue loops when timeout Teradata Connection and attempt copy table IDE-17008    In SQL Editor, 'Connection Profile' Drop down is displayed as SmartLoad(CDH) instead of SmartLoad(HDP). IDE-17055    Cloudera connection with SmartLoader connection option should show WebHDFS properties dialog, not TDCH IDE-17092    In JDBC Connection profile, every field has Key board shortcut key other than 'Cancel' button and 'LDAP Security enabled' check box. IDE-17366    Externalize SQL Formatter preference and routine editor IDE-17369    Foreign Servers --> Unhandled event loop exception is thrown when pressing the 'Alt+Tab' IDE-17397    Load Data and Export Data have Error Dialogue loops when connection got timed out Improvements ==================================== The following improvements were made in 16.00.02: IDE-17476     Support for Cloudera 5.9 IDE-17620    Create Aster Execution Engine Connections IDE-17621    Aster Execution Engine Create table support IDE-18179    Migrate Aster 7.0 connection profiles The following improvements were made in 16.00.01: IDE-10476    Unable to logon to Teradata DB using SSO/Kerberos in Studio v 15.0 IDE-14432    Support Kerberized cluster for Hortonworks and Cloudera IDE-17725    Propagate WebHDFS username to WebHCAT username for new Hadoop Connection Profile The following improvements were made in 16.00.00: IDE-14769     mm/dd/yyyy hh:mm:ss timestamp format is not recognized in external data transfer IDE-14237    Provide a preference for setting number of decimal places on Float values displayed in the Result set viewer IDE-11792    Result Set Viewer preference to specify numeric format pattern IDE-14670    Provide option to choose the date format in the Result Set Viewer IDE-14678    Provide option to display binary data in the Result Set Viewer with dashes IDE-14679    Provide option to display BigInt and Decimal(16)+ values as Strings for Excel IDE-13583    Result Set Viewer - add preference for displaying TIME values IDE-14325    Provide direct string substitution for parameters in SQL Editor like SQL Assistant does IDE-11839    Specify the location of the history file. IDE-12922    See Triggers with table objects in the Object List Viewer IDE-12570    Ability to "show all objects" for a DB/User IDE-12571    Display the references for a table IDE-14657    See the list of roles that a user is in. IDE-14665    Show the list of statistics for tables IDE-12082    Preference to use Columns VX or custom view. IDE-14732    SmartLoad and FastLoad: add option to ignore null rows Hadoop Configuration Support: ============================= Teradata Studio provides an option to transfer data to and from Hadoop systems using its feature called the Smart Loader for Hadoop. The Smart Loader for Hadoop uses the Teradata Connector for Hadoop (TDCH), which is installed on the Hadoop node, to provide the data transfer to and from the Hadoop system. Teradata Studio requires TDCH version 1.5.1. The following are the system requirements of TDCH 1.5.1:     Supported Teradata Database versions:         Teradata Database 14.00         Teradata Database 14.10         Teradata Database 15.00     Teradata Database 15.10         Teradata Database 16.00     Supported Hortonworks Data Platform (HDP) versions:         HDP 2.3 (Hadoop 2.7.1, Hive 1.2.1, HBase 1.1.1)         HDP 2.4 (Hadoop 2.7.1, Hive 1.2.1, HBase 1.1.2)         HDP 2.5 (Hadoop 2.7.3, Hive 1.2.1, HBase 1.1.2)     Supported Cloudera Hadoop (CDH) versions:            CDH 5.4, 5.7, 5.8 Teradata Connector for Hadoop Setup: ==================================== The TDCH 1.5.1 must be installed and configured on the Hadoop system. Teradata Plugin for Eclipse's Smart Loader for Hadoop uses Oozie to submit the data transfer workflow on the Hadoop System. Please follow these instructions to configure the Hadoop System and create the Oozie workflow files. 1) If the script is not already on your Hadoop system, download and install the TDCH (version 1.5.1) onto your Hadoop system. 2) Navigate to the TDCH scripts folder in the TDCH install directory (default location: /usr/lib/tdch/1.5/scripts) 3) Execute the configureOozie.sh script as root user, providing the locations of your Hadoop services.      The usage of the configureOozie.sh script is as follows (this is all a single line):     Usage: ./configureOozie.sh nn=nameNodeHost [nnHA=fs.default.value] [rm=resourceManagerHost] [oozie=oozieHost] [webhcat=webHCatalogHost] [webhdfs=webHDFSHost]         [nnPort=nameNodePortNum] [rmPort=resourceManagerPortNum] [ooziePort=ooziePortNum] [webhcatPort=webhcatPortNum] [webhdfsPort=webhdfsPortNum]         [hiveClientMetastorePort=hiveClientMetastorePortNum] [kerberosRealm=kerberosRealm] [hiveMetaStore=hiveMetaStoreHost]         [hiveMetaStoreKerberosPrincipal=hiveMetaStoreKerberosPrincipal] (The parameters are entered on a single line. The parameters surrounded by [ ] are optional. The “[“ and “]” are not part of the command.) (Note: the Job Tracker in HDP 1.x is now the Resource Manager in HDP 2.x)     nn - The Name Node host name (required)     nnHA - If the name node is HA (High Availability), specify the fs.defaultFS value found in core-site.xml     rm - The Resource Manager host name (uses nn parameter value if omitted)     oozie - The Oozie host name (uses nn parameter value if omitted)     webhcat - The WebHCatalog host name (uses nn parameter value if omitted)     webhdfs - The WebHDFS host name (uses nn parameter value if omitted)     nnPort - The Name node port number (8020 if omitted)     rmPort - The Resource Manager port number (8050 if omitted)     ooziePort - The Oozie port number (11000 if omitted)     webhcatPort - The WebHCatalog port number (50111 if omitted)     webhdfsPort - The WebHDFS port number (50070 if omitted)     hiveClientMetastorePort - The URI port for hive client to connect to metastore server (9083 if omitted)     kerberosRealm - name of the Kerberos realm     hiveMetaStore - The Hive Metastore host name (uses nn paarameter value if omitted)     hiveMetaStoreKerberosPrincipal - The service principal for the metastore thrift server (hive/_HOST if ommitted) The port numbers are HDP’s defaults. So, if the system being set up has all the services hosted on a single system on the default ports, only the nn parameter is needed. The script will exit with an error message if the TDCH is not in its expected location. Otherwise the script will display a message indicating the parameters values. A sample message is as follows: The following is the specification of the Hadoop services used by the Oozie workflows: {         "Distribution":"HDP",         "DistributionVersion":"2.4",         "TeradataConnectorForHadoopVersion":"1.5.1",         "WebHCatalog":"hostname",         "WebHCatalogPort":50111,         "WebHDFS":"hostname",         "WebHDFSPort":50070,         "JobTracker":"hostname",         "JobTrackerPort":8050,         "NameNode":"hostname",         "NameNodePort":8020,         "NameNodeHA":"fs.defaultFS",         "NameNodeHAConfigured":true,         "Oozie":"hostname",         "OoziePort":11000,         "HiveClientMetastorePort":9083         "HiveMetaStoreKerberosPrincipal":"hive/_HOST",         "KerberosRealm":"",         "HiveMetaStore":"hostname" } ** You must also make sure the Teradata IDE/Studio client machine can access the Hadoop system services (hostnames and ports provided to configureOozie script). Thus, you may need to add the Hadoop services host names and IP addresses to your host file or DNS service. HORTONWORKS SELF_SIGNED CERTIFICATES: ===================================== The certificate used by the Knox server needs to be added to the Java runtime's certificate store. You can save the certificate with a web browser. For example, with Chrome, you can: •    Enter the Knox server:port in the address bar. It will say that the connection is not private •    Click Advanced, then click on the Proceed to site link •    Click on the lock in the address bar and select Details •    Click View certificate •    Select the Details tab in the resulting dialog and click the Copy to file... button •    In the resulting Certificate Export Wizard, save the certificate as Base-64 encoded (Other browsers have similar methods to get to the Certificate Export Wizard) Alternatively, on the Knox server, run the command:      keytool -export -alias gateway-identity -rfc -file knox.crt -keystore <path to gateway.jks keystore (eg. /usr/lib/knox/data/security/keystore/gateway.jks)> To install the certificate into your Java Runtime certificate store, run the command:      %JDK_HOME%\bin\keytool.exe -importcert -alias "TDH240 Knox self-signed certificate" -file cert_location/<filename>.txt -keystore %JRE_HOME%\lib\security\cacerts Where %JDK_HOME% is an environment variable with the location of a JDK and %JRE_HOME% is the location of the JRE used to run Studio. The keytool.exe will ask for the password to the certificate store. It is “changeit” unless you’ve changed it  

Version: 7.00.01.00 - Created: 23 Nov 2016

This package contains the Aster Development Environment download packages and documentation.

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

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.