Querying remote and heterogeneous databases

This section summarizes how you use Sybase IQ with Component Integration Services (CIS). CIS allows you to query Adaptive Server Enterprise databases and remote databases or nonrelational data sources through Sybase IQ. CIS is installed as part of Sybase IQ.

Using CIS, you can access tables on remote servers as if the tables were local. CIS performs joins between tables in multiple remote, heterogeneous servers and transfers the contents of one table into a supported remote server.

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, following the steps in the System Administration Guide: Volume 2.

2. Map the remote tables to the proxy tables.

3. 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