Teradata Querygrid between 2 organisation

Teradata Database on Azure
Highlighted
Enthusiast

Teradata Querygrid between 2 organisation

Hi ,

 

Can teradata querygrid be used between 2 different organisations while in cloud?

Let's say in case of acquisition between 2 companies, with the help of teradata querygrid in cloud, can 1 company's teradata be merged with another company's teradata to get the data output by joining those 2 company's TD DB's and tables. 

Thanks in advance


Accepted Solutions
Teradata Employee

Re: Teradata Querygrid between 2 organisation

Please consult customer service representative more about the policies to get the data from two organizations. If you are allowed to migrate/backup data from one organization & restore it to another, then logically it is possible to join the tables of two organizations from QueryGrid perspective if the network communication exists.

1 ACCEPTED SOLUTION
5 REPLIES
Teradata Employee

Re: Teradata Querygrid between 2 organisation

Let me repeat your requirement:

- QueryGrid Manager is in Cloud

- Using Querygrid, would like to join tables from two Teradata database systems, located in different region/location/datacenter.

 

If you have the network communication between Teradata database systems, QGM server to Teradata DB systems and having compatible versions to configure QueryGrid between them, then the answer is YES. You can join the tables from different sources.

Enthusiast

Re: Teradata Querygrid between 2 organisation

Thanks Arjun for the reply.
But specifically asking is it possible to join 2 organisations (company 1 acquired company 2) databases together in query grid while in cloud.
The TD DB's belong to different companies but lets say now one of the company acquired another company..
Teradata Employee

Re: Teradata Querygrid between 2 organisation

QueryGrid just treats the two organizations as Teradata database systems. It's upto the customer about policies on getting data from different organizations.

 

You scenario is something like joining tables from two environments, let's say DEV and PROD systems using QueryGrid.

Enthusiast

Re: Teradata Querygrid between 2 organisation

Thanks arjun. I think I got the answer as you said "QueryGrid just treats the two organizations as Teradata database systems".

But it is not 2 environments. But it is 2 organisations only. PROD DB (company A)to PROD DB (company B). 

Teradata Employee

Re: Teradata Querygrid between 2 organisation

Please consult customer service representative more about the policies to get the data from two organizations. If you are allowed to migrate/backup data from one organization & restore it to another, then logically it is possible to join the tables of two organizations from QueryGrid perspective if the network communication exists.