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.

  1. Select Model > Extended Model Definitions, and click the Import tool.
  2. Select the ASA Proxy Tables or ASE Proxy Tables extended model definition and click OK to attach it to the model.
  3. Click OK to close the List of Extended Model Definitions and return to your model.
Note:

You can also attach an XEM at model creation time by clicking the Select Extensions button on the New Model dialog.

The ProxyTables extended model definition contains generation templates, extended attributes, custom checks and custom methods to support the definition of external proxy tables.

You can double-click the ProxyTables extended model definition in the Browser to display its properties in the resource editor. 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.

Parent topic: Working with Proxy Tables in Sybase ASA and ASE
Next topic: Creating a Proxy Table