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 a Sybase ASA or ASE 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 Purpose tab), 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.

• Generating the Remote Server and Proxy Tables Creation Scripts
  You can generate the remote server and proxy tables creation scripts from the model containing proxy tables in order to run them in the database.