Training material for Connectivity.

Expand All
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 ODBC Driver for MP-RAS

This release of the Teradata ODBC driver for MP-RAS supports Teradata 12.0 features in both Teradata and (Entry Level) ANSI modes, and is backwards compatible with previous releases back to Teradata Database V2R6.0.

Teradata Connector for Hadoop 1.0.7 now available

The Teradata Connector for Hadoop (TDCH) provides scalable, high performance bi-directional data movement between the Teradata database system and Hadoop system.

How to use the Teradata JDBC Driver with teradataR

JDBC support has been added to teradataR version 1.0.1 which provides the ability of using the Teradata JDBC Driver through teradataR to connect to the Teradata database.  teradataR allows R users to easily connect to a Teradata database and use statistical functions directly against the Teradata system without having to extract memory into data.  For more information on teradataR, refer to the teradataR User Guide.

Teradata JDBC Driver Reference

This reference guide provides information about the Teradata JDBC Driver, which is a Teradata Tools and Utilities product. A set of Frequently Asked Questions is also available.

Teradata Mainframe Client Utilities update

Teradata has completed a major compiler conversion effort that should be completely transparent to customers, yet they are the main beneficiaries.  This article:

  • Provides some historical background and context,
  • Discusses the reasons we switched compilers,
  • Identifies certain behavioral changes that were unavoidable,
  • And, finally, answers a few technical questions related to the overall process.

The venerable IBM mainframe was the original client platform developed for the Teradata RDBMS via channel-attached connections way back in the 1980s. Although we now support a wide range of client platforms using network-attached connections, a significant segment of our customer base continues to use mainframe clients.

.NET Data Provider Reference

The following reference documentation is available:

OLE DB Access Module amj file having multiple jobs

OLE DB Access Module amj files or Access Module Job files contain the following information:

  • Data source details (Database Name, Driver used to connect to database) for the both source and destination.
  • Table name for the data source supplying data
  • List of columns for the data source supplying data

All the information is stored in XML format and is stored under a JOB element.

Pages