Sybase PowerDesigner® is a tool for creating and manipulating schema definitions which can be used within Sybase Event Stream Processor. Integrated modeling supports efficient schema definition and database design, and consistent production deployments.
PowerDesigner extensions are used for customizing and extending PowerDesigner metaclasses, parameters, and generation. With the extended model setup, you can create and modify schema definitions in the ESP schema model, convert Sybase IQ and Sybase Adaptive Server Enterprise physical models into ESP schema logical models, and import and export schema definitions to and from CCL files. You can also use PowerDesigner for impact and lineage analysis.
PowerDesigner extensions can only be used on Windows platforms. You must purchase PowerDesigner separately to use this feature.
You can use the sample project to modify or extend existing models, or as a guideline for creating new models within the ESP model categories.
In addition, PowerDesigner can be used to produce a set of data definition language (DDL) statements directly from the physical data models. These DDL scripts can be used to create database objects for your Sybase IQ and ASE databases.
For more information on using PowerDesigner, see PowerDesigner for Event Stream Processor in the Programmers Guide.