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

Access External Data - A Table UDF

With the introduction of Query Grid in Teradata 15, many people have been asking "what about me? I am on not going to be on TD 15 for some time.".

In this series of articles I provide a tool I call DbLink which provides a similar capability for versions of Teradata prior to 15.0. The DbLink tool consists of a Table UDF and supporting components that may be used to access data from a remote RDBMS via JDBC.

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 JDBC Driver

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

Teradata OLE DB Provider

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

Teradata ODBC Driver for Linux

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

Teradata CLIv2 for Linux

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

Teradata CLIv2 for Solaris

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.

Teradata CLIv2 for HP-UX

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 HP-UX platform.

Pages