Data Modelling Zone is unique among conferences in the topics it focuses on, which is great for me!
I’m really looking forward to meeting my colleagues from across the channel and elsewhere in the world from Tuesday evening to Friday in Stuttgart. It’s the one event of the year where I can guarantee to meet a lot of PowerDesigner users 😉.
I’m even looking forward to my 07:30 speaking sesson on Friday 😊
If you’re an early riser, join me for a 30-minute session on the 8th of November at Data Modelling Zone – I’ll discuss the reasons why data modellers need to take an interest in managing JSON-structured data, and then focus on the technicalities of managing JSON data structures in modelling tools and establishing that all-important data lineage.
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
Following on from our successful PowerDesigner meeting in London this week, we’re please to announce another, at Steve Hoberman’s Data Modelling Zone conference in Hanover, Germany, in September. It’s so new, it’s not on the agenda yet – see http://www.datamodelingzone.com/ProgramEurope.aspx.
Please contact me if there are any PowerDesigner topics you want to hear or speak about.