Log in

PowerDesigner Series

Tips and tricks for PowerDesigner

In loose order I report here about my gain of knowledge with the data modeling tool PowerDesigner. For myself, this series is a kind of diary, a knowledge base and the 'Secret Spice', in which I record my discoveries, my tips and tricks around PowerDesigner documented for myself: For problems of or with PowerDesigner that I had while working on data modeling tasks.

  • Written by Dirk Lerner
  • Hits: 660

PD Series - Customize comments for tables

Customize DDL for table/column comments in PowerDesigner

In several projects, FastChangeCo's data modelers on the Data Management Center of Excellence (DMCE) team had an issue with the way PowerDesigner generates comments for tables and columns for the SQL Server database. Xuefang Kaya (one of the data modelers on the team), asked about the problems, says to the DMCE team:

"No, it's not that PowerDesigner refuses to generate the comments at all. It's more that PowerDesigner is generating the wrong DDL for the SQL Server."

What is the problem?

  • Written by Dirk Lerner
  • Hits: 255

PD Series - Change default value

Change the default value in PowerDesigner or add a new one

At FastChangeCo, the data modelers within the Data Management Center of Excellence (DMCE) team are constantly designing new database objects to store data. One of the data modelers on the team is Xuefang Kaya. When she takes a new user story/task, she usually models multiple tables, their columns, and specifies a data type for each column.

For example, if a column needs to store the timestamp for an event, Xuefang sets the date/time data type for that column (in that case, it even depends on the database in each case). If additional columns have to store names and addresses, it sets the columns to the ‘text’ data type.

  • Written by Dirk Lerner
  • Hits: 441

PD Series - DBMS resource file

Create a customized DBMS resource file

PowerDesigner offers the possibility to edit the properties for a database in the so-called DBMS resource files.

The DMBS resource files contain all information for PowerDesigner to generate DDL, DML and other SQL artifacts. For many databases, there are pre-built, included DBMS resource files for the different database versions. For example, Microsoft SQL Server 2012 and 2017 or Snowflake.

  • Written by Dirk Lerner
  • Hits: 477