Downloads

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.