PowerDesigner-MDDE-Extension

A PowerDesigner LDM extension to support Model Driven Data Engineering using PowerDesigner LDM models.

• Introduction
• Getting started
• Manual
• Contributing

Introduction

This extension is to add extra modeling possibilities to LDM models, where standard PowerDesigner functionalities are missing options to add metadata. These extra modeling options are listed below per object type.

• Entity
  • Mapping
    • Custom source objects tab on mappings.
      • To support using the same source object twice in a mapping in a different role.
      • To specify join type and conditions on source objects.
      • To specify period offsets on source objects (for example last month).
    • Examples tab on mappings so example input and output data can be specified in the model.
  • Business rule (stereotype)
    • Add support for modeling business rules with input/output attributes and examples.
    • Supported sub-stereotypes:
      • Scalar business rule
      • Filter business rule
      • Aggregate business rule
      • Pivot business rule
      • Custom business rule
• Model checks
  • Extra model checks have been implemented to verify the newly supported objects.
• PowerDeComposer integration
  • To allow version management of PowerDesigner files in Git the tool PowerDeComposer have been implemented. In this extension a menu item on models have been added to decompose a model using PowerDeComposer.
• XML export
  • To generate code, tests, etc. using CrossGenerate for the model an XML export has been implemented on model level.

In many cases it is helpful to customize the XML Export to include project-specific extensions. The MDDE Model Export Extension can be used to include this type of project-specific model content in the MDDE XML Export without modifying the MDDE extension.

Getting started

These prerequisites are needed when you want to start using the extension(s).

• PowerDesigner 16.6 or higher.

In order to get started with the extension(s), perform the following steps:

1. Download the MDDE Extension from the latest release.
2. Attach the extension to an existing or new Logical Data Model in PowerDesigner. Instructions can be found here.
3. Start using the extension. Consult the modeling manual for instructions.

Manual

There is a manual available here on how to use the PowerDesigner extension.

Contributing

Contribution are very welcome. Please read the page on contributions here.