Proxy Tables (ASE/SQL Anywhere)

A proxy table is used to access data in a remote table; it has all the attributes of the remote table, but does not contain any data locally. PowerDesigner uses an extension file to provide support for generating the script for a proxy table in order to run it in an ASE or SQL Anywhere database.

1. To enable the proxy table extensions in your model, select  Model  Extensions , click the Attach an Extension tool, select the Proxy Tables file (on the General Purposetab), and click OK to attach it.
2. For each proxy table, right-click a table in another PDM target model, drag it to the model where you want to create a proxy table, release the right mouse button and select one of the following:
   • Create Shortcut Here - Creates a non-modifiable reference to the original table.
   • Replicate Here - Creates a modifiable reference to the original table. You can desynchronize the Code property of the replica to give the proxy table a different name in the local model.

   For more information about shortcuts and replicas, see Core Features Guide > Linking and Synchronizing Models > Shortcuts and Replicas.

   Note A custom check verifies that the proxy table is not the child table of a reference.
3. Right-click the model in the browser and select  New  Data Source  to create a new data source to provide access to the remote tables on the server, and ensure that the GenerateAsProxyServer property on the Extended Attributes tab is set to True.
   Note A single data source can contain information for several models if they represent a single remote server.
4. Add the models from which you have drawn your proxy tables in the Models tab.
5. Click the Database Connection tab, and define the data source name, login and password and click OK to return to your model.