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

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

1. Open either the IQ, HANA, or ASE model.
2. From the PowerDesigner main menu, choose Tools > Generate Logical Data Model.
3. In the General tab of the LDM Generation Options dialog, choose Generate new Logical Data Model.
4. Specify a Name.
   Code is autogenerated from the name.
5. On the Detail tab, choose Options:
   • (Optional) Check model
   • (Optional) Save generation dependencies
   • (Optional) Convert names into codes
   • (Required) Enable transformations
6. On the Extensions tab, choose ESPSchema.
7. On the Selection tab, choose tables from which to generate schema.
8. Choose OK.