Overview

Using Sybase IQ you can:

Access data in Sybase databases such as Adaptive Server Anywhere and Adaptive Server Enterprise.
Access data in other relational databases such as Oracle and DB2.
Access desktop data such as Excel spreadsheets, MS-Access databases, FoxPro, and text files.
Access any other data source that supports an ODBC interface.
Perform joins between local and remote data (although performance is much slower than if all the data is in a single IQ database).
Perform joins between tables in separate Sybase IQ databases.
Use certain Sybase IQ features on data sources that would normally not have that ability. Sybase IQ compensates for features not supported by a remote data source by operating on the data after it is retrieved.
Use Sybase IQ to move data from one location to another using INSERT SELECT.
Access remote servers directly using passthrough mode.
Execute remote procedure calls to other servers.

Sybase IQ allows access to the following external data sources: