Downloads

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.26.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.26.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.26.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.28 - 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.26 - 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.28 - 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.26 - 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.40 - 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.40 - 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.07 - 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. Below section provides the information about how to download and install 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 system Teradata Studio Express 17.10 or below versions will work with either Java 8/11. Download either Java 8/11 from any Java Vendor distributor downloads page. Below section provides the information about how to download and install 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 systemNote: Starting with Windows 11 version 24H2, VBScript is provided as a Feature on Demand (FOD) and may not be enabled by default on all systems. If you encounter installation issues related to VBScript on Windows, please ensure that the VBScript feature is enabled in Windows Features before proceeding with the Teradata Studio/Studio Express installation. For Vantage Desktop Editor FAQ's please visit FAQ's.  

Version: 20.00.00.07 - 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. Below section provides the information about how to download and install 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 system 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. Below section provides the information about how to download and install 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 systemNote: Starting with Windows 11 version 24H2, VBScript is provided as a Feature on Demand (FOD) and may not be enabled by default on all systems. If you encounter installation issues related to VBScript on Windows, please ensure that the VBScript feature is enabled in Windows Features before proceeding with the Teradata Studio/Studio Express installation. For Vantage Desktop Editor FAQ's please visit FAQ's.  

Version: 20.00.00.06 - 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.