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

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

I’m looking forward to my 2 hours talking to UKSUG about #PowerDesigner next week

Discover the history and key capabilities of SAP PowerDesigner (it’s more than just a data modelling tool), and how it can make life easier for you in Data Governance and Database Development.
This session will show you why you must not use Excel or Visio for data modelling, and find out just how easy it is to get started with PowerDesigner.
Also discover the hidden power of PowerDesigner’s unique customisation capabilities, such as automating the creation of audit tables.

Wednesday June 10th, from 13:00 to 15:00 British Summer Time

(12:00 to 14:00 GMT)

To register, contact Laura Goss

New topic added to online #PowerDesigner Excel Import course – Importing subtype hierarchies in Barker Notation.

I’ve added a new topic to the ‘Special cases’ section of my online training course for the PowerDesigner Excel Import Wizard – “Importing subtype hierarchies in Barker Notation”.

Barker notation is available in the Conceptual and Logical Data Models, and it handles entity hierarchies differently from other notations – a sub-type entity is actually owned by the super-type entity, and they are depicted in diagrams as ‘boxes within boxes’. There are no Inheritance objects involved, so the Excel Import must be fed different information.

Click here to find out more about this course.

That’s the real beauty of online training courses — new material can be added at any time.

Interested in booking a FREE remote consultation on SAP #PowerDesigner so you can “Work Smarter with PowerDesigner”?

SAP PowerDesigner is a great modelling tool with features that differentiate it from the rest of the market. Here are a few topics you might want to talk about:

  • Understanding PowerDesigner’s Capabilities
  • Planning how you’re going to use PowerDesigner
  • Establishing your Modelling Environment
  • Extending PowerDesigner
  • Training Users

Click here to make a #Calendly appointment:

Work Smarter with #PowerDesigner – improve data modelling productivity with this new model extension

SAP PowerDesigner is a great data modelling tool with features that differentiate it from the rest of the market, increasing the productivity of data modellers.

The CDM LDM Productivity model extension from Metadata Matters improves the productivity of data modellers still further, helping them to visualise, manage and validate their models, concentrating on making modelling decisions, and spending less time on routine tasks.

Attach the CDM LDM Productivity model extension to any Conceptual or Logical Data Model and start using the new features right away. Better still, deploy the extension via the PowerDesigner Repository and have it attach itself to every new Conceptual or Logical Data Model automatically—updates to the extension will automatically be made available to every model that it’s attached to.

The CDM LDM Productivity model extension extends model validation and adds extra options to contextual menus. For example, here are the new options in the contextual menu for an Entity:

Metadata Matters will work with you to customise the extension to meet your own unique requirements – the cost of the extension includes a day of customisation effort.

Here’s a summary of the capabilities provided:

Completeness of DiagramsHow much time do you spend examining a diagram only to discover that something vital is missing? Eliminate the doubt –
– for a given Entity, select from lists of linked objects to add to your diagram
– add all child Entities for an Inheritance
Entity ParentageWhich Entity (or Entities – there may be more than one) is the ‘Ultimate Parent’ of a sub-type in a deep Inheritance hierarchy? The answer may surprise you, and we know that modellers do not like surprises.
Entity Hierarchy DiagramsCreate and refresh a diagram that guarantees to show you the full structure of all the Inheritance hierarchies that an Entity participates in. Here’s a simple example:
Here’s a much bigger example, for an Entity that participates in two hierarchies:
Entity Proximity DiagramsCreate and refresh a diagram that guarantees to show you everything linked to an Entity.
Modelling StandardsSave thinking and working time by automatically moving ‘Primary Identifier’ Attributes to the top of the list and moving the Primary Identifier of an Entity to the top of the list of Identifiers. Ensure that Entity Attributes or Data Items with the <undefined> data type are linked to the default domain.
Applying Naming StandardsConstruct meaningful and useful names for Relationships, Identifiers and Inheritances.
Model ValidationExtend the built-in model validation with new custom model checks, helping you to:
* apply your modelling and naming standards
* check for double-spaces in object names
* check Relationship role names
* be aware of multiple parent Entities or alternate Identifiers
Hiding and Showing Migrated AttributesIf you chose to work with the Logical Data Model but you would like your diagrams to look more like diagrams in the Conceptual Data Model you can – by hiding selected classes of Attributes. Changed your mind? You can always show them again.
Diagram Auto-layoutSpecify the required type of layout and orientation for every diagram and apply it when you want to.
Hiding and Showing Diagram ContentShow or Hide Link Symbols. Remove graphical synonyms or shortcut symbols from a diagram.
Using DiagramsStraighten a link symbol by removing all the corners. A simplified way of changing page size and orientation.
Model StructureIf you’re using Packages in your models, you’ll be aware of the potential pitfalls and how much work there can be if you change your mind about the Package structure. The extension provides two useful features:
* Safely remove a Package from the hierarchy without losing content
* Check if a Relationship and the child Entity have the same owner
Managing Text PropertiesReplace an object Comment with the Description or vice versa.
Scripting SupportOutput the Display Preferences to the Output window.

For more information, click here to go to the Contact page.