Downloads

Version: 20.00.05.00 - Created: 09 Apr 2025

The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET specification. It provides direct access to the Teradata Database and integrates with the DataSet. .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.   For Visual Studio 2017 and newer, you will need to download the Integrated Help package and/or the appropriate VS Integration package if you wish to use these features. For the VS Integration features, simply download the file and execute it. Microsoft Edge changes the file extension from VSIX to ZIP. You must rename the file back to VSIX to execute it. VSIXInstaller.exe is part of Visual Studio 2017 and VSIX extension should already be associated with VSIXInstaller.exe.  For Integrated Help, unzip the file to a temporary directory and then use the Help, Add and Remove Content menu to install the help. Use the Browse [...] button near the bottom of the dialog to select the extracted helpcontentsetup.msha file, then click Update. PLEASE NOTE that the VS Integration package is self-contained and does not require the .NET Data Provider for Teradata to be installed. However, a runtime dependency conflict may arise if your project depends on both, VS Integration and .NET Data Provider for Teradata. To avoid such conflict, the .NET Data Provider for Teradata must be the same or greater version than the VS Integration package. For older versions of Visual Studio, the main Windows installation package (version 16.10 and older) can optionally install the integrated help and Visual Studio integration features. The Teradata Developer Tools for Visual Studio is available from the Visual Studio Marketplace for Visual Studio 2015-2019 and Visual Studio 2022. The release contains a query tool that enables queries to be composed and executed against a Teradata Database. Queries are composed using a custom editor window with intellisense capabilities. Separate windows are used to display results and history. The .NET Data Provider for Teradata is also available as a NuGet package at https://www.nuget.org/packages/Teradata.Client.Provider/. The Entity Framework Core Provider is available as a NuGet package at https://www.nuget.org/packages/Teradata.EntityFrameworkCore/.   For community support, please visit the Connectivity forum.

Version: 20.00.00.00 - Created: 17 Mar 2025

Teradata Package for Generative AI OverviewNote: Teradata recommends pip install from https://pypi.org/project/teradatagenai .Download from downloads.teradata.com location if your organization does not allow you to install directly from https://pypi.org/project/teradatagenai .teradatagenai is a Generative AI package developed by Teradata. It provides a robust suite of APIs tailored for diverse text analytics applications. With teradatagenai, users can seamlessly process and analyze text data from various sources, including emails, academic papers, social media posts, and product reviews. This enables users to gain insights with precision and depth that rival or surpass human analysis.General product information is available in the Teradata Documentation Website.For community support, please visit the Teradata Community.For Teradata customer support, please visit Teradata Support.Copyright 2025, Teradata. All Rights Reserved.

Version: tdbench-8.01.04 - Created: 14 Oct 2024

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/tdbench.  You can submit issues, questions or contribute DBMS setup information at https://github.com/Teradata/tdbench/discussions.  Manuals, 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:Essential Guide to Benchmarks for DBAs1-Page Essential Guide to Benchmarks for ExecutivesBenchmark DeceptionBenchmark Deception And How to Avoid Benchmark TricksVideos:TdBench Overview  - Why it was created and what it does (0:10:09)TdBench Command Language - Demonstration of use (0:14:19)Design of a Good Benchmark - Training session on constructing a benchmark that models realistic database workloads (0:41:33)

Version: 20.00.00.04 - Created: 04 Sep 2024

Teradata SQL Driver Dialect for SQLAlchemyThis package enables SQLAlchemy to connect to the Teradata Database.This package requires 64-bit Python 3.4 or later, and runs on Windows, macOS, and Linux. 32-bit Python is not supported.For community support, please visit the Teradata Community forums.For Teradata customer support, please visit Teradata Access.Copyright 2024 Teradata. All Rights Reserved.

Version: 01.01.00.00 - Created: 10 May 2024

Vantage Editor DesktopVantage Editor Desktop is an easy to install, lightweight SQL Editor that offers a simple and intuitive user experience for connecting to Teradata and running queries.With the Vantage Editor Desktop you can:Manage connections to SQL Engine 17.20 and aboveCreate, edit, run, rename and save SQL statements and scriptsView, sort, filter and download query resultsView, sort, search, query history and copy/paste for re-executionExport/import query history between Vantage Editor instancesBrowse database objects, mark favorites as starred, view detailed object insightsUpload limited data into existing tablesManage panel size and visibilityAdjust and set defaults for various featuresView in-product helpView the FAQ for more information  Vantage Editor FAQWhat's New Latest release (01.01.00.00) contains the following features:TLS 1.2 SupportSingle Sign On - Federated AuthenticationProxy Server SupportKerberos SupportSeveral Usability and Feature EnhancementsSeveral Quality Improvements and Bug Fixes Including the followingVEDITOR-880:Do not trim trailing spacesVEDITOR-681:Unable to create macroVEDITOR-664:Desktop Editor: Display gets overlapped messages without internet connection 

Version: 20.00.00.02 - Created: 29 Mar 2024

Overviewteradatamlspk is a Python package, built as an extension of teradataml, Teradata Python package. Syntax and user accessibility of teradatamlspk APIs are kept similar to PySpark APIs, allowing, the existing PySpark workloads, that run on Spark engine, can be easily run on Teradata Vantage with minimal changes to migrate PySpark workloads to Vantage.teradatamlspk offers another function pyspark2teradataml that enables conversion of a PySpark script to a teradatamlspk Python script. It also generates the HTML report for the conversion, that is useful for the user to understand the changes done and also carry out any manual changes in the generated script, so that the script can be run on Vantage.Dependent Python Packages: teradataml >= 20.00.00.03PrettyTableNbformatpytzPrerequisite: Python >= 3.9.0 on the client machine 

Version: 20.0.30 - Created: 16 Nov 2023

The Teradata SQL Driver for Node.js enables Node.js applications to connect to the Teradata database.For documentation, license information, and sample programs, please visit the driver GitHub page.For community support, please visit Teradata Community.For Teradata customer support, please visit Teradata Customer Service.We recommend that you follow the Installation instructions listed on the driver GitHub page.If the recommended installation procedure is not possible for you, then follow these manual installation steps:Download the .tgz file from the link above.In your command prompt or shell, run npm install tgzFileName

Version: 01.04.00.00 - Created: 15 Sep 2023

Teradata Partner API The Partner API is composed of two separate components.  The first component is an in-database function (a Table Operator named API_Request) that enables Vantage users to predict (score) machine learning models that are built on 3rd party partner platforms against Vantage data through a Vantage query.  For example, the release 1.4.0 release supports AWS SageMaker, Azure Machine Learning (and OpenAI), Google Vertex AI, and OpenAI model endpoints, with data passed from Vantage to these external platforms using a web services call, and the results are returned to the Vantage end user as results from the query. The second component is a Python library (named tdapiclient), which is a companion package of the Teradata Package for Python (teradataml), Teradata's Python package for client-side processing.  The tdapiclient Python packages allows AWS SageMaker, AzureML and/of Google VertexAI users of Vantage to call each CSP’s Python library interfaces to train and predict using data in Teradata Vantage tables.  tdapiclient also transparently converts and copies the Teradata DataFrame to S3, AzureBlob Storage or Google Cloud Storage for training as part of the fit() method which can invoke any of the API’s offered by the CSP.  For inference, it will use the data directly from Vantage input tables or queries via API_Request.  Test inferences on small amounts of data can also be done directly through the client library.  The tdapiclient also wraps the required BYOM calls to productionize the scoring process.  ** Note that for OpenAI and Azure OpenAI, only the API_Request static API is available in tdapiclient.  Download tdapiclient from:  https://pypi.org/project/tdapiclient/ For more information, see the Partner API Integration Guide on docs.teradata.com.

Version: 20.00.00.29 - Created: 18 Jul 2023

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

Version: 17.20.00.48 - Created: 18 Jul 2023

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: 20.00.00.29 - Created: 18 Jul 2023

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: 20.00.22.00 - Created: 18 Jul 2023

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: 04.01.07.00 - Created: 06 Jul 2023

Query Service is a RESTful web service for Teradata Vantage that allows web pages, mobile devices, and scripting languages to query Vantage using HTTP as the wire protocol and JSON as the data interchange format. Since support for HTTP and JSON is available in most programming languages, applications can use this service to access a Vantage database without requiring a driver.The attached package is for on-prem (VantageCore VMware and VantageCore IntelliFlex) customers. VantageCloud Enterprise and VantageCloud Lake already come with a hosted Query Service instance. Please contact support to start using Query Service in VantageCloud Enterprise or VantageCloud Lake environments.For installation instructions in VantageCore environments see Teradata® Query Service Installation, Configuration, and Usage Guide.

Version: 17.20.16.00 - Created: 22 Jun 2023

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.20.14.00 - Created: 16 May 2023

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.20.00.20 - Created: 16 May 2023

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: 17.20.00.20 - Created: 16 May 2023

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.20.00.20 - Created: 16 May 2023

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

Version: v0.1.13 - Created: 16 May 2023

Teradata AI Unlimited CTL Teradata AI Unlimited CTL provides a command prompt interface to work with AI unlimited workspaces to manage projects and infrastructure. Project management: Create project List project Delete project List project users Create project object store authorization List project object store authorizations Delete project object store authorization Backup objects definitions created for the project work Restore objects definitions created for the project work Infrustructure management: Project engine deploy Project engine suspend Project engine list

Version: 1.0.0 - Created: 04 May 2023

tdplyr will provide a sandbox environment that can be used to run user scripts outside Vantage. User can test scripts in a Vantage-like environment before uploading them for execution in the target Advanced SQL Engine. The sandbox environment is based on a SLES12 SP3 docker image that contains an R distribution (interpreter and add-on libraries) based on the latest Teradata In-nodes R release for SLES12-SP3: R interpreter (Version 3.6.3) Add-on libraries for R User can choose to setup the docker environment and test R scripts by running them inside the docker container, or user can directly execute scripts on Vantage.  The sandbox environment docker image name is "rstosandbox:1.0". The docker image size is about 4.5 GB. Due to the large size, Teradata recommends downloading it beforehand, and saving it into a local folder.

Version: v0.1.8 - Created: 20 Apr 2023

Visit the landing page for more information including sample notebooks, video clips and more ... Teradata Join the community discussion at Community Home - Community - Ecosystem Management Forum, topic: Jupyter Note: The docker image is also available on Docker Hub https://hub.docker.com/r/teradata/ai-unlimited-jupyter   Teradata AI Unlimited Jupyter Teradata AI Unlimited Jupyter provide extensions to the JupyterLab platform to enhance the user experience connecting, orchestrating and executing SQL statements on Teradata AI Unlimited . 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 Teradata in the Python and R languages respectively. The SQL Kernel Provides: Teradata AI Unlimited orchestration and management of the projects and engines using custom magic commands Integration with Github to support project execution Connection management to add, remove, connect, and list connections Query engine that uses embedded Teradata SQL driver SQL aware notebook with SQL content assist and syntax checking Result set renderer that displays result data in easy to read, scrollable grid Execution history that stores execution metadata to recall SQL commands at a later time Visualization 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 kernel Magic commands that provide additional custom kernel options to enhance the Teradata user experience The 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 model Column metadata showing data type and indexes Row Count, Show DDL, Refresh, Sample Data, Profiling Information, and Column Distribution menu options The Connection Manager Provides: Connection management to add, remove, edit, copy, list, and test connections User interface that is independent of the SQL notebook Connections that are shared with the Navigator and SQL notebooks

Version: 05.00.00.01 - Created: 07 Feb 2023

Bring Your Own Model Overview  The Vantage Bring Your Own Model (BYOM) package gives data scientists and analysts the ability to operationalize predictive models in Vantage. Predictive models trained in external tools with sample data can be used to score data stored in Vantage using the BYOM Predict. Create or convert your predictive model using a supported model interchange format (PMML, MOJO, ONNX, Dataiku, and DataRobot currently available), store it in a Vantage table, and use the BYOM PMMLPredict, H2OPredict, ONNXPredict, DataikuPredict, or DataRobotPredict to score your data with the model. For installation instructions please review the readme file above. H2O Installation Options The ability to score H2O MOJO OpenSource and Driverless AI (DAI) models has been added to the BYOM product via the H2OPredict function.  While there are no extra steps necessary to use the function to score H2O MOJO OpenSource models, there is a requirement to have a license key from H2O to be able to score the Driverless AI models.  This license key must be inserted into a Teradata table and used within the query to score H2O MOJO DAI models.     Encrypt_dai_license.sh provides an option of encrypting the H2O DAI license key before inserting it to the license table in the Teradata database. Simply follow the instructions given in the encrypt_readme.txt file to generate the encrypted license key string and insert that into the Teradata table. This script can only be run on a Linux or macOS machine.   Userexamples.zip contains the examples in the user guide. More information is contained in the userexamples_readme.txt. For additional information, please refer to the Teradata Vantage - Bring Your Own Model User Guide (B700-1111-051K)

Version: 1.4.0.1 - Created: 09 Nov 2022

tdapiclient - Teradata Third Party Analytics Integration Python Library The tdapiclient Python library integrates the Python libraries from AWS SageMaker, Azure ML, and Google Vertex AI with Teradata. Users can train and score their models using teradataml DataFrame. tdapiclient will transparantly convert the teradataml DataFrame to an S3 address, Azure ML Dataset or Blob, or Vertex AI dataset to be used for training. The user can then provide another teradataml DataFrame as input for inference. Users of tdapiclient can also deploy models trained in Azure ML, AWS SageMaker, or Vertex AI to a Teradata Vantage system for in-database scoring using BYOM functionality. This library also provides API_Request, a method to call API_Request UDF, which can be used for obtaining OpenAI and Azure OpenAI text embeddings from large language models. This method can also be used for scoring models hosted in AWS, Azure, or Google Cloud Platform, equivalent to predicting in UDF mode through the tdapiclient predict method. Teradata recommends downloading tdapiclient library from PyPi location : https://pypi.org/project/tdapiclient/. Download from downloads.teradata.com location if your organization does not allow you to install directly from https://pypi.org/project/tdapiclient/.

Version: Python3.7.7_sles12sp3 - Created: 28 Oct 2022

The sandbox environment is based on a SLES12 SP3 docker image that contains a Python distribution (interpreter and add-on libraries) based on the latest Teradata In-nodes Python release for SLES12-SP3: Python interpreter (Version 3.7.7 or Version 3.6.7) Add-on libraries for Python User can choose to setup the docker environment and test Python scripts by running them inside the docker container, or user can directly execute scripts on Vantage. The sandbox environment docker image  name is "stosandbox:1.0". The docker image size is about 4 GB. Due to the large size, Teradata recommends downloading it beforehand, and saving it into a local folder.

Version: 20.00.22.00 - Created: 06 Oct 2022

TTU macOS Package This Teradata Tools and Utilities (TTU) 20.00 package is the full collection of Teradata client tools for macOS. This includes load & unload utilities, open interfaces and drivers to be used to connect to your Teradata Advanced SQL (database) instance.  Installation is easy and simple.  The size of the download zip file is ~50 MB.   For feedback, discussion, and community support, please visit the Tools forum. For Vantage Desktop Editor FAQ's please visit FAQ's. 

Version: 20.00.22.00 - Created: 06 Oct 2022

TTU Linux Package This Teradata Tools and Utilities (TTU) 20.00 package is the full collection of Teradata Client tools for Linux. This includes load & unload utilities, open interfaces, connectivity drivers and much more. These software are to be used to connect to your Teradata Advanced SQL (database) instance. Installation is simple using a Linux rpm installer. The size of the download file is ~70MB. To install, extract the zip tar file into a temporary folder and run the Linux rpm. Note: Ubuntu OS has a separate software package compared to other Linux OS. Please make sure you download this package if you plan to run TTU on Ubuntu OS. For feedback, discussion and community support, please visit the Tools forum.

Version: 20.00.22.00 - Created: 06 Oct 2022

TTU Windows Package This Teradata Tools and Utilities (TTU) 20.00 package is the full collection of Teradata Vantage client tools for Windows. This includes load & unload utilities, database management, administration and drivers and much more. They are used to connect to your Vantage Advanced SQL instance. Installation is easy and simple using a Windows installer.  The size of the download zip file is ~200 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. For Vantage Desktop Editor FAQ's please visit FAQ's. 

Version: 20.00.00.19 - Created: 06 Oct 2022

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

Version: 17.20.00.25 - Created: 06 Oct 2022

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

Version: 20.00.21 - Created: 06 Oct 2022

The ODBC Driver for Mac OS X allows you to connect to the Teradata database from Mac OS Xapplications. To get started, see the README files. You can get community support for this download in the Connectivity forum.

Version: 20.00.00.21 - Created: 06 Oct 2022

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

Version: 20.00.21 - Created: 06 Oct 2022

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

Version: 20.0.0.30 - Created: 27 Sep 2022

The Teradata SQL Driver for R enables R applications to connect to the Teradata database. For documentation, license information, and sample programs, please visit the driver GitHub page. For community support, please visit Teradata Community. For Teradata customer support, please visit Teradata Customer Service. We recommend that you follow the Installation instructions listed on the driver GitHub page. If the recommended installation procedure is not possible for you, then follow these manual installation steps: .list-with-disc { list-style-type: disc !important; } Ensure that all required packages (bit64, crfsuite, DBI, digest, hms, and Rcpp) are already installed into your R environment. Download the .tar.gz file from the link above. In your command prompt or shell, run R CMD INSTALL targzFileName

Version: 20.0.0.30 - Created: 27 Sep 2022

The Teradata SQL Driver for Python enables Python applications to connect to the Teradata database. For documentation, license information, and sample programs, please visit the driver GitHub page. For community support, please visit Teradata Community. For Teradata customer support, please visit Teradata Customer Service. We recommend that you follow the Installation instructions listed on the driver GitHub page. If the recommended installation procedure is not possible for you, then follow these manual installation steps: .list-with-disc { list-style-type: disc !important; } Ensure that the required package (pycryptodome) is already installed into your Python environment. Download the wheel file from the link above. In your command prompt or shell, run pip install wheelFileName

Version: 20.00.00.06 - Created: 23 Sep 2022

Teradata Studio Express provides an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio Express, refer to Teradata Studio Express User Guide.Teradata Studio Express is a fully supported product by Teradata. For community support, please visit the Teradata Studio Forum.For release specific information, please go through the Readme documentation. Notes: From version 20.00.00.05, Teradata Studio Express no longer supports the connections to Hadoop and Aster databases.Teradata Studio Express 17.20 will work with Java 11 or 17 and 20.00 will work with Java 11 or 17 or 22. Download Java 11 or 17 or 22 from any Java Vendor distributor downloads page like Oracle or Azul. Below section provides the information about how to download and install Oracle or Azul Java. For other distributions, please refer to their respective downloads page.Depending on Operating System, download either JDK or JRE and Install it. ARM 64 JDK support is available only from version 20.00.00.05, for Apple Silicon M1 and M2.Operating SystemJavaMacJDKWindowsJDK/JRE Azul Zulu OpenJDK/JRE InstallationOSJavaJDKNotesMac11x86 64Download x86 64-bit .dmg file. Mac17x86 64Download x86 64-bit .dmg file. Mac22x86 64Download x86 64-bit .dmg file. Mac11ARM 64Download ARM 64-bit .dmg file. Mac17ARM 64Download ARM 64-bit .dmg file. Mac22ARM 64Download ARM 64-bit .dmg file. Windows11x86 64Download x86 64-bit msi installerWindows17x86 64Download x86 64-bit msi installerWindows22x86 64Download x86 64-bit msi installerFollow steps specified in the Zulu Installation Guide at https://docs.azul.com/zulu/zuludocs/ depending on your operating systemOracle JDK/JRE InstallationOracle is not providing JRE for all OS platforms from Java 11. Download only JDK from Java 11 onwards for both MacOS and Windows.OSJavaJDKNotesMac11x86 64Click on macOS tab and download x64 DMG Installer. Mac17x86 64Click on macOS tab and download x64 DMG Installer. Mac22x86 64Click on macOS tab and download x64 DMG Installer. Mac11ARM 64Click on macOS tab and download ARM64 DMG Installer. Mac17ARM 64Click on macOS tab and download ARM64 DMG Installer. Mac22ARM 64Download ARM64 DMG Installer. Windows11x86 64Click on Windows tab and download x64 InstallerWindows17x86 64Click on Windows tab and download x64 Installer/x64 MSI InstallerWindows22x86 64Click on Windows tab and download x64 Installer/x64 MSI InstallerFollow Installation Instructions specified under Release Information section of Oracle's download page. Teradata Studio Express 17.10 or below versions will work with either Java 8/10/11. Download either Java 8/10/11 from any Java Vendor distributor downloads page like Oracle or Azul. Below section provides the information about how to download and install Oracle or Azul Java. For other distributions, please refer to their respective downloads page.Depending on Operating System, Download either JDK or JRE and Install it.Operating SystemJavaMacJDKWindowsJDK/JRE Azul Zulu OpenJDK/JRE InstallationOSJavaJDKJRENotesMac8MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Mac11MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Windows8Windows JDKWindows JREDownload x86 64-bit msi installerWindows11Windows JDKWindows JREDownload x86 64-bit msi installerFollow steps specified in the Zulu Installation Guide at https://docs.azul.com/zulu/zuludocs/ depending on your operating systemOracle JDK/JRE InstallationOracle is not providing JRE for all OS platforms from Java 11. Download only JDK from Java 11 onwards for both MacOS and Windows .OSJavaJDKJRENotesMac8MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Mac11MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Windows8Windows JDKWindows JREClick on Windows tab and download x64 InstallerWindows11Windows JDKNAClick on Windows tab and download x64 Installer.Follow Installation Instructions specified under Release Information section of Oracle's download page. For Vantage Desktop Editor FAQ's please visit FAQ's.  

Version: 20.00.00.06 - Created: 23 Sep 2022

Teradata Studio is an administration toolkit that helps users to create and administer database objects. It also provides a SQL Editor and Result Set Viewer for retrieving and displaying data from your Teradata Database systems (Teradata). It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio, refer to Teradata Studio User Guide.Teradata Studio is a fully supported product by Teradata. For community support, please visit the Teradata Studio Forum.For release specific information, please go through the Readme documentation. Notes: From version 20.00.00.05, Teradata Studio no longer supports the connections to Hadoop and Aster databases.Teradata Studio 17.20 will work with Java 11 or 17 and 20.00 will work with Java 11 or 17 or 22. Download Java 11 or 17 or 22 from any Java Vendor distributor downloads page like Oracle or Azul. Below section provides the information about how to download and install Oracle or Azul Java. For other distributions, please refer to their respective downloads page.Depending on Operating System, download either JDK or JRE and Install it. ARM 64 JDK support is available only from version 20.00.00.05, for Apple Silicon M1 and M2.Operating SystemJavaMac JDKWindowsJDK/JRE Azul Zulu OpenJDK/JRE InstallationOSJavaJDKNotesMac11x86 64Download x86 64-bit .dmg file. Mac17x86 64Download x86 64-bit .dmg file. Mac22x86 64Download x86 64-bit .dmg file. Mac11ARM 64Download ARM 64-bit .dmg file. Mac17ARM 64Download ARM 64-bit .dmg file. Mac22ARM 64Download ARM 64-bit .dmg file. Windows11x86 64Download x86 64-bit msi installerWindows17x86 64Download x86 64-bit msi installerWindows22x86 64Download x86 64-bit msi installerFollow steps specified in the Zulu Installation Guide at https://docs.azul.com/zulu/zuludocs/ depending on your operating systemOracle JDK/JRE InstallationOracle is not providing JRE for all OS platforms from Java 11. Download only JDK from Java 11 onwards for both MacOS and Windows.OSJavaJDKNotesMac11x86 64Click on macOS tab and download x64 DMG Installer. Mac17x86 64Click on macOS tab and download x64 DMG Installer. Mac22x86 64Click on macOS tab and download x64 DMG Installer. Mac11ARM 64Click on macOS tab and download ARM64 DMG Installer. Mac17ARM 64Click on macOS tab and download ARM64 DMG Installer. Mac22ARM 64Download ARM64 DMG Installer. Windows11x86 64Click on Windows tab and download x64 InstallerWindows17x86 64Click on Windows tab and download x64 Installer/x64 MSI InstallerWindows22x86 64Click on Windows tab and download x64 Installer/x64 MSI InstallerFollow Installation Instructions specified under Release Information section of Oracle's download page. Teradata Studio 17.10 or below versions will work with either Java 8/11. Download either Java 8/11 from any Java Vendor distributor downloads page like Oracle or Azul. Below section provides the information about how to download and install Oracle or Azul Java. For other distributions, please refer to their respective downloads page.Depending on Operating System, Download either JDK or JRE and Install it.Operating SystemJavaMacJDKWindowsJDK/JRE Azul Zulu OpenJDK/JRE InstallationOSJavaJDKJRENotesMac8MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Mac11MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Windows8Windows JDKWindows JREDownload x86 64-bit msi installerWindows11Windows JDKWindows JREDownload x86 64-bit msi installerFollow steps specified in the Zulu Installation Guide at https://docs.azul.com/zulu/zuludocs/ depending on your operating systemOracle JDK/JRE InstallationOracle is not providing JRE for all OS platforms from Java 11. Download only JDK from Java 11 onwards for both MacOS and Windows .OSJavaJDKJRENotesMac8MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Mac11MacOS JDKNAClick on macOS tab and download x64 DMG Installer. Don’t download Arm 64 DMG Installer.Windows8Windows JDKWindows JREClick on Windows tab and download x64 InstallerWindows11Windows JDKNAClick on Windows tab and download x64 Installer.Follow Installation Instructions specified under Release Information section of Oracle's download page. For Vantage Desktop Editor FAQ's please visit FAQ's.  

Version: 20.00.00.04 - Created: 19 Sep 2022

Teradata Python Package Product OverviewNote: Teradata recommends teradataml pip install from https://pypi.org/project/teradataml/.Download from downloads.teradata.com location if your organization does not allow you to install directly from https://pypi.org/project/teradataml/.The Teradata Python Package teradataml combines the benefits of the open source Python language environment with the massive parallel processing capabilities of Teradata Vantage, which includes the Machine Learning Engine analytic functions and the Advanced SQL Engine in-database analytic functions. The Teradata Python package allows users to develop and run Python programs that take advantage of the Big Data and Machine Learning analytics capabilities of Vantage.The Teradata Python package teradataml is a Python library package like other open source Python packages. The package interface makes available to Python users a collection of functions for analytics that reside on Vantage, so that Python users can perform analytics with no SQL coding required. Specifically, the teradataml package provides functions for data manipulation and transformation, data filtering and sub- setting, and can be used in conjunction with open source Python libraries. The teradataml package uses SQLAlchemy and provides an interface similar to the Pandas Python library.The Teradata Python Package works over connections to:    -  Teradata Vantage with Advanced SQL Engine and ML Engine    -  Teradata Vantage with Advanced SQL Engine onlyteradataml is now compatible with SQLAlchemy 2.0.X * **Important notes** when user has sqlalchemy version >= 2.0:       * Users will not be able to run the `execute()` method on SQLAlchemy engine object returned by         `get_context()` and `create_context()` teradataml functions. This is because SQLAlchemy has        removed the support for `execute()` method on the engine object.         Thus, user scripts where `get_context().execute()` and `create_context().execute()`, is used,         Teradata recommends to replace those with either `execute_sql()` function exposed by teradataml         or `exec_driver_sql()` method on the `Connection` object returned by `get_connection()` function         in teradataml. from teradataml import execute_sql execute_sql("DROP TABLE test_select") get_connection().exec_driver_sql("select sessionno from DBC.SessionInfoV where UserName = 'alice';")      * Now `get_connection().execute()` accepts only executable sqlalchemy object. Refer to         `sqlalchemy.engine.base.execute()` for more details.Download teradadatasqlalchemy from:https://downloads.teradata.com/download/connectivity/teradatasqlalchemyORhttps://pypi.org/project/teradatasqlalchemy/tdapiclient: Integration of Teradata Vantage with AWS SageMaker and Azure-MLtdapiclient Python library allows AWS SageMaker and Teradata users to use AWS SageMaker Python library's interface to train/predict using teradataml DataFrame. tdapiclient will transparently convert teradataml DataFrame in S3 address to be used for training and it will also allow user to use teradataml DataFrame as input for inference.tdapiclient also allows Azure-ML and Teradata Users to use easier interface to train/predict using teradataml DataFrame. tdapiclient will transparently convert teradataml DataFrame to azure-ml dataset or blob store to be used for training and it will allow users to use teradataml DataFrame as input for inference. Additionally , tdapiclient also allows to deploy azure-ml trained models in Teradata Vantage system for in-database scoring using BYOM functionality.Teradata recommends downloading tdapiclient library from PyPi location : https://pypi.org/project/tdapiclient/.Download from https://downloads.teradata.com/download/connectivity/tdapiclient-teradata-third-party-analytics-integration-python-library location if your organization does not allow you to install directly from PyPi. teradatamlspk - Teradata Python package for running Spark workloads on Vantageteradatamlspk is a Python package, built as an extension of teradataml, Teradata Python package. Syntax and user accessibility of teradatamlspk APIs are kept similar to PySpark APIs, allowing, the existing PySpark workloads, that run on Spark engine, can be easily run on Teradata Vantage with minimal changes to migrate PySpark workloads to Vantage.teradatamlspk offers another function pyspark2teradataml that enables conversion of a PySpark script to a teradatamlspk Python script. It also generates the HTML report for the conversion, that is useful for the user to understand the changes done and also carry out any manual changes in the generated script, so that the script can be run on Vantage.Teradata recommends downloading teradatamlspk library from PyPi location : https://pypi.org/project/teradatamlspk/.Download from https://downloads.teradata.com/download/connectivity/teradatamlspk-teradata-python-package-running-spark-workloads-vantage location if your organization does not allow you to install directly from PyPi. General product information is available in the Teradata Documentation Website.Teradata Python Package User Guide – B700-4006Teradata Python Package Function Reference – B700-4008For community support, please visit the Connectivity Forum.For Teradata customer support, please visit Teradata Access.

Version: 17.20.00.09 - Created: 08 Sep 2022

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.20.00.09 - Created: 08 Sep 2022

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: 17.20.06.00 - Created: 08 Sep 2022

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.20.00.09 - Created: 08 Sep 2022

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

Version: 20.00.00.45 - 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: 04.00.00.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.