SAP PowerDesigner Competitors and Alternatives

Get our free report covering erwin, Inc., Sparx Systems, SAP, and other competitors of SAP PowerDesigner. Updated: January 2021.
455,536 professionals have used our research since 2012.

Read reviews of SAP PowerDesigner competitors and alternatives

LouisDevenuto
VP Enterprise Data Architecture at a financial services firm with 10,001+ employees
Real User
Top 5Leaderboard
Jan 26, 2020
Allows us to review databases with our business and technology people and to understand data relationships in our company

What is our primary use case?

The whole purpose of the erwin tool is for the designing of databases. We use it for our conceptual, logical, and physical database modeling.

Pros and Cons

  • "The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases."
  • "I would like to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."

What other advice do I have?

If you want good data architecture in your company, you need to have database design done. It's probably the most important factor for having things clearly modeled and documented. erwin Data Modeler is not just a modeling tool, it's also used for documentation. If you're using the tool's functions properly, analyzing the documentation, flagging fields that are NPPI data, it is invaluable for business use. You can generate data dictionaries, you can make sure people are speaking common languages, and you can enforce company standards so that people are doing things in a consistent manner. It's…
reviewer1477701
Data Architect at a financial services firm with 501-1,000 employees
Real User
Top 5
Jan 11, 2021
Semantic data lineage and usability need to be improved, but it's priced well

What is our primary use case?

I have experience working with various data architecture tools, and ER/Studio is one of them that I use in this capacity. We use it either to help an organization understand what data it has got or to design a database.

Pros and Cons

  • "It does the job."
  • "What needs the most improvement are semantic lineage and usability."

What other advice do I have?

My advice for anybody who is considering this product is to understand what your requirements are of the system, of whatever tool you're going to select. There are loads of people and organizations that have bought this product and used it, and that's dependent upon their requirements, their needs. Plenty of others have bought SAP PowerDesigner. Personally, and I'm self-employed, or a freelance contractor, I invested more money and decided on SAP Power Designer. Overall, I don't like any of the features and I think that it's a poor system. I would rate this solution a five out of ten.
Get our free report covering erwin, Inc., Sparx Systems, SAP, and other competitors of SAP PowerDesigner. Updated: January 2021.
455,536 professionals have used our research since 2012.