We just raised a $30M Series A: Read our story
2019-05-22T07:18:00Z

What advice do you have for others considering SAP PowerDesigner?

5

If you were talking to someone whose organization is considering SAP PowerDesigner, what would you say?

How would you rate it and why? Any other tips or advice?

ITCS user
Guest
1111 Answers

author avatar
Top 5LeaderboardReal User

On a scale from one to ten, I would give PowerDesigner a nine.

2021-01-06T18:51:35Z
author avatar
Top 10Real User

I would highly recommend this product to be used in each and every application system where you have to design a relational database. It doesn't matter which relational database as you can use it for MSSQL, Oracle, Postgres. There are over 50 or 60 different tools like SAP PowerDesigner, but most of them are limited to maintaining a few relational databases like Oracle or MSSQL. But PowerDesigner, as well as erwin can be sued with many different relational databases. This makes it easy to switch and maintain the logical level and then create the DDL for Oracle, MSSQL, MySQL, for DB2, or DB2W. I am using just part of SAP PowerDesigner as a tool. This is because it offers some additional capabilities, like business engineering. Other additional capabilities that I never used because there were additional tools for that. Whether we use Powerdesigner or some other different tool, it's impossible to build an enterprise data model for big application systems. For example, a CIF covering the count and the post. If it's loans, once we have a database with over ten entities, it's very hard to do it manually. You have to work with a tool to create a proper data model, and then a proper database with properly defined entities, primary keys, relationships, and foreign keys. You must have a tool. It's impossible to do it manually. Once such a data model is created, it becomes the source. When trying to understand the beats revolving around magnetic media, you don't have to use the relational data model and the logical data model to understand the data. Once you understand the data, you know the application system. The data is basically a PowerDesigner. The main usage is to design and maintain the data model, the logical data model, and the physical data model. The physical data model is achieved by pushing a button, and the tools will automatically create the DDL. You would just have to implement it as it is. You don't have to write the DDL manually. The business understanding and the business requirements are translated into the physical design one by one. The implementation is according to the business requirement, as a business understanding of the system. On a scale from one to ten, I would give SAP PowerDesigner a nine.

2020-12-20T21:13:35Z
author avatar
Top 10LeaderboardReal User

I'm not using the latest version of the solution, I'm using the one that came out before version 16. When we go to specific clients if they would like us to define it or some other product, what we do is we model whatever things that they want, inside those particular tools. Some of the tools don't have the entire modeling capability that PowerDesigner offers. If a company has a team of people or even one single consultant who has the capability to design business architecture, software architecture, database architecture, or infrastructure architecture, they should go for this particular product. None of the other products offer all of these capabilities in one tool. This is especially true when you design on one model. The architects creating them can pull into the next model - whatever they want to create. For example, if I'm designing a business process diagram, we will be able to capture some data architecture. When we reach the data architecture part of it, all the data items, whatever they already created in the business architecture, can be pulled. It automatically creates the database from the ER diagram. I'd rate the solution nine out of ten overall.

2020-09-22T07:16:08Z
author avatar
Top 10Real User

The key thing is really about the use case or the requirements. We are into enterprise modeling and we are looking at sharing the models and those are the requirements that shift the evaluation criteria. For those looking at stand-alone models, they may not be looking at sharing these, mainly they just want to produce their models and things, so those criteria will differentiate selecting the different products. And whether you have a large team of people or you are focusing on only a few players in a small team, that will also determine your criteria for selecting the product. I would rate this solution an eight out of 10.

2020-08-02T08:16:41Z
author avatar
Top 5LeaderboardReal User

If you have the money for it, buy it. If you were budgeted, it would be a worthwhile investment. I would rate PowerDesigner an eight out of ten. It is very complete and robust. If you're an SAP shop, without question you'd want to use it because you can generate your ETL code as well. That also separates conceptual, logical, and physical modeling really well. I don't know if it's as complete though as erwin's solution. But erwin's solution is evolving and getting better. PowerDesigner has some room to improve, but it's still pretty solid.

2020-07-13T06:55:00Z
author avatar
Top 20Real User

When I began using PowerDesigner, it was an independent product. Since that time, SAP acquired it. It is a very solid product that does both data modeling and business process modeling. My advice for anybody who is implementing PowerDesigner is to make sure that the central repository for versioning models is on a high-bandwidth network with a solid database backing it up. In summary, this product gives you all of the features that a modeler would require to produce both logical and physical data models. There really is not a lot that is lacking and my only complaint is about the versioning repository. Of course, this is only a problem when we are working remotely. If there is a large model with perhaps 600 tables and 2,500 attributes, then it is going to be very demanding on bandwidth. I would rate this solution an eight out of ten.

2020-06-30T08:17:33Z
author avatar
Top 5LeaderboardReal User

I certainly recommend using this product, although it wasn't cheap so cost is a consideration. Price is a complaint that I have for most design tools in the IT world, as most of them are extremely expensive. Corporations and large companies can use them effectively. For me, the GUI is definitely a pleasure. At the same time, there is a steep learning curve when dealing with bigger and bigger systems. Fortunately, the tool helps with that. I would rate this solution a seven out of ten.

2020-05-27T16:23:43Z
author avatar
Top 5LeaderboardReal User

I definitely recommend it, but you still need to do a proof of concept first because it fits into quite a complex set of tasks that companies will be doing. The main purpose is you actually know what you're letting in for and how much work you may or may not have to do to get it to work the way you want because you can customize it. In the next release, I would like to see better support for NoSQL databases. I would rate SAP PowerDesigner an eight out of ten.

2020-05-25T07:16:00Z
author avatar
Top 10Real User

We don't have a business relationship with SAP. We prefer to keep our relationship independent and have no direct relationships with them at the moment. It's certainly a good strategy to migrate to this solution from another tool, but I wouldn't recommend anyone start using it by trying out a trial-and-error strategy. An organization must think first about the migration strategy if they already have a tool and want to migrate before they start. A trial and error approach will waste a lot of time. I'd rate the solution eight out of ten. It's easy to use and you can get good pictures out of it.

2020-02-18T07:41:17Z
author avatar
Real User

Before deploying PowerDesigner, do not underestimate the initial analysis of WHAT will be modeled, as well as HOW and BY WHOM. Are your users prepared well enough for the transition to PD (training, potential changes in the modeling process, ...)? My advice for anybody implementing this solution is not to deploy PowerDesigner fully by yourself. Allow an experienced vendor consultant to explain all of the features and possibilities of the tool to you, and then just decide what and how you want or need to use.

2019-06-18T15:09:00Z
author avatar
Top 5LeaderboardReal User

I would rate this solution a nine out of ten.

2019-05-22T07:18:00Z
Learn what your peers think about SAP PowerDesigner. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
554,676 professionals have used our research since 2012.