Generating a new Sybase IQ, SAP HANA, or ASE Model from an ESP Schema Model

Generate either an SAP Sybase IQ, SAP HANA, or an SAP Sybase ASE physical data model from an ESP Schema logical data model.

  1. Open the ESPSchema model.
  2. From the PowerDesigner main menu, choose Tools > Generate Physical Data Model.
  3. In the General tab of the PDM Generation Options dialog, choose Generate new Physical Data Model.
  4. For a new model, choose the target DBMS and the appropriate Name and Code.
    • For HANA, choose:
      Field Value
      DBMS SAP HANA Database 1.0
      Name Keep the default, ESPSchema, or enter another name.
      Code Auto-generated from Name. For example, when Name is ESPSchema, Code is ESPSCHEMA.
    • For ASE, choose:
      Field Value
      DBMS SAP Sybase Adaptive Server Enterprise 15.7
      Name Keep the default, ESPSchema_1 (the name of the container), or enter another name.
      Code Auto-generated from Name. For example, when Name is ESPSchema_1, Code is ESPSCHEMA_1.
    • For IQ, choose:
      Field Value
      DBMS SAP Sybase IQ 15.X
      Note: Use latest version of SAP Sybase IQ available.
      Name Keep the default, ESPSchema_1 (the name of the container), or enter another name.
      Code Auto-generated from Name. For example, when Name is ESPSchema_1, Code is ESPSCHEMA_1.
  5. Click the Detail tab.
  6. (Optional) Choose Check model and Save generation dependencies.
  7. Ensure that Enable transformations is selected.
  8. Click the Extensions tab and ensure that the appropriate extension is selected:
    • ASE when generating a new SAP Sybase ASE model
    • IQ when generating a new SAP Sybase IQ model
    • HANA when generating a new SAP HANA model
  9. On the Pre-generation and Post-generation tabs, ensure that all transformation rules are selected.
    The post-generation tab appears only for new models.
  10. On the Selection tab, select ESPSchema to create tables for SAP Sybase IQ, SAP HANA, or SAP Sybase ASE, and choose OK.
Next
After generation, check indexes, set physical options, and add foreign keys as needed.
Parent topic: Model Generation