I use SAP PowerDesigner for data modeling, documentation, and it interacts with the other tools. Additionally, we use it for all of the business requirements, such as CDM and PDM.
Emerging Cloud Solution Architect at a tech services company with 501-1,000 employees
Useful testing models, scalable, and useful online support
Pros and Cons
- "The most valuable feature of SAP PowerDesigner is the testing of the models, it has the best function. Reverse engineering is very helpful too."
- "The solution itself does not need to be improved. However, they could add support for different languages."
What is our primary use case?
What is most valuable?
The most valuable feature of SAP PowerDesigner is the testing of the models, it has the best function. Reverse engineering is very helpful too.
What needs improvement?
The solution itself does not need to be improved. However, they could add support for different languages.
For how long have I used the solution?
I have been using SAP PowerDesigner for approximately 22 years.
Buyer's Guide
SAP PowerDesigner
October 2024
Learn what your peers think about SAP PowerDesigner. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The scalability of SAP PowerDesigner is good. However, I have not had the chance to test it in a large environment. For my environment, it works well.
How are customer service and support?
The online support from SAP I have used has been good.
How was the initial setup?
The setup is very simple.
What's my experience with pricing, setup cost, and licensing?
I would like SAP to prove free licenses to professionals that are using the solution. The free version is limited.
What other advice do I have?
I rate SAP PowerDesigner a ten out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PowerDesigner and ER/Studio Consultancy and Training Specialist at a tech services company with 1-10 employees
The best data modelling tool on the market, and that's nowhere near everything it can handle
Pros and Cons
- "The most valuable feature is the way you can extend it and customize it. With most modeling tools, you fit your modeling process to fit the tool. In PowerDesigner, you can make the tool fit the way you want to work."
- "Pricing for small consultancies needs improvement. They sustain prices to competing tools. The competing tools tend to do special offers. PowerDesigner SAP doesn't pay much attention to the pricing of it and there are no special offers."
What is our primary use case?
As part of my consultancy business I provide training for PowerDesigner users, face-to-face and online. Working directly with clients or as part of subcontracted project work, I provide mentoring for users and customise the tool to fit the client's needs.
The majority of my clients use PowerDesigner for various types of Data Modelling and Database activities, along with Data Governance, Process Governance and Enterprise Architecture.
How has it helped my organization?
I use PowerDesigner myself for managing my own workload. For example, I use a Requirements Model to manage the tips and tricks I plan to include in my blog, and a customised Enterprise Architecture Model to manage my training portfolio. PowerDesigner includes a 'Free Model', which I use to manage and generate my library of PowerDesigner scripts.
What is most valuable?
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).
What needs improvement?
SAP have invested a lot of time and effort into improving and extending the capabilities of the PowerDesigner Web Portal. Following the most recent release, users can create and edit Conceptual, Physical, Requirements, Business Process, and Enterprise Architecture models using a standard web browser as well using the client software.
I'm looking forward to the day when the Web Portal supports every type of model, including Logical Data Models. I also would like to see better support for NoSQL databases.
For how long have I used the solution?
I have been using SAP PowerDesigner for fourteen years.
What do I think about the scalability of the solution?
There are organisations with hundreds of users, very large models, and very large repository databases. It works.
How are customer service and technical support?
The documentation is excellent, and more comprehensive than that supplied by the competition. However, even the best software documentation doesn't support you through your day-to-day modelling activities, which is why I wrote a book "Data Modelling Made Simple with PowerDesigner".
The technical support is very good, utilising SAP' standard customer support portal. I have interacted with technical support at another vendor, where everything is done by email, making it very difficult to keep up-to-date on a case.
Which solution did I use previously and why did I switch?
I have used many modelling tools (possibly more than 10) over the years; when I set up my own consultancy I had a choice of tools to focus on, choosing PowerDesigner. I do also provide some consultancy and customisation for Idera ER/Studio Data Architect.
How was the initial setup?
It's very easy to install. If you want to install a simple repository database, that's really easy as well - SAP provides a licenced copy of SQL Anywhere, which you can deploy anywhere (as the name suggests).
What's my experience with pricing, setup cost, and licensing?
The list price for PowerDesigner is competitive for the base Data Architecture features when compared with the major competitors, especially when you consider the features that SAP don't charge for such as the Repository, Web Portal and 'Viewer' software. However, the pricing for small consultancies needs to be improved. The competing vendors often have special offers that make the tool more affordable, which is vital for data management consultancies that have to buy the tools that their clients use.
What other advice do I have?
A powerful modelling solution has to be selected, implemented and managed in the same way as any other enterprise software - before you evaluate tools make sure you've documented your modelling process and the metadata you need to manage. Run a 'Proof of Concept' first - so you actually know what you're letting yourself in for and how much work you may or may not have to do to get it to work the way you want.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
SAP PowerDesigner
October 2024
Learn what your peers think about SAP PowerDesigner. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
Senior Consultant at a tech consulting company with 51-200 employees
We can reverse engineer databases and create data models and documentation for clients
Valuable Features:
Reverse engineering a database in order to produce documentation for client to understand their database in order to support their application, perform data migration, perform system analysis, perform impact analysis, and write interfaces.
Improvements to My Organization:
This product is very useful when starting a new project. It helped the consultant to understand the database.
Room for Improvement:
No issues encountered.
Use of Solution:
I've been using it for about 15 years, starting with v5.0
Deployment Issues:
No issues encountered.
Stability Issues:
The product is very stable, even with no maintenance updates to purchase. There were a few bugs I have found, which I just learned to work around.
Customer Service:
It's very good.
Implementation Team:
It was implemented in-house.
Other Solutions Considered:
We also looked at what is now CA ERwin Data Modeler.
Other Advice:
It is a great product to use, but the client does not really need to purchase the software, as the consultant can reverse engineer the database, and then create the data model and documentation in order to deliver to client. The client can use the read-only version of PowerDesigner.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Principal Data Management Consultant at a comms service provider with 10,001+ employees
Stable, uncomplicated installation, but overall features need improvement
Pros and Cons
- "SAP PowerDesigner is fairly stable."
- "There are many areas of this solution that needs to be changed."
What is our primary use case?
We are using SAP PowerDesigner to design physical and logical data models for new releases of software.
What is most valuable?
The solution has the basic features for creating entities.
What needs improvement?
SAP PowerDesigner could improve by being more intuitive and user-friendly. It does not enforce some of the integrity of the model that we would like it to retain.
There are many areas of this solution that needs to be changed.
For how long have I used the solution?
I have been using SAP PowerDesigner for approximately two and a half years.
What do I think about the stability of the solution?
SAP PowerDesigner is fairly stable.
What do I think about the scalability of the solution?
There are five people in my organization using this solution.
How are customer service and technical support?
We have used technical support but was it was difficult to get in touch with the right person. It was not very clear who the responsible person was. They do not seem to have centralized support, making it difficult to get the person in the right region to help us. However, once we found the right person we had our issues resolved.
How was the initial setup?
The installation is in the average difficulty range.
What's my experience with pricing, setup cost, and licensing?
The price of the solution is too expensive. When we asked for certain licenses in different countries it was unattainable.
We have had some issues with being able to procure licenses for specific countries. We were not able to receive licenses for every location we wanted.
Which other solutions did I evaluate?
We intend to switch solutions and we have been evaluating others.
What other advice do I have?
I would not recommend this solution to others.
I rate SAP PowerDesigner a six out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Consultant at Mibcon DIMA
A User-friendly and extensible solution that facilitates automation of routine tasks
Pros and Cons
- "It can automate many routine tasks and save human resources to focus on real problems."
- "There should be a better usage of current hardware including multicore CPUs, higher resolutions, and multiple displays."
What is our primary use case?
I am working for the partner of the vendor of PD. My jobs include implementing, training, customizing, and extending PowerDesigner.
One of my tasks is to develop automation that makes end users more efficient in their work.
How has it helped my organization?
It can automate many routine tasks and save human resources to focus on real problems.
What is most valuable?
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.
What needs improvement?
I would like to see better team collaboration in PD. Passing models (or objects in it) from one role to another. Today, we have to solve it by custom extensions and modelling rules just written on paper (and not enforced automatically).
Support for ArchiMate would be an improvement.
There should be a better usage of current hardware including multicore CPUs, higher resolutions (UHD, 4K), and multiple displays.
I would also like to see better troubleshooting options for repository issues. In case of problems during check-in of the model to the repository, the error message just says "checkin was cancelled", but id doesn`t give you any details or hints where to look, what to repair.
For how long have I used the solution?
Eleven years.
Which solution did I use previously and why did I switch?
I started with IBM Rational Rose and then switched to PowerDesigner. I have some experience with Sparx Systems Enterprise Architect, too.
What's my experience with pricing, setup cost, and licensing?
PowerDesigner is not the cheapest solution on the market, so make sure that you are using it up to its full potential.
Which other solutions did I evaluate?
Our customers often choose PowerDesigner because of its wide possibilities for data modeling, together with the huge potential to automate frequent and routine tasks. This enables them to implement their own modeling methods within the tool.
Sparx Systems Enterprise Architect is an option in terms of price, but not in terms of the number supported DBs, source-target mappings, possibilities of impact & lineage analysis, and the ease of customizability of the tool.
What other advice do I have?
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.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are partner of SAP in Europe and we are implementing and customizing PowerDesigner into the customers` environments.
Team leader and Data / Information Architect at a tech services company with 201-500 employees
A pragmatic tool that's easy to use and offers good data modeling
Pros and Cons
- "The solution is a very pragmatic tool. It's quite easy to use."
- "It would be helpful if there were glossary, catalog and governance tools. It would help make it a true end-to-end product."
What is our primary use case?
Often, a customer will want to migrate from another solution onto PowerDesigner. That's how I primarily use the solution: migrating things over to this solution.
We use it to set up the conceptual model. From there, we will take the physical model, where we can start the different DDLs. We will use it to generate the DDLs for the database teams to implement it.
What is most valuable?
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.
What needs improvement?
I don't know of any features the solution is lacking.
It would be helpful if there were glossary, catalog and governance tools. It would help make it a true end-to-end product.
For how long have I used the solution?
I've been using the solution for a while. When I use the solution, the need to use it is driven more from the customer's own needs and not from my own.
What do I think about the stability of the solution?
I haven't had any feedback from clients that would make me believe that there are stability issues.
What do I think about the scalability of the solution?
I don't have any direct experience with scaling the solution. It's not something that I handle.
How are customer service and technical support?
We've never contacted SAP's technical support. I don't have any direct experience with them.
Which solution did I use previously and why did I switch?
We occasionally do migrations from MEGA HOPEX to PowerDesigner.
How was the initial setup?
The initial setup was straightforward. It's not complex at all.
However, it depends on how big your environment is. It's difficult, but approximately in one week, you can start creating the capabilities and then it depends on what you want to achieve.
The problem for the migration part is the setup of the conceptual models and the physical models. If you do the modeling between the conceptual and the physical from a migration point of view, then it becomes more complex because you have the generation of internal keys.
What other advice do I have?
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.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Architect at a financial services firm with 501-1,000 employees
A stable and scalable solution with good connectivity and usability
Pros and Cons
- "I like the connectivity or the lineage between the models and usability."
- "Technical support could be better and more human."
What is most valuable?
I like the connectivity or the lineage between the models and usability.
What needs improvement?
Technical support could be better and more human.
For how long have I used the solution?
I have been using PowerDesigner for three years.
What do I think about the stability of the solution?
PowerDesigner is a stable solution.
What do I think about the scalability of the solution?
PowerDesigner is a scalable solution. I worked in a client site where there was a repository, and there were dozens of data modelers. There wasn't a problem.
How are customer service and technical support?
It would be better if they had a more human IT support system. They are really chuffed with their support desk, they got the dashboards, and you can log your problems.
With another vendor, you log a problem, and they call straight away. You can tell somebody about the problem. They're very nice and personable, and they know you. For SAP, you're just lost somewhere in the queue, and for me, it's not a decent response.
What other advice do I have?
On a scale from one to ten, I would give PowerDesigner a nine.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Enterprise Architect at a consumer goods company with 201-500 employees
The wizard report links directly to MS Word and is very useful
Pros and Cons
- "It has helped me to develop the as-is state, design its to-be state, and track the capital investment according to gap analysis."
- "The data governance should be improved, like ER/Studio."
What is our primary use case?
- Improving retail company operations on ERP migration
- The report wizard is extensive and useful.
- You can import BPMN from Bizagi.
How has it helped my organization?
It has helped me to develop the as-is state, design its to-be state, and track the capital investment according to gap analysis.
What is most valuable?
- The wizard report links directly to MS Word and is very useful.
- The matrix processes and capabilities are good tools.
- It is easy and fast to use.
What needs improvement?
- The UML simulation should be improved to avoid designing other tools out of the application.
- The data governance should be improved, like ER/Studio.
For how long have I used the solution?
More than five years.
Which solution did I use previously and why did I switch?
Switched because SAP PowerDesigner is easy to use.
What was our ROI?
The ROI has been 43%.
Which other solutions did I evaluate?
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free SAP PowerDesigner Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Popular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Sparx Systems Enterprise Architect
ARIS BPA
Alation Data Catalog
erwin Data Modeler by Quest
MEGA HOPEX
iServer
BiZZdesign HoriZZon
Avolution ABACUS
SAP Data Hub
Collibra Catalog
IDERA ER/Studio
Buyer's Guide
Download our free SAP PowerDesigner Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which would you choose - SAP PowerDesigner or erwin Data Modeler (DM)?
- Which solution do you prefer: SAP PowerDesigner or SAP Enterprise Architecture Designer?
- Can you recommend a graphic illustration tool to model the architecture of IT systems?
- When evaluating Architecture Management, what aspect do you think is the most important to look for?
- Tools to Develop and Manage IT Infrastructure Road-maps
- Sparx system comparing with ARIS and IBM blueworks.
- What EA tool would you advise us to use?
- What are some business benefits associated with enterprise architecture?
- Any experience on newer/low-cost cloud based EA Modelling Tools?
- How to model an enterprise architecture? What tools and templates can I use?