Querying remote and heterogeneous databases

This section summarizes how you use 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.

StepsTo join remote databases:

  1. Create proxy tables, following the steps in the Sybase IQ System Administration Guide.

  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_asiqdemo..cust2 a, 
    asiqdemo..orders b
    WHERE a.c_custkey = b.o_custkey
    

For more information, see Chapter 16, “Accessing Remote Data” and Chapter 17, “Server Classes for Remote Data Access” in Sybase IQ System Administration Guide.