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 details about CIS, see Component Integration Services User's Guide for Adaptive Server Enterprise and OmniConnect.
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.
See System Administration Guide: Volume 2 > Accessing Remote Data.