SAP PowerDesigner Valuable Features

Fraven Ang
Manager, Data Architecture at DFS Singapore Pte Ltd
One of the key reasons for choosing this solution above others is because of the repository features which we're able to consolidate and work on a single repository where we store all our models in one location. In addition, the web portal feature allows us to present, or actually view these models from a browser's perspective. We have two groups of people: The first develops the models and the second views them. They can log in to a web portal and view the models. The product presented a strong case for us in deciding to establish this kind of creation and consumption model to make it really cost effective and increase the value of our organization. View full review »
MichaelRaz
DA with 1,001-5,000 employees
SAP Powerdesigner helps build proper data models based on the methodology of relational databases, which are now 40 years old. I think the big advantage of Powerdesigner over erwin is its intuitive Microsoft like usability. It's much easier to use PowerDesigner than erwin. It's also a cheaper product, and it supports many different relational databases. I think PowerDeisgner is more practical, easier, quicker, and more intuitive. I prefer to use Powerdesigner over erwin for large enterprise applications. It's a great tool for documentation. A new data scientist can easily understand the data just by looking at it. Once you are managing your physical data with a logical data model, by looking at this data model, you can understand what it means, the business meaning of the elements which are maintained by the relational database. View full review »
Moorthy Natarajan
Chief Architect at Imagic Consultancy Limited
I'm an IT architect. I make use of this particular tool end-to-end, especially when I design objects. I also can immediately create the frameworks in PowerBuilder. In just one click, I can create everything that I want. I can download the solution right onto my PC. It's a fantastic tool. It offers lots of flexibility. It saves companies pain and it keeps everything consistent. Whatever the idea was that started at the business level can go down to the database level. It offers a lot of features in one solution. You would have to get multiple other products to bundle together all of the capabilities that you get in just this product. View full review »
Learn what your peers think about SAP PowerDesigner. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
455,164 professionals have used our research since 2012.
George McGeachie
PowerDesigner and ER/Studio Consultancy and Training Specialist at a tech services company with 1-10 employees
The architecture of PowerDesigner is designed with extensibility in mind, supporting comprehensive customisation and automation features which allow customers to make the tool fit the way they want to work, embedding those new features directly into the tool itself. For example, the built-in Template Language enabled me to add a feature to export the structure of a Data Model as a JSON-format file for ingestion by a Data Governance tool. Even if you don't customise or extend PowerDesigner, the tool is still the easiest modelling tool to use, with spreadsheet-like editing capabilities, the ability to link to or replicate (in a managed fashion) objects from a different model. The bi-directional traceability between objects and models is also a key differentiator - whenever you connect two objects together, that connection is visible from both objects (this may sound obvious but, believe me, other tool vendors don't seem to think it's important enough). View full review »
reviewer1365882
Senior Principal IT Architect -- MDM Architecture at a healthcare company with 10,001+ employees
I like the property sheet capability and the user-defined attributes that you can set up. The central repository is helpful because they have the ability to check-in models when working as part of a larger team. It supports versioning, as well. View full review »
Carel Van Der Merwe
CEO at Abellard
I do a data-centric design, so for me, the data analysis and design tools are the most valuable features. The interface is user-friendly. Because of the graphic nature of it, it helps you to be able to manage complicated systems much easier. View full review »
Peter Vlekkekn
Team leader and Data / Information Architect at a tech services company with 201-500 employees
The generational DDLs and the graphics are the solution's most valuable aspects. The solution is a very pragmatic tool. It's quite easy to use. The solution is very good for data modeling on a conceptual and physical level. There are a lot of design tools that are very complicated to use, and customers will not use them in detail. I find the solution to be one of the best tools in the range. View full review »
Ondrej Divis
Senior Consultant at Mibcon DIMA
The most valuable features are its user-friendly extensibility, impact & lineage analysis, and source/target mappings. It can be configured to display only relevant objects across all models, of any type. It has a public meta-model and the ability to automate many features so that the users can focus on what really matters, as opposed to the formal requirements of the modeling work. View full review »
reviewer1318779
Data Architect at a pharma/biotech company with 1,001-5,000 employees
The most valuable feature is that it is a very fast reverse engineering process. It does a very expansive comparison. View full review »
MahdiJalali
Founder at Rozhmaan
The most valuable feature is that we can convert CDM (Conceptual Data Model) to PDM (Physical Data Model), and then prepare an SQL statement to be executed. It has a powerful engineering feature where if you change the data on a secure server then it will change it in PowerDesigner, too. This solution has good tools for big data, where you can manage large and complex databases. By comparison, tools such as Enterprise Architect and Visio have problems with big databases. View full review »
reviewer1477701
Data Architect at a financial services firm with 501-1,000 employees
I like the connectivity or the lineage between the models and usability. View full review »
Learn what your peers think about SAP PowerDesigner. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
455,164 professionals have used our research since 2012.