Joining Remote Databases

To query a remote database or data source, you need to map its tables to local proxy tables. CIS presents proxy tables to a client application as if the data were stored locally. When you query the tables, CIS determines the actual server storage location.

1. Create proxy tables.
   See System Administration Guide: Volume 2.
2. Map the remote tables to the proxy tables.
   Reference the proxy tables in your SELECT statement, using the proxy database name as the qualifying name for each remote table. For example:

   SELECT a.c_custkey, b.o_orderkey
   FROM proxy_iqdemo..cust2 a, 
   iqdemo..orders b
   WHERE a.c_custkey = b.o_custkey