connectivity

Covers the mechanisms for connecting to the Teradata Database, including driver connectivity via JDBC, ODBC, etc..
Teradata Connector for Hadoop (TDCH) Command Line Edition

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

Teradata Package for R - tdplyr

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

Teradata BYOM Plugin for Dataiku

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

Teradata CLIv2 for Windows

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

Teradata Plugin for Dataiku

Version: - Created: 29 Jul 2021

Teradata Vantage users that also use the Dataiku platform (www.dataiku.com) can establish connections from Dataiku to Teradata Vantage systems, and run a variety of analytic tasks with data in Vantage. The Teradata plugin enhances Dataiku’s built-in interaction capabilities with Teradata Vantage systems. The plugin provides visual recipes with wrappers for select Teradata Vantage ClearScape Analytics. These recipes facilitate scaled in-Database Analytics with your Vantage data by pushing operations into Teradata Vantage through the user-friendly interface of the Dataiku environment. The Teradata plugin can be installed directly from within Dataiku. It is also available through the Dataiku Plugin Store at: https://www.dataiku.com/product/plugins/teradata Visit the above page for complete, up-to-date information about the latest plugin version and features, as well as exhaustive documentation about the current plugin version.  Note: Teradata plugin versions >= 2.0.0 are not backwards-compatible with older versions of the former individual Teradata plugins for Dataiku. To update any Dataiku workflows with pre-v.2.0.0 plugins recipes in them, the old recipes need to be replaced with a post-v.2.0.0 recipe.