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?
TD14.10 is expected to bring dblinks (sort of).
Also, there are some C-written UDFs that can mimic the dblink functionality.
Data Mover is our recommended product for moving data from one Teradata system to another.
TPT can use an ODBC driver to communicate with Oracle, in order to move data between Oracle and Teradata.
And of course, some of our software vendor partners offer products to move data between Teradata and other databases.
Also, check out this article that I wrote - I call the tool DbLinks.