Querying a different database server and database

[Former Member]

Hi guys,

I have 2 SAP IQ databases (X and Y). One is running on server A (staging area) and the other on server B (dwh)

If i am using a connection to server A.X, how can i query tables from B.Y?

I tried:

select table_name

from B.Y.dba.table_name

but it didn't work because A doesn't know B. Do I need to create a linked server somehow?

Thank you

[Former Member · Accepted solution]

Figured it out:

I needed to do the following:

1 - Go to SAP Control Center and create a remote server associated wth the server from where I want to use the connection (in my previous example, A)

2 - Set it as read-only (in my case it's enough) and ODBC based with the odbc name

3 - Create proxy tables by using the SAP Control Center on Schema Objects > Tables > Proxy Tables or by using the SQL statement Create Existing Table

You should now be able to see the object using a connection to A.X

[tayeb_hadjou]

Hi Pedro,

When connected to one IQ database, you cannot direclty query a table from another IQ database, unless you define a proxy table or remote table (insert/location to import data).

Regards,