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.

https://learndatamodeling.com/blog/new-features-in-erwin-release-2020-r1/

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 www.metadatajunkie.wordpress.com/contact/

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 www.metadatajunkie.wordpress.com/contact/

Here are the slides from my 2-hour #PowerDesigner presentation to the UK SAP Database & Technology User Group (UKSUG) today

This was an opportunity I could not miss – a 2-hour presentation on modelling to an audience of database experts!
Starting with a brief look at using Visio and/or Excel for data modelling and governance, I talked about the extras we can gain by using PowerDesigner to design databases.
Of course, it’s not ‘just’ databases we’re concerned with, the relationships those databases have with our business and technical architecture is also important.
The next key topic is the role of Data Models and others (such as the Requirements model) in Governance and Design.
Next it’s mapping data sources and targets to demonstrate and create data lineage, showing how PowerDesigner supports multiple DBMS Versions (and what you can do to change how it does that), creating a CUBE for Business Objects, finally (almost) focusing on the support provided for SAP IQ.
Finally, I described some real-world uses of PowerDesigner.

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
uksug@pbprojects.co.uk

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.

#PowerDesigner chinwags – what topics would you like to discuss?

The chinwags have been running for a few weeks now, and we’ve discussed some interesting topics. So far, we’ve just talked about what’s on somebody’s mind at the time, there hasn’t been an agenda of any kind. I’d like at least some of the sessions to be more structured, and I’d like to involve people on the opposite side of the world to me (I’m in the UK), so I have two questions for you:

  1. would you be interested in joining a chinwag at 20:00 or 21:00 GMT on Tuesdays?
  2. what topics would you like to discuss with your fellow PowerDesigner users?

Topics can be anything you like, such as: 

  • basic usage of the tool – the tool has a lot of features, not all of them very obvious to new users
  • support for SAP platforms or cloud databases
  • data governance
  • model-driven development
  • scripting and customisation
  •  etc.

If you’re an expert on a topic and you’d like to volunteer to talk about it, don’t hold back :).

If we need an expert on any particular topic I’ll find one.

To make suggestions or find out more about the chinwags, go to https://metadatajunkie.wordpress.com/pd-chinwags/. If you prefer to use the SAP Community, go to https://answers.sap.com/questions/13044749/what-topics-would-you-like-to-talk-about-in-the-po.html instead.

#PowerDesigner adds support for #SnowflakeDB

In the latest version of PowerDesigner (16.7), SAP have added support for Snowflake to the Physical Data Model. There isn’t space here to demonstrate everything they’ve provided so here’s a summary.

There are new properties for Tables, Columns, etc.:

SchemaNew Physical Options tab
UserNew Options and Object Properties tabs
TableNew Persistence property, plus Physical Options
ReferenceNew Options tab
ColumnNew Collation property, plus Physical Options

There’s a raft of new object types you can create:

  • File formats
  • Integrations
  • Managed Accounts
  • Network Policies
  • Notification Integrations
  • Pipes
  • Procedures
  • Resource Monitors
  • Sequences
  • Object Shares
  • Storage Integrations
  • Warehouses

To find out more about these new features, follow these two simple steps:

·        Search for PowerDesigner stuff on SAP.com – https://help.sap.com/viewer/p/SAP_POWERDESIGNER

·        click on the “New Features Summary” link

Join @MetadataJunkie for regular PowerDesigner chinwags

In these days of lockdown and working from home, the feeling of isolation from your peers can be considerable. Well, you’re not alone – join George McGeachie (@MetadataJunkie) for the new, regular, chinwag sessions.

The PowerDesigner chinwag sessions are your opportunity to discuss any topic related to SAP PowerDesigner. There are two one-hour sessions each week and you can participate as often as you want to.  Join us for 10 minutes or stay for the full hour.

  • earlier chinwags – Monday 10:00 GMT to 11:00 GMT
  • later chinwags – Wednesday 14:00 GMT to 15:00 GMT

Click here to find out more

Click here if you prefer a personal 30-minute one-to-one chinwag with George McGeachie

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: https://calendly.com/metadatajunkie/30mins