Downloads

Version: 20.00.00.49 - Created: 06 Sep 2022

The Teradata JDBC Driver is now available in Maven CentralThe Teradata JDBC Driver enables Java applications to connect to the Teradata Database.Check out the How-To for connecting Java apps to Vantage using JDBC.See the readme file in each download package for more details. Information about how to use the driver is available in the Teradata JDBC Driver Reference.For community support, please visit Teradata Community.The Teradata JDBC Driver is distributed as a platform-independent jar file. For downloading convenience, the platform-independent jar file and readme file are bundled together and provided in both zip format and tar format. The zip and tar files contain exactly the same set of files.Download either the zip file or the tar file, and unzip (or untar) the downloaded file into a directory of your choice, and then set your classpath to refer to the necessary jar file.

Version: 20.0 - Created: 09 Aug 2022

You can now get a free hosted instance of Vantage for testing and development purposes at https://clearscape.teradata.com/ Download Teradata Vantage Express, a free, fully-functional Teradata Vantage database, that can be up and running on your system in minutes.  Vantage Express comes as a VM image. It can be installed on your local machine or in the cloud. In order to run this VM, you'll need to install VMware Workstation Player, VMware Fusion, VMware Server, VirtualBox, or UTM on your system. For more details, see our getting started guides. For feedback, discussion, and community support, please visit the Cloud Computing forum.

Version: 02.02.00.00 - Created: 01 Aug 2022

Vantage Analytics Library Product Overview The Vantage Analytics Library (VAL) consists of a Java XSP (a SQL generator), 2 table operators (to support the KMeans and Decision Tree algorithms) and statistical test lookup tables that enable Data Scientists to analyze large datasets at scale. It operates entirely inside Vantage SQL Engine (SQLE) and no additional infrastructure is required to run. The Vantage Analytics Library behaves like a database version of an API and is compatible with Vantage SQLE 16.20 and 17.0 and 17.05. It is easy to install and requires only 40MB of space in the SQLE database for the functions. The Vantage Analytics Library provides data scientists with the following capabilities, directly in the Vantage SQLE: •    Descriptive Statistics           ○  Data Quality/Values           ○  Univariate Statistics           ○  Frequency           ○  Histogram           ○  RI Analysis (column overlap)           ○  Text Field Analysis •    Data Transformation           ○  Bin Code           ○  Formula Derivation           ○  One-Hot Encoding           ○  Null Value Replacement           ○  Recode/Rescale           ○  Sample **NEW**           ○  Sigmoid/Z-Score •    Hypothesis Tests           ○  Parametric Tests           ○  Binomial Tests           ○  Contingency Tests           ○  KS Tests           ○  Rank Tests •    Model Building & Scoring           ○  Matrix (ESSCP/Covariance/Correlation)           ○  Linear Regression           ○  Logistic Regression           ○  Factor Analysis           ○  K-Means           ○  Decision Tree           ○  Association Rules/Sequence Analysis Teradata Vantage Analytics Library software can be installed on any Vantage deployment platform, including: •    On-premises, including IntelliFlex, IntelliBase, 6xxx, and 2xxx series •    VMWare •    AWS •    Azure •    Google Cloud

Version: 1.9.5 - Created: 30 Jun 2022

The Teradata Connector for Hadoop (TDCH) Command Line Edition provides bi-directional data movement between Teradata and Hadoop in a command line environment.For more information, please see the Teradata Connector for Hadoop product information article where you will also find the latest version of the TDCH Tutorial.Only the latest releases of TDCH listed below are supported, so please always upgrade to the latest versions listed below if you are encountering any issues.TDCH VersionHadoop DistributionHadoop VersionTeradata Database (SQLE) Version1.5.17Amazon EMR 5.xHadoop 2.x16.00 - 20.001.6.11Amazon EMR 6.12 and aboveHadoop 3.x16.00 - 20.001.8.7Cloudera Data Platform 7.1.1 to 7.1.6Hadoop 3.x16.00 - 20.001.8.7.1Cloudera Data Platform 7.1.7(Including SP1 and SP2)Cloudera Data Platform 7.1.8Hadoop 3.x16.00 - 20.001.8.7.2Cloudera Data Platform 7.1.9(Including SP1)Hadoop 3.x16.00 - 20.001.9.5Google Cloud Dataproc 2.xHadoop 3.x16.00 - 20.00 Deprecated Hadoop DistributionsHadoop DistributionLast Supported TDCH VersionHadoop VersionTeradata Database (SQLE) VersionGoogle Cloud Dataproc 1.51.5.15Hadoop 2.x16.00 - 20.00Hortonworks Data Platform (HDP) 3.x1.6.9Hadoop 3.x16.00 - 20.00Cloudera Distribution for Hadoop (CDH) 6.xMapR 6.x1.7.9Hadoop 3.x16.00 - 20.00Hortonworks Data Platform (HDP) 2.xMapR 5.x1.5.14Hadoop 2.x16.00 - 17.20Cloudera Distribution for Hadoop (CDH) 5.x1.5.14Hadoop 2.x16.00 - 17.20

Version: 04.00.01.00 - Created: 21 Jun 2022

Note: You can get the Jupyter Extensions bundled with Jupyterlab as a Docker image on Docker Hub. Visit the landing page for more information including sample notebooks, video clips and more ... https://teradata.github.io/jupyterextensions.Join the community discussion at  https://support.teradata.com/community - topic: Jupyter.Vantage Modules for JupyterVantage Modules for Jupyter provide extensions to the JupyterLab platform to enhance the user experience connecting and executing SQL statements on Teradata Vantage. These extensions include the Teradata SQL Kernel, Navigator and Connection Manager.In addition, in the Docker image, we have bundled the Teradata driver for Python and teradataml library as well as the Teradata driver for R and tdplyr library. The teradataml and tdplyr libraries contain the analytic functions that interact with Vantage in the Python and R languages respectively.The SQL Kernel Provides:Connection management to add, remove, connect, and list connectionsQuery engine that uses embedded Teradata SQL driverSQL aware notebook with SQL content assist and syntax checkingResult set renderer that displays result data in easy to read, scrollable gridExecution history that stores execution metadata to recall SQL commands at a later timeVisualization using Vega library to display charts, graphs, plots, etc.Support for basic data load from a file Preference settings allow users to modify logging options for the SQL kernelMagic commands that provide additional custom kernel options to enhance Teradata user experienceThe Navigator Provides:The ability to explore the Advanced SQL Engine catalog, regardless of the language you are using in your notebook (SQL, Python, R).Hierarchical display of SQL object relational modelColumn metadata showing data type and indexesRow Count, Show DDL, Refresh, Sample Data, Profiling Information and Column Distribution menu optionsThe Connection Manager Provides:Connection management to add, remove, edit, copy, list, and test connectionsUser interface that is independent of the SQL notebookConnections that are shared with the Navigator and SQL notebooksWhat's New!Support for JupyterLab 4.2 to 4.x Security improvementsBug fixes 

Version: 17.20.00.16 - Created: 21 Jun 2022

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 Solaris platform.

Version: 17.20.00.16 - Created: 21 Jun 2022

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 packages are for Linux platforms.

Version: 17.20.00.13 - Created: 21 Jun 2022

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 Windows platform.

Version: 17.20.00.16 - Created: 21 Jun 2022

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 AIX platform.

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