Data Modeling Scenarios

Integrated modeling supports efficient schema definition and database design, and consistent production deployments.

Using the ESP Schema and extensions, you can:

Model schema in the ESP Schema model, a PowerDesigner logical data model
Convert an ESP Schema logical data model to SAP HANA, ASE, or SAP Sybase IQ physical data models
Convert existing SAP HANA, ASE, and SAP Sybase IQ physical data models to an ESP Schema logical data model
Import schema definitions defined in a CCL file into an ESP Schema model
Export schema definitions from an ESP Schema model into a CCL file
Validate a model using custom checks for ESP Schema, in addition to the standard PowerDesigner checks
Analyze the impact of changes to schema, a model, or a database table on all components in the integrated model

The corresponding adapter (IQ, HANA, ASE) schema must match the SAP Sybase IQ, HANA, and ASE database schema for all tables in which data is inserted. After you make changes, you can use PowerDesigner to produce a set of data definition language (DDL) statements directly from the physical data models (IQ, HANA, and ASE). PowerDesigner saves the DDL in a SQL script that you can run to generate the tables and other objects for the target databases.

DDL generation does not require use of the extended modeling feature.