Teradata DBLink

Database
Enthusiast

Teradata DBLink

A question that I get from developers on a routine basis is "When is Teradata going to develop DB Links?"  As a DBA, I could use this functionality as well.  Has anyone else ever inquired about DB Links from Teradata?... if so... any response?  I know that to move data between systems one needs to write a fastexport/fastload.  It would be nice to write a sql statement similar to insert into prod.tablea sel * from @test.tablea.  Does anyone know of any underlying architectural issues within the Teradata environment that would make a db link problematic to develop?  Deiter... any input?

Thanks,

Joe

3 REPLIES
Junior Supporter

Re: Teradata DBLink

Hi joe.

TD14.10 is expected to bring dblinks (sort of).

Also, there are some C-written UDFs that can mimic the dblink functionality.

Cheers.

Carlos.

Teradata Employee

Re: Teradata DBLink

Data Mover is our recommended product for moving data from one Teradata system to another.

http://www.teradatamagazine.com/Article.aspx?id=13432

TPT can use an ODBC driver to communicate with Oracle, in order to move data between Oracle and Teradata.

http://www.teradata.com/tools-and-utilities/parallel-transporter/

And of course, some of our software vendor partners offer products to move data between Teradata and other databases.

http://www.teradata.com/templates/Partners/BrowsePartners.aspx

Teradata Employee

Re: Teradata DBLink

Also, check out this article that I wrote - I call the tool DbLinks.

http://developer.teradata.com/connectivity/articles/access-external-data-a-table-udf