Defining the Remote Server of a Proxy Table

The remote server is the model containing the target tables of the external shortcut or replica. The remote server is defined using a data source in the proxy tables model; this data source provides access to the remote data on the server.

Note: the same data source can contain information for several models that share the same remote servers.

When you attach the ProxyTables extension file to the model containing the proxy tables, a new command is added to the contextual menu for the physical data model item. The target models must be open in the workspace in order for the command to build data sources for them.

  1. Create a new data source and set the GenerateAsProxyServer extended attribute to True.
  2. Add the target models in the Models tab of the data source property sheet or right-click the model that contains replica and/or shortcuts in the Browser and select the Build Proxy Tables Data Sources command. A data source is automatically created for each target model.
  3. Double-click a data source in the Browser to display its property sheet.
  4. Click the Database Connection tab, and define the data source name, login and password.
  5. Click OK.
  6. Repeat steps 2 to 5 for each data source.
Parent topic: Proxy Tables (ASE/SQL Anywhere)
Previous topic: Creating a Proxy Table
Next topic: Generating the Remote Server and Proxy Tables Creation Scripts