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

For Visual Studio 2017 you will need to download the Integrated Help package and/or the VS 2017 Integration package if you wish to use these features.

  • For the VS 2017 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.

For older versions of Visual Studio the main package will install the integrated help and Visual Studio integration features as part of the main package install, if requested.

The Teradata Developer Tools for Visual Studio is available from the Visual Studio Gallery. 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/.
 

Teradata Connector for Hadoop (Command Line Edition)

The Teradata Connector for Hadoop (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.

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 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 ODBC Driver for Linux

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

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.

Access External Data - Part 2 Add support for other data sources

The DbLink facility allows Teradata users to access data in external systems. However, as distributed, it only supports accessing data from external Oracle and Teradata systems.

In this article we will look at what is required to add support for other data sources. As it turns out, not much, just some basic Java programming abilities.

Access External Data - Part 1 The Table UDF

Many databases provide the ability for accessing external data via a mechanism via a SELECT query. Examples include Linked Tables in MS-Access and External Tables in Oracle. A similar capability will become available in Teradata 15, it will be known as Query Grid. However users of Teradata prior to 15 are out of luck.

Teradata has provided the foundation for accessing external data via a SELECT query ever since Table UDF's were added in or around Teradata 12. There is even reference in the UDF programmers manuals to just such a facility (but no actual code to show how to do it).

In this article, you can download a working facility I've called DbLink that you can setup and use to access data from external data sources without having to write your own UDF.

Pages