Create a Teradata view to an external Teradata Server

Connectivity
Enthusiast

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

5 REPLIES
Enthusiast

Re: Create a Teradata view to an external Teradata Server

Teradata Employee

Re: Create a Teradata view to an external Teradata Server

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

Enthusiast

Re: Create a Teradata view to an external Teradata Server

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

Teradata Employee

Re: Create a Teradata view to an external Teradata Server

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.

Enthusiast

Re: Create a Teradata view to an external Teradata Server

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