SAP PowerDesigner vs erwin Data Modeler by Quest comparison

Cancel
You must select at least 2 products to compare!
erwin by Quest  Logo
6,311 views|3,313 comparisons
94% willing to recommend
SAP Logo
4,210 views|2,496 comparisons
86% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between erwin Data Modeler by Quest and SAP PowerDesigner based on real PeerSpot user reviews.

Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed SAP PowerDesigner vs. erwin Data Modeler by Quest Report (Updated: May 2024).
772,422 professionals have used our research since 2012.
Featured Review
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 features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database.""The modeling portion of the tool is the most valuable. There are some notes, naming standards, and other functions that we use as well. There's a whole boatload of functionality in this thing and we use maybe 10% of it. It seems to be pretty common that not all the functionality is fully utilized. But it's just got gobs and gobs of stuff that you can implement if you so choose to.""They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products.""The fitting model is very intuitive.""We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work.""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.""Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest.""It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."

More erwin Data Modeler by Quest Pros →

"It can automate many routine tasks and save human resources to focus on real problems.""I do a data-centric design, so for me, the data analysis and design tools are the most valuable features.""SAP PowerDesigner is an excellent tool that does what I need it to do. What I like most about it is that it's stable, fast, and easy to understand.""The solution is a very pragmatic tool. It's quite easy to use.""SAP PowerDesigner is fairly stable.""It's a great tool for documentation.""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.""It's a stable system. It never crashes."

More SAP PowerDesigner Pros →

Cons
"It does not have a cloud application.""erwin is not as robust as a data warehousing project I've been on in the past.""It is not a very stable solution. I rate the stability five out of ten.""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.""I would like the solution to be less rigid in terms of its theory.""This is a very complex product.""I would like the solution to be more user-friendly to deploy.""The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."

More erwin Data Modeler by Quest Cons →

"It would be helpful if there were glossary, catalog and governance tools. It would help make it a true end-to-end product.""There are some minor things that could be easier. We're writing up procedures to bring all the modeling back into one group as this reduces delays in production.""Regarding improvements, I suggest enhancing the connection between objects in process and data models. It's crucial to define the structure of objects, especially when dealing with standard frameworks like VMM. There should be better visualization of arrows between BPM and data modeling objects, specifying their structure and impact. For future versions, a feature similar to Bizagi, allowing users to see forms or SQL representations of objects, would be valuable for demonstrating and presenting project details to stakeholders.""The solution is very, very expensive. It would be ideal if it was a more affordable product.""One disadvantage of SAP PowerDesigner is that you cannot reverse engineer the ALTER statements, so that's an enhancement or area for improvement I'm looking forward to seeing from the SAP team in the future. That should directly reflect on the physical data models my company builds.""Technical support could be better and more human.""Not very intuitive or user-friendly.""This product lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements."

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."
  • "There are no costs in addition to the standard licensing fees."
  • "I don't specifically know what we're paying now. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. In the mid-2000s, it was something like 1,200 AUD a seat. I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite."
  • "The price of erwin Data Modeler is very expensive, in particular for this part of the world."
  • More erwin Data Modeler by Quest Pricing and Cost Advice →

  • "The ROI has been 43%."
  • "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."
  • "SAP PowerDesigner is cheaper than eriwin."
  • "The price of the solution is too expensive. When we asked for certain licenses in different countries it was unattainable."
  • "I would like SAP to prove free licenses to professionals that are using the solution. The free version is limited."
  • "Regarding costs, SAP PowerDesigner is pricey, as I've heard from my team manager, which is why the company has been thinking of bringing another solution on board."
  • "The price of the solution is low."
  • More SAP PowerDesigner Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
    772,422 professionals have used our research since 2012.
    Answers from the Community
    Segundo Navarrete
    Tracy Hautenen Kriel - PeerSpot reviewerTracy Hautenen Kriel
    Real User

    15 years ago was the one time I chose to use PowerDesigner over Erwin Data Modeler was for a project where we have hundreds of pl/sql ETL scripts that needed to be run in a specific order for specific tables. PowerDesigner had the ability to store the pl/sql within  the data model and prioritize/order the script run sequence. This meant that we could count on PowerDesigner to automatically generate the ddl and pl/sql code in the correct run order, rather than manually maintaining a spreadsheet with the script order and running each script manually, a VERY labor intensive process. I don't know if PowerDesigner still has that capability. 


    With all of the ways we have to program and perform ETL, Erwin Data Modeler has been my tool of choice for any other project throughout the years. Protecting intellectual property and transparently sharing data model information with other modelers by saving the the models in a centralized location (i.e. Model Mart) is important for any company. Making the data model diagrams transparently accessible via Web Portal is another important step in ensuring both technical and business users understand the structure and relationships of the data contains within a data store. Lastly, making the data model metadata available via the Erwin Data Intelligence Suite enables both technical and business users to completely understand everything about the data and data store: Business Glossary, Reference Data, Governance, Data Quality, Data Mapping, and especially automating data lineage and impact analysis.

    Questions from the Community
    Top Answer:Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
    Top Answer:The solution's model mark could be better because it crashes sometimes.
    Top Answer:It allows us to have proper documentation in terms of the databases.
    Top Answer:It's really effective in terms of validating everything, but sometimes they don't allow us some flexibility if we compare it with other tools in the market. So, it's doing too many validations that… more »
    Ranking
    Views
    6,311
    Comparisons
    3,313
    Reviews
    11
    Average Words per Review
    432
    Rating
    7.9
    Views
    4,210
    Comparisons
    2,496
    Reviews
    13
    Average Words per Review
    583
    Rating
    7.7
    Comparisons
    Also Known As
    erwin DM
    Sybase PowerDesigner
    Learn More
    SAP
    Video Not Available
    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.

    SAP PowerDesigner is a valuable solution for developing several different types of data models according to business process needs. Data models can be logical, conceptual, and physical, and can also include dimensional and relational models. PowerDesiger has the ability to integrate a designed business process model with the actual database design to ensure that all the data process steps are included in the logical model. PowerDesigner is able to use the physical model to create the actual database, and from there, design various physical iterations from a single logical model.

    PowerDesigner can perform excellent reverse-engineering of existing databases to create a model diagram. The solution integrates well with many of today's most recognized database management systems (DBMS). Some of the solution’s featured outputs include custom or standard reports of every object in the design (relationships, field, and tables), design impact analysis, and entity-relationship (ER) designs.

    PowerDesigner offers intuitive capabilities such as metadata management, link and sync, and data modeling. Users can instantly view architecture layers and essentials, access the robust metadata repository, and share findings with the user’s entire team.

    SAP PowerDesigner Features

    • Document Creation: Easily share documents to cultivate an environment of communication and collaboration with all stakeholders in a project. Users can even include non-modelers. Users can provide private, secure access to metadata using hyperlinked Web reporting and multi-model documents, and even use wizard-created lists.

    • Result Analysis: The solution helps merge all model types with an intuitive automated link-and-sync process. Users can easily streamline communication and creative streams to improve the organization’s ability to experience transformation.

    • Intelligence Mapping: Users can develop thorough mapping protocols for data dictionary input. Users can record dependencies correctly with a simple drag-and-drop mapping editor and drag information from any supported source to target model pairs.

    SAP PowerDesigner Benefits

    • Improve Overall Productivity: The solution enables enterprise architects and developers to share information through a trusted metadata repository that can handle all modeling types.

    • Simplify Workflows: PowerDesigner offers an easy-to-use wizard-driven protocol to streamline web-based reporting and documentation, making workloads easier for IT staff and other users.

    • Improve Communication: PowerDesigner’s intuitive link-and-sync technology will facilitate secure trusted networks between an organization's specific protocols, data models, and language.

    Reviews from Real Users

    “The most valuable feature of SAP PowerDesigner is the testing of the models, it has the best function. Reverse engineering is very helpful too. I use SAP PowerDesigner for data modeling and documentation. It interacts well with the other tools. Additionally, we use it for all of the business requirements, such as CDM and PDM.” - Saadat T., Emerging Cloud Solution Architect at a tech services company

    “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.” - Michael R., DA


    Sample Customers
     Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
    Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
    Top Industries
    REVIEWERS
    Financial Services Firm28%
    Insurance Company21%
    Government14%
    Energy/Utilities Company7%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Government10%
    Computer Software Company10%
    Manufacturing Company7%
    REVIEWERS
    Financial Services Firm19%
    Retailer13%
    Government13%
    Energy/Utilities Company13%
    VISITORS READING REVIEWS
    Financial Services Firm25%
    Government12%
    Computer Software Company10%
    Manufacturing Company9%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise7%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise73%
    REVIEWERS
    Small Business43%
    Midsize Enterprise16%
    Large Enterprise41%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise11%
    Large Enterprise70%
    Buyer's Guide
    SAP PowerDesigner vs. erwin Data Modeler by Quest
    May 2024
    Find out what your peers are saying about SAP PowerDesigner vs. erwin Data Modeler by Quest and other solutions. Updated: May 2024.
    772,422 professionals have used our research since 2012.

    erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while SAP PowerDesigner is ranked 5th in Enterprise Architecture Management with 34 reviews. erwin Data Modeler by Quest is rated 8.6, while SAP PowerDesigner is rated 7.8. The top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". On the other hand, the top reviewer of SAP PowerDesigner writes "Effective in terms of validating everything, but sometimes they don't allow us some flexibility and GUI could improve". erwin Data Modeler by Quest is most compared with IDERA ER/Studio, Lucidchart, Visio, Sparx Systems Enterprise Architect and AWS Well-Architected Tool, whereas SAP PowerDesigner is most compared with Sparx Systems Enterprise Architect, Visio, IDERA ER/Studio, LeanIX and BiZZdesign HoriZZon. See our SAP PowerDesigner vs. erwin Data Modeler by Quest report.

    See our list of best Enterprise Architecture Management vendors.

    We monitor all Enterprise 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.