How to add #Erwin Extended Notes to a #PowerDesigner model

Recently I was looking at the list of new features in Erwin Data Modeler 2020, and one feature caught my eye – Extended Notes.

I knew that I could add a very similar feature to any object in PowerDesigner in less than 10 minutes, with absolutely no programming.

Here’s a simple Logical Data Model – the Entity “Contact Type” has four Extended Notes (one of those has its own Extended Note)

Here’s one of those notes. The properties are all standard, except for Status , Author, and Importance, which I defined in a Model Extension.

These Extended Notes can be compared and merged using the standard PowerDesigner Merge / Compare utility, and I can include them in Reports, List Reports, and Dependency Matrices

Want to see how it’s done? Watch this video.

To discuss how you can the best out of SAP PowerDesigner, go to the Contact page

From ontology to data model, with the #PowerDesigner Glossary

The Glossary is one of the key enterprise resources provided by SAP PowerDesigner – it helps you capture and manage the terminology to be used when naming your models and objects in your models.

What if you want to use your Glossary in a different way – as an ontology? What if you want to use the Glossary to generate content in your models?

That’s exactly what I was asked recently – the good news is that PowerDesigner is designed to be extended. We can meet our objective in several ways:

  • write a script – Design and build all the logic yourself
  • define a simple ‘Object Generation’ – Simple to set up, limited in scope
  • define an ‘Extended Object Generation’ – Simple to set up, will need some scripting to tailor the results

I created a couple of demonstrations for my client, and decided to share them with the world via YouTube.

This video has three parts:

  • the Introduction at 00:22
  • a demonstration of the capabilities of a script at 06:21
  • a demonstration of Object Generation and Extended Object Generation at 08:48.

To discuss how you can the best out of SAP PowerDesigner, go to the Contact page