Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Dec 2007 @ 22:00:52 GMT


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


Subj:   Re: Teradata Views looking at Tables in a different
 
From:   Geoffrey Rommel

  I am wondering if Teradata has a facility to create views which look at tables in a different RDBMS?  


Directly, no, but it is possible to do this by writing an External Table UDF.

Obviously this is not for the faint of heart, and it may be hard to find a working example. The code to extract the data from the other RDBMS would be running on one or more of your TPA nodes, so it would take some cycles away from Teradata. There is also the perennial issue of who's going to support the C code. But if your business requires it, I say just do it!



     
  <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