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 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. To enable the proxy table extensions in your model, select , click the Import tool, select the Proxy Tables file (on the General Purpose tab), and click OK to attach it.
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.
The ProxyTables extension file contains generation templates, extended attributes, custom checks and custom methods to support the definition of external proxy tables. Double-click the Proxy Tables extension file (in the Extensions folder) in the Browser to open it in the Resource Editor for review. The following extensions must be defined in the Profile category to fully support proxy tables:
-
BasePackage:
- Generation template - for generating proxy tables.
-
DataSource:
-
Connection information custom check - verifies that the connection information is sufficient to connect to the database. You must specify the data source name, user login and password in the Database Connection tab of the data source property sheet.
- GenerateAsProxyServer extended attribute - when set to true, defines the data source model as the proxy remote server.
-
[various templates] - used for proxy table generation.
- Model:
-
Proxy Servers and Tables generated files - to generate proxy server and table script files.
-
Menu – provides a contextual menu for building data sources and commands in the Tools menu for rebuilding data sources and generating proxy tables.
-
BuildProxyTableDataSourcesand GenerateProxyTables methods - used in the menu.
-
[various templates] - required for proxy server and proxy table script generation.
-
Shortcut:
-
Data source existence custom check - verifies that data sources are defined for the shortcuts.
-
Table:
-
Proxy table is child of reference custom check - verifies that the model replica is not the child of another table via a reference link.
-
[various templates] - required for proxy table, remote server and access definition creation syntax.