Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Feb 2006 @ 19:55:43 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023