Downloads

Version: 20.00.00.38 - 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: 17.20 - 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: 03.05 - Created: 21 Jun 2022

Note: You can get the Jupyter Extensions bundled with Jupyterlab as a Docker image on Docker Hub. Note: If you are using the source extensions (not prebuilt) you must upgrade to node 20.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 - Ecosystem Management Forum, 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!Browser-based SSO support (Windows and Mac only)TLS 1.2 and http proxy support (Window, Mac, Linux)Docker Image not updated this release 

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