Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage


Remote data access

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 this feature to query data across databases.

With remote data access you can:

  • Use SQL Anywhere to move data from one location to another using insert-select.

  • Access data in relational databases such as Sybase ASE, Oracle Database, and IBM DB2.

  • Access data in Excel spreadsheets, Microsoft Access databases, FoxPro, and text files.

  • Access any 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 SQL Anywhere database.

  • Perform joins between tables in separate SQL Anywhere databases. Performance limitations here are the same as with other remote data sources.

  • Use SQL Anywhere features on data sources that would normally not have that ability. For instance, you could use a Java function against data stored in an Oracle database, or perform a subquery on spreadsheets. SQL Anywhere compensates for features not supported by a remote data source by operating on the data after it is retrieved.

  • Access remote servers directly using the FORWARD TO statement.

  • Execute remote procedure calls to other servers.

SQL Anywhere allows access to the following external data sources:


You cannot create a remote server for an UltraLite database running on Mac OS X.

For platform availability, see [external link]

Remote table mappings
Remote servers
Directory access servers
External logins
Proxy tables
Native statements and remote servers
Remote procedure calls (RPCs)
Transaction management and remote data
Internal operations
Troubleshooting remote data access
Server classes for remote data access