Connectivity covers the mechanisms for connecting to the Teradata Database, including driver connectivity via JDBC or ODBC.

Expand All Subscribe to Teradata Developer Exchange - Connectivity content The Latest
Teradata Package for Python - teradataml

Teradata Python Package Product Overview

Note: 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/.

Teradata ODBC Driver for Mac OS X

The ODBC Driver for Mac OS X allows you to connect to the Teradata database from Mac OS Xapplications.

Teradata ODBC Driver for Linux

The ODBC Driver for Linux allows you to connect to the Teradata database from Linux applications.

Teradata ODBC Driver For Windows

The ODBC Driver for Windows allows you to connect to the Teradata database from Windows applications.

Teradata JDBC Driver

The Teradata JDBC Driver enables Java applications to connect to the Teradata Database.

Teradata BYOM Plugin for Dataiku

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.

Teradata Connector for Hadoop (TDCH) Command Line Edition

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 now available article where you will also find the latest version of the TDCH Tutorial.

TDCH Version

.NET Data Provider for Teradata

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.  

How to use the Teradata JDBC Driver with R

The RJDBC package enables an R application to use the Teradata JDBC Driver to access the Teradata Database.

DBI is the standard database interface for R, and RJDBC is an implementation of DBI that serves as an adapter to translate DBI actions into the corresponding JDBC actions. This combination enables R to use a JDBC Driver, such as the Teradata JDBC Driver.

R application RJDBC Teradata JDBC Driver Teradata Database

 

Configuring R to use the Teradata JDBC Driver

Teradata OLE DB Provider

IMPORTANT NOTE: This product has been discontinued. The last version released was 15.00.

The Teradata OLE DB Provider allows you to connect to the Teradata database using a Microsoft OLE DB interface.

Pages