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.

Generating a macro to update an ER/Studio model from a #PowerDesigner model

I’m working on my process to convert the FIB-DM model from SAP PowerDesigner to Idera ER/Studio Data Architect. I’d like to improve on the standard import. so I considered exporting metadata from PowerDesigner into one or more Excel workbooks, then writing ER/Studio macros to read the Excel workbook and update the ER/Studio model. Then it occurred to me – there’s an easier way.

Using the Generation Template Language in PowerDesigner, I can generate the ER/Studio macro with all the metadata embedded (like using Mail merge in Microsoft Word to create a document containing content from Excel). I have to use two different programming languages, but I’d have to do that anyway. This way, I know the macro has the right content, I don’t need to make sure I’m importing from the right Excel file.

Here’s a sample of the output – it’s a mixture of boilerplate text and metadata, all controlled by logic based on the model contents.

Here’s the top-level GTL Template that creates this. The boilerplate text is in black and the metadata selection is in blue:

Intrigued by how this is done? Want to know more? Go to the Contact page to find out more.