SAP PowerDesigner vs erwin Data Catalog by Quest comparison

Cancel
You must select at least 2 products to compare!
erwin by Quest  Logo
268 views|211 comparisons
100% willing to recommend
SAP Logo
486 views|299 comparisons
86% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out in this report how the two Metadata 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 Catalog by Quest Report (Updated: March 2024).
769,662 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
"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for.""The data catalog feature is pretty good."

More erwin Data Catalog by Quest Pros →

"I do a data-centric design, so for me, the data analysis and design tools are the most valuable features.""I like the connectivity or the lineage between the models and usability.""SAP PowerDesigner is fairly stable.""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 feature I found valuable in SAP PowerDesigner is extraction. I also like that my company hasn't faced any issues because of the clear documentation about SAP PowerDesigner.""The solution is a very pragmatic tool. It's quite easy to use.""This solution has good tools for big data, where you can manage large and complex databases.""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."

More SAP PowerDesigner Pros →

Cons
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database.""There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."

More erwin Data Catalog by Quest Cons →

"The solution itself does not need to be improved. However, they could add support for different languages.""SAP PowerDesigner can improve the ease of use. It is not the best tool on the market because it is tough to navigate and use. A beginner would not be able to use it well, it requires some experience. If the solution was more user-friendly it would be able to be used by more audiences. I do not think many people are aware of this solution and they should use it.""There are many areas of this solution that needs to be changed.""This product lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements.""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.""SAP PowerDesigner could improve by making the repository easier to understand. It is difficult to understand how the repository works because when I used logical models as part of the team, we wanted to use them together and update the older versions of the data model version but it was confusing. The repository needs to be explained.""This product does not have a good BPMN Modeler.""The focus is more on mainstream development environments, and I see a lack of focus on the open source world. I think SAP PowerDesigner probably interfaces better with SQL Server and Db2 but not with open source databases like PostgreSQL and MySQL."

More SAP PowerDesigner Cons →

Pricing and Cost Advice
  • "I am not very familiar with its pricing. I know it is not cheap, but it is also not super expensive. It depends on the company size. For a company making $1 million, it is very expensive. For a company making 10 million and above, it might be okay."
  • "Erwin Data Catalog is very expensive."
  • More erwin Data Catalog 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 Metadata Management solutions are best for your needs.
    769,662 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes… more »
    Top Answer:The data catalog feature is pretty good.
    Top Answer:Erwin Data Catalog is very expensive. I would rate it a two out of five for affordability.
    Top Answer:In PowerDesigner, I primarily use BPM and modeling standards. I find it beneficial for process analysis, although I use data modeling to a lesser extent.
    Top Answer: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… more »
    Ranking
    12th
    out of 27 in Metadata Management
    Views
    268
    Comparisons
    211
    Reviews
    1
    Average Words per Review
    564
    Rating
    7.0
    4th
    out of 27 in Metadata Management
    Views
    486
    Comparisons
    299
    Reviews
    13
    Average Words per Review
    583
    Rating
    7.7
    Comparisons
    Also Known As
    Sybase PowerDesigner
    Learn More
    SAP
    Video Not Available
    Overview

    erwin Data Catalog (DC), part of the erwin Data Intelligence Suite, automates enterprise metadata management, including data mapping, code generation, data profiling, data lineage and impact analysis. It integrates and activates data in a single, unified catalog in accordance with business requirements by scheduling ongoing scans of metadata from the widest array of data sources, keeping metadata current with full versioning and change management, and easily mapping data elements from source to target, including data at rest and in motion, and harmonize data integration across platforms.

    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
    Balfour Beatty Construction, Banco de México, BFSI Canada, CenturyLink, Daktronics
    Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company13%
    Government11%
    Manufacturing Company7%
    REVIEWERS
    Financial Services Firm20%
    Retailer13%
    Energy/Utilities Company13%
    Consumer Goods Company7%
    VISITORS READING REVIEWS
    Financial Services Firm24%
    Government12%
    Computer Software Company10%
    Manufacturing Company9%
    Company Size
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise16%
    Large Enterprise71%
    REVIEWERS
    Small Business44%
    Midsize Enterprise17%
    Large Enterprise39%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise11%
    Large Enterprise70%
    Buyer's Guide
    SAP PowerDesigner vs. erwin Data Catalog by Quest
    March 2024
    Find out what your peers are saying about SAP PowerDesigner vs. erwin Data Catalog by Quest and other solutions. Updated: March 2024.
    769,662 professionals have used our research since 2012.

    erwin Data Catalog by Quest is ranked 12th in Metadata Management with 2 reviews while SAP PowerDesigner is ranked 4th in Metadata Management with 33 reviews. erwin Data Catalog by Quest is rated 7.6, while SAP PowerDesigner is rated 8.0. The top reviewer of erwin Data Catalog by Quest writes "Helps with metadata management, saves time, and allows us to do impact analysis on any changes". On the other hand, the top reviewer of SAP PowerDesigner writes "Difficult to operate, long process to publish, but scalable". erwin Data Catalog by Quest is most compared with Informatica Enterprise Data Catalog, Talend Open Studio, Alation Data Catalog, Oracle Data Integrator (ODI) and WhereScape RED, whereas SAP PowerDesigner is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, Visio, IDERA ER/Studio and LeanIX. See our SAP PowerDesigner vs. erwin Data Catalog by Quest report.

    See our list of best Metadata Management vendors.

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