Linking/Joining Different Databases in Teradata

Teradata Applications

Linking/Joining Different Databases in Teradata

I am trying to link/join 2 different databases from 2 different servers in a query, but I can't seem to get it to work What is the trick?
6 REPLIES
Teradata Employee

Re: Linking/Joining Different Databases in Teradata

This would require TD15 plus QueryGrid Teradata-to-Teradata.

Re: Linking/Joining Different Databases in Teradata

I have successfully create the Foreign Server between TD and TD but not able to select data: get error "Server object not associated with operator". then I tried to add IMPORT clause(syslib.load_from_td) and getting error function does not exists.

Here please note the verions information as well:

version:15.00.03.04 and same release.

Do we need to install something extra?

Teradata Employee

Re: Linking/Joining Different Databases in Teradata

Yes, the Foreign Server grammar is built-in; but QueryGrid table operators are not. Contact your Teradata sales team for details.

Re: Linking/Joining Different Databases in Teradata

Thanks Fred for the input. Is there any specific reason that Teradata is not providing this TD to TD linked server by default. As in other DBMS like SQL server this feature helps to communicate between two different appliances. Which some time become tricky in Teradata.

KN
N/A

Re: Linking/Joining Different Databases in Teradata

Given that the table operators and grid connectors are installed wanted to know if query grid can talk from system running on 15.0 to a system on 15.10 or vice a versa?

Teradata Employee

Re: Linking/Joining Different Databases in Teradata

Question to clarify about the QueryGrid T2T CREATE FOREIGN SERVER Command

ip_device / local_ips - The DNS name of the local Teradata nodes or the IP addresses of the local Teradata nodes. One or the other is required, but not both. ip_device supports a common node device name, but the device name found by using ifconfig must be on the same network

for all nodes of the system.

remotehost - The DNS host name or IP address of the remote Teradata Database system.

1. When it states, "The DNS name of the local or remote Teradata nodes", does that mean listing all of the Fully qualified DNS node name for all TPA Nodes on the local and remote Teradata systems? 

2. Can the local_ips and remotehost values be the DNS COPName for the local and remote Teradata systems?

I read:

1. An incident when the remotehost strings are greater than 256, an error ocurrs in the remote server QueryBand, and

2. All TPA nodes need to be listed in the local_ips and remotehost stings.