You can access data in Sybase IQ tables as a foreign data source from Adaptive Server Enterprise. To take advantage of this feature, you use the Component Integration Services (CIS) interface, which makes data from distributed, heterogeneous sources available to clients.
With CIS in place, you define “proxy tables” in Adaptive Server Enterprise that represent your Sybase IQ tables. You can then query the proxy tables from Adaptive Server Enterprise. For related information, see “Matching Adaptive Server Enterprise data types”. For details about CIS, see Component Integration Services User's Guide for Adaptive Server Enterprise and OmniConnect.
CIS and Sybase IQ offer several other ways for you to connect to other databases and share data, so that user applications can access your entire data warehouse through a common interface. Using CIS, you can:
Access data in an Adaptive Server Enterprise database from Sybase IQ. This functionality is only supported on certain platforms. For more information, see Installation and Configuration Guide for your platform.
Access data in Sybase IQ and SQL Anywhere databases on other database servers.
Access other foreign data sources, including other vendors' relational databases, Excel spreadsheet data, and text files.
Join tables in separate Sybase IQ databases.
For details about using Sybase IQ with remote databases, see Chapter 4, “Accessing Remote Data,” in System Administration Guide: Volume 2.
