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

Links

https://mibdima.cz/en/productsheets/PDsolutions.html

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

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.

Book 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

Use the calendar below to find a time slot that suits you: