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.

Prerequisites

DBA authority.

Context and remarks

Many.

 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.

Results

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

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1