Connectivity

Articles related to Teradata Database connectivity.

Expand All The Latest
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

Article by jjordan 17 Jun 2016
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.

Article by dbc1012 08 Dec 2014
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.

Article by dbc1012 08 Dec 2014
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.

Article by dbc1012 01 Dec 2014
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.

Article by hcnguyen 16 Jul 2013
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.

Article by jjordan 05 Jun 2013
Teradata Connector for Hadoop now available

This forum has moved to: https://community.teradata.com/t5/Connectivity/Teradata-Connector-for-Hadoop-Now-Available/td-p/17138

Please visit the new forum for updates.

Article by hcnguyen 07 May 2013
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.

Article by steveg 10 May 2012
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.

Article by Mishra_HS 30 Dec 2011
Creating an OData service using .NET Data Provider for Teradata

The Open Data Protocol (OData) is a protocol to share or exchange data over the web.  The protocol was developed by Microsoft in 2007 as part of the ADO .NET Data Services technology (a.k.a. Project Astoria) for creating and consuming data services using the Web. This protocol became widely used that Microsoft gave the protocol its own identification, named it OData and considered ADO.NET Data Services as the .NET implementation of OData.

Article by sn185025 19 Oct 2011

Pages