Connections from Other Databases

You can access data in Sybase IQ tables as a foreign data source from Adaptive Server Enterprise. To take advantage of this feature, use the Component Integration Services (CIS) interface, which makes data from distributed, heterogeneous sources available to clients.

With CIS, define “proxy tables” in Adaptive Server Enterprise that represent your Sybase IQ tables. You can then query the proxy tables from Adaptive Server Enterprise. See Component Integration Services Users Guide for Adaptive Server Enterprise.

CIS and Sybase IQ offer several other ways 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 supported on only some platforms. See the 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 from separate Sybase IQ databases.

See System Administration Guide: Volume 2 > Accessing Remote Data.