Compare SAP PowerDesigner vs. erwin Data Modeler (DM)

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about SAP PowerDesigner vs. erwin Data Modeler (DM) and other solutions. Updated: November 2020.
447,846 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"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.""When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable.""erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when.""The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database.""It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that.""Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed.""The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model.""We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."

More erwin Data Modeler (DM) Pros »

"This solution has good tools for big data, where you can manage large and complex databases.""It can automate many routine tasks and save human resources to focus on real problems.""The solution is a very pragmatic tool. It's quite easy to use.""I do a data-centric design, so for me, the data analysis and design tools are the most valuable features.""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.""I like the property sheet capability and the user-defined attributes that you can set up.""The most valuable feature is that it is a very fast reverse engineering process. It does a very expansive comparison.""Very good repository features."

More SAP PowerDesigner Pros »

Cons
"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.""One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated.""Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model.""I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else.""The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms.""Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use.""I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it.""I would like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."

More erwin Data Modeler (DM) Cons »

"This product does not have a good BPMN Modeler.""There should be a better usage of current hardware including multicore CPUs, higher resolutions, and multiple displays.""It would be helpful if there were glossary, catalog and governance tools. It would help make it a true end-to-end product.""In the future, I would like to see data manipulation capability where you can actually write SQL queries and manipulate data from directly within the tool.""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.""Checking-in models to the repository, especially when working remotely, is a slow process than can sometimes have problems with models being corrupted.""In terms of improvement, the pricing is a bit high.""UI could be improved by enabling simpler navigation."

More SAP PowerDesigner Cons »

Pricing and Cost Advice
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable.""This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost.""An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool.""The price should be lower in order to be on the same level as its competitors.""I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."

More erwin Data Modeler (DM) Pricing and Cost Advice »

"PowerDesigner is not the cheapest solution on the market, so make sure that you are using it to its full potential.""I bought the software outright and do not pay a licensing fee."

More SAP PowerDesigner Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
447,846 professionals have used our research since 2012.
Questions from the Community
Top Answer: We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice… more »
Top Answer: When I need to stretch an entity in order to add new relationships the diagrammer should not move the existing relationship lines and put elbows in them.
Top Answer: 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… more »
Top Answer: 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… more »
Top Answer: 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… more »
Ranking
3rd
Views
1,338
Comparisons
403
Reviews
15
Average Words per Review
2,037
Avg. Rating
8.7
5th
Views
6,020
Comparisons
3,839
Reviews
9
Average Words per Review
659
Avg. Rating
8.6
Popular Comparisons
Compared 30% of the time.
Compared 23% of the time.
Compared 13% of the time.
Also Known As
erwin DMSybase PowerDesigner
Learn
erwin, Inc.
SAP
Overview

erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

Plan and manage complex business transformation initiatives with SAP PowerDesigner. The software’s data modeling tools let you build a blueprint of your current enterprise architecture and visualize the impact of change before it happens. Automatically capture architecture layers and requirements, tap into a powerful metadata repository, and share discoveries with your team.

Offer
Learn more about erwin Data Modeler (DM)
Learn more about SAP PowerDesigner
Sample Customers
Balfour Beatty Construction, Banco de México, BFSI Canada, CenturyLink, DaktronicsMedtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Top Industries
REVIEWERS
Insurance Company38%
Financial Services Firm15%
Government15%
Energy/Utilities Company8%
VISITORS READING REVIEWS
Computer Software Company32%
Insurance Company10%
Financial Services Firm9%
Comms Service Provider8%
VISITORS READING REVIEWS
Computer Software Company31%
Comms Service Provider15%
Financial Services Firm9%
Government7%
Company Size
REVIEWERS
Small Business35%
Midsize Enterprise5%
Large Enterprise60%
REVIEWERS
Small Business53%
Midsize Enterprise13%
Large Enterprise33%
Find out what your peers are saying about SAP PowerDesigner vs. erwin Data Modeler (DM) and other solutions. Updated: November 2020.
447,846 professionals have used our research since 2012.

erwin Data Modeler (DM) is ranked 3rd in Architecture Management with 15 reviews while SAP PowerDesigner is ranked 5th in Architecture Management with 9 reviews. erwin Data Modeler (DM) is rated 8.6, while SAP PowerDesigner is rated 8.6. The top reviewer of erwin Data Modeler (DM) writes "Allows us to bring in data from dozens of platforms and search holistically across all of them". On the other hand, the top reviewer of SAP PowerDesigner writes "Ability to work on a single repository is great; web portal enables view from the browser perspective". erwin Data Modeler (DM) is most compared with Visio, Lucidchart, Visual Paradigm, AWS Well-Architected Tool and IDERA ER/Studio, whereas SAP PowerDesigner is most compared with erwin Evolve, Sparx Systems Enterprise Architect, SAP Enterprise Architecture Designer, ARIS BPM and IBM Rational System Architect. See our SAP PowerDesigner vs. erwin Data Modeler (DM) report.

See our list of best Architecture Management vendors.

We monitor all Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.