|
|
Archives of the TeradataForum
Message Posted: Fri, 10 Feb 2006 @ 19:55:43 GMT
Subj: | | Re: Dblink in Teradata |
|
From: | | Bob Hahn |
As Clay suggested it is possible.
The Orange Book "Facilities and Techniques for Event Processing" describes 2 prototypes which obtained a resultset from a remote Teradata
system via a UDF Table Function (which used CLI) to query a remote Teradata system. The prototype illustrated a query that joined that resultset
with a local query and wrapped it all up in a view. UDFs and External Stored Procedures enable single or parallel (UDFs) reads/writes against
external sources such as flat files, RDBMS, Message Queues etc. e.g. for 'pull' style data integration (another Table Function prototype also
described in the book reads from Websphere MQ aka MQSeries and there is another on the UDF download site that can write to MQ). Comment solicited
on whether this could be a useful capability. As others have pointed out there are plenty of other ways to accomplish the same thing.
| |