Sybase IQ and Remote Data

SQL Anywhere remote data access gives you access to data in other data sources. You can use this feature to migrate data into a SQL Anywhere database. You can also use the feature to query data across databases.

See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Remote Data and Bulk Operations > Characteristics of Open Client and jConnect connections.

• Requirements for Accessing Remote Data
  There are several basic elements required to access remote data.
• Remote Servers
  Before remote objects can be mapped to a local proxy table, define the remote server where the remote object is located.
• External Logins
  Sybase IQ uses the names and passwords of its clients when it connects to a remote server on behalf of those clients. However, this behavior can be overridden by creating external logins.
• Proxy Tables
  Location transparency of remote data is enabled by creating a local proxy table that maps to the remote object.
• Example: Join Between Two Remote Tables
  The figure illustrates the remote Sybase IQ tables employee and department in the demo database, mapped to the local server named testiq.
• Multiple Local Databases
  A Sybase IQ server may have several local databases running at one time. By defining tables in other local Sybase IQ databases as remote tables, you can perform cross-database joins.
• Send Native Statements to Remote Servers
  Use the FORWARD TO statement to send one or more statements to the remote server in its native syntax.
• Remote Procedure Calls (RPCs)
  Sybase IQ users can issue procedure calls to remote servers that support the feature.