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 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	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 Adaptive Server Enterprise 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 ASE, and choose OK.

• Checking Indexes
  PowerDesigner creates default indexes. Add, edit, or remove them as needed.
• Setting Physical Options
  Set physical options for each table as needed for your SAP Sybase IQ or ASE database.
• Adding Foreign Keys
  Add foreign-key relationships to physical data models.