ESP Schema Model Development

Develop schema using the PowerDesigner extensions.

You can:

Explore the sample model
Create a schema model using categories, or by creating and extending a logical data model
Add schema to models
Validate your schema with built-in checks, as well as custom ones
Import defined schema definitions into an ESP Schema model from CCL files
Export schema definitions from the ESP Schema model into CCL files

Exploring the Sample Model
Review the sample model from the sample project.
The Sample Model
The sample model includes sample ESP schema, and the SAP Sybase IQ, SAP HANA, and ASE data models.
Creating an ESP Schema Model
Create a new ESP Schema model using the ESP Schema category, either by creating a logical model and extending it, or by generating it from an SAP Sybase IQ, SAP HANA, or ASE model that has been extended.
Validating a Model
Check the validity of your model after schema changes, and before generating schema templates, code, or a physical model.You can check the validity of a model at any time.
Importing a CCL File
Import the defined schema definitions in a CCL file into an ESP Schema model.
Exporting a CCL File
Export all the defined schema from the ESP Schema model into a CCL file for compiling and further analysis.

Parent topic: PowerDesigner for Event Stream Processor