Chapter 14 DBMS-Specific Features

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 appears 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.

Steps To define the remote server of a proxy table:

  1. Create a new data source and set the GenerateAsProxyServer extended attribute to True.
  2. Add the target models in the Models page 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 ODBC tab to display the corresponding page.
  5. Define the ODBC data source name, login and password.
  6. Click OK.
  7. Repeat steps 2 to 5 for each data source.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.