 |
 |
Archives of the TeradataForum
Message Posted: Thu, 20 Dec 2007 @ 22:00:52 GMT
| 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!
| |
