All Forums Connectivity
danielA 8 posts Joined 06/13
13 Oct 2014
Create a Teradata view to an external Teradata Server

Hi;
 
Does teradata have the concept of a linked server? I would like to create a view on our Teradata Test Box which views a Dataset on the Production server.
I know that datamover could be scripted to bring the data across but space on the test server is at a premium.
 
Does anyone know of any other mechism that could be utilised in this senario?
 
Thanks in advance & I look forward to the responses

Raja_KT 1246 posts Joined 07/09
14 Oct 2014

USL? Can you refer to this link.
http://forums.teradata.com/forum/database/how-can-we-connect-different-oracle-teradata-multiple-database-servers-to-join-the

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

fnewbrough 17 posts Joined 05/11
14 Oct 2014

Either way you are going to move the data even if it is a seamless process that you don't see. There are features coming that provide the Teradata equivalent of db links.
-Fred

danielA 8 posts Joined 06/13
17 Oct 2014

Thanks for the responses .. think datamover is going to be my best option

tanveersattar 1 post Joined 07/11
17 Oct 2014

Upcoming Teradat Query Grid is going to provide this functionality but for now moving data across is only way, either via Data Mover or manually.

Raja_KT 1246 posts Joined 07/09
19 Oct 2014

I heard that Query Grid is already launched ? Is it not so?

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.