Working with Proxy Tables in Sybase ASA and ASE

A proxy table is used to access data in a remote table, it has all the attributes of the remote table, but it does not contain any data locally.

PowerDesigner can generate the script for a proxy table in order to run it in a Sybase ASA or ASE database. To do so, you need to attach the ProxyTables extended model definition to your model and then design proxy tables using external shortcuts or replications.

After designing the proxy tables, you can use the build data source feature that will create a data source for each target model of the current model. Target models are models containing the target tables of the replica or external shortcuts, they are also called remote servers.

Once the data sources are properly defined, you can use the extended generation feature to generate the proxy table and remote server creation scripts.

1. Attaching the ProxyTables Extended Model Definition
   For an external shortcut or replica to be used as a proxy table you need to attach the ProxyTable extended model definition to the model.
2. Creating a Proxy Table
   You use external shortcuts and/or replica to design proxy tables in your model.
3. 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.
4. Generating the Remote Server and Proxy Tables Creation Scripts
   You can generate the remote server and proxy tables creation scripts in order to run them in the database. Generation must be started from the model containing proxy tables.