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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access » Remote table mappings


Creating proxy tables that map to remote data

To have remote tables appear as local tables to the client, you create local proxy tables that map to the remote data.


DBA authority.

Context and remarks


 Create a proxy table that maps to remote data
  1. Define the server where the remote data is located. This specifies the type of server and location of the remote server.

  2. Map the local user login information to the remote server user login information if the logins on the two servers are different.

  3. Create the proxy table definition. This specifies the mapping of a local proxy table to the remote table. This includes the server where the remote table is located, the database name, owner name, table name, and column names of the remote table.


The proxy table is created and is mapped to the remote table.



 See also