The power of Database Definition files in SAP PowerDesigner – 15:00-16:00 CET on October 26th

One of the biggest strengths of SAP PowerDesigner is the ability to configure and extend the modelling environment, allowing you to adapt the tool to suit the way you want to work, instead of adapting the way you work to the limitations of the tool. For example, PowerDesigner allows you to configure and extend the support provided for a DBMS, by modifying the ‘Database Definition File’.

In this session Ondřej Diviš from MIBCON DIMA s.r.o. will describe some scenarios where the ability to configure and extend DBMS support can help you significantly.

He will show you how to modify:

  • the algorithms responsible for reverse engineering a database into a PowerDesigner PDM
  • templates for generating DDL script from a PDM

Click here to register


Ondřej Diviš

For 14 years I`ve been focused on CASE tool PowerDesigner and how it could be deployed to our customers in order to support their processes in most effective way. My job is kind of my hobby too (besides my family, motorbike and badminton) and I like to explore all the possible (and some impossible too) ways of extending and customizing PowerDesigner. What have I found so far? That PowerDesigner can help you significantly with so many tasks/processes around DBs (and processes, applications, development, architecture,…) that it is hard to imagine it, when you say it is just “another CASE tool”. And that is what I like to reveal to our customers too.

New code added to a Database Definition file

The FIB-DM is available for ER/Studio now #FIBO

The free version of the Financial Industry Business Data Model has been downloaded many times – it’s managed using the SAP PowerDesigner modelling tool, and users of other data modelling tools need to import the PowerDesigner Logical Data Model that is supplied. There are two concerns here:

  • FIB-DM is a very big model with some deep super/subtype hierarchies
  • even if your tool can import a PowerDesigner model, the chances are that the import doesn’t work perfectly

If your tool of choice is Idera ER/Studio Data Architect, you can use the built-in metadata import feature to import the PowerDesigner model, but I know that you won’t be happy with the result, so I’ve converted the model for you.

Watch this very short video to take a look at the model, or click here to download the model or just find out more about it.

Like what you see? Click here to download the model or just find out more about it.

I’ve cancelled my newsletter due to the preponderance of unexpected content

I’ve had a newsletter covering the top three data modelling tools (ER/Studio, Erwin and PowerDesigner) for a few years. I have a pre-defined set of sources that should (in theory) restrict the content that gets included, to make sure the content is all relevant. That does not work the way it should – every week I have to check the content to see what has slipped through, so I can decide whether or not to remove it (even though it may appear as a headline in the email notifications).

Take today’s newsletter for example – only one out of five entries is from one of my defined sources, and I know of other qualifying content that should have been included (some it from my own website). The first four items are all shared from Twitter, and none of those tweets mention the keywords I’ve specified.

Today i went into the settings and told it to check for new content – the content was refreshed, and now it all comes from just one of my defined sources.

It’s time to ditch this newsletter and try a different approach. I’d like to say thank you to everyone who has subscribed in the past.