A review of “Best data modelling tools” falls well short of my expectations #PowerDesigner #erwin #erstudio

ITPro have just published an article called “Best data modelling tools“. When I clicked on the link in my regular ITPro email, I expected to find a well-reasoned set of arguments about the pros and cons of several tools, based upon a defined list of expectations.

I was hugely disappointed by what I found in this ‘In-depth’ (their words, not mine) review. My score for this ‘review’ – 1 out of 10.

It’s probably better to say that I was disappointed by what I didn’t find – there is no list of expectations, and there are no well-reasoned arguments. The authors do acknowledge that there are “subtle differences between the leading platforms”, but they fail to describe them.

There are just a few words to describe each of seven tools, two of which are from the same vendor, with no attempt at any form of comparison. The reader is left none the wiser about their capabilities.

By the way, the folks at Erwin will be very disappointed by this review, as their tool isn’t even mentioned.

What makes #PowerDesigner different? Find out at my #DMZone session in Dusseldorf next week

Next week at Data Modelling Zone in Dusseldorf, I’ll be demonstrating my favourite features of SAP PowerDesigner. These range from simple usability to advanced tinkering, none of them are rocket science. Most of them are not available in other competing tools.

Challenge me with a feature of your favourite data modelling tool that you just can’t live without, and I’ll show you how to handle it in PowerDesigner.

Here’s the list of features I intend to demonstrate:

  • What if you draw that relationship in the wrong direction, or between the wrong entities? You don’t need to delete it, just edit it
  • Tidy up that diagram – have more than one symbol on the diagram for that busy entity
  • When you connect two objects together, the link is visible from both ends (even if they’re from two different models, or different types of models)
  • Multiple editing windows – individual objects and lists of objects, from multiple models
  • Copy and paste from a list of Objects straight into Excel, complete with headers
  • Import anything from Excel without writing any code
  • Link anything to anything if you have a need to, using Traceability Links
  • Add new properties, and new types of object, and links between them
    – how about adding Data Stewards, and linking them to the entities they’re responsible for?
  • Dependency matrices – show (and edit) links between objects
  • Create a model within a model – useful for Subject Area models
  • How about generating that LDM as JSON structures for your fancy governance tool to ingest?
  • Tailor how PowerDesigner generates DDL, and even invent your own DBMS and funky new DDL syntax
  • When you generate one model from another (e.g. generating a PDM from a LDM) you can change what happens using model transformations – such as the model transformation that makes sure your PDM tables all have the correct audit columns
  • Who needs Visio? Use a ‘Free Model’ to invent your own type of model

 

I have a new blog post at 2nd Quadrant, called “Data Modelling – It’s a lot more than just a diagram” (illustrated with #PowerDesigner) #DataVault

New direct URL for #ERStudio training and consultancy services – www.erstudio.training

Finding the right URL isn’t always easy, even with Google, so we’ve registered a couple of useful domains.

New direct URL for #PowerDesigner training and consultancy services – www.powerdesigner.training

Finding the right URL isn’t always easy, even with Google, so we’ve registered a couple of useful domains.