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 extended model definition to the model containing proxy tables, a specific contextual menu is displayed on the physical data model item, this menu command is used for building the data source of the proxy tables.

Note: This command does not build data sources for target models that are closed in the workspace.

  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.

    You can also 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: Working with Proxy Tables in Sybase ASA and ASE
Previous topic: Creating a Proxy Table
Next topic: Generating the Remote Server and Proxy Tables Creation Scripts