IT Central Station is now PeerSpot: Here's why

SAP PowerDesigner vs erwin Data Modeler (DM) comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Buyer's Guide
SAP PowerDesigner vs. erwin Data Modeler (DM)
July 2022
Find out what your peers are saying about SAP PowerDesigner vs. erwin Data Modeler (DM) and other solutions. Updated: July 2022.
611,060 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 logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc.""What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes.""Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful.""The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application.""It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for.""There is absolutely no problem with the stability.""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.""The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."

More erwin Data Modeler (DM) Pros →

"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 like the connectivity or the lineage between the models and usability.""The initial setup was very easy.""The most valuable feature is that it is a very fast reverse engineering process. It does a very expansive comparison.""SAP PowerDesigner is fairly stable.""It offers a lot of features in one solution. You would have to get multiple other products to bundle together all of the capabilities that you get in just this product.""It's a great tool for documentation.""Very good repository features."

More SAP PowerDesigner Pros →

Cons
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing.""The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work.""I am not so happy with its speed. Sometimes, it can have problems with connections.""The erwin Data Modeler is quite complex to use.""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.""I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk.""I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020.""The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."

More erwin Data Modeler (DM) Cons →

"Connectivity can be improved because it's not very good.""Technical support could be better and more human.""The solution itself does not need to be improved. However, they could add support for different languages.""In terms of improvement, the pricing is a bit high.""There are many areas of this solution that needs to be changed.""I have found the solution not easy to use. When publishing you have to download the HTML, make adjustments against the updated HTML, convert it to HTML, then finally paste the HTML. There is not an on-the-fly function available to bypass the step-by-step converting process that other solutions have.""UI could be improved by enabling simpler navigation.""The solution is very, very expensive. It would be ideal if it was a more affordable product."

More SAP PowerDesigner Cons →

Pricing and Cost Advice
  • "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."
  • "erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
  • "erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
  • More erwin Data Modeler (DM) Pricing and Cost Advice →

  • "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."
  • More SAP PowerDesigner Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
    611,060 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:The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc.
    Top Answer:We always had a problem keeping track of all the licenses. All of a sudden you might get a message that your license expired and you didn't know, and it happens at different times. At GM Finance, they… more »
    Top Answer:A sorely needed enhancement to the erwin DM API is the ability to CLOSE a session. We use the API to automate tasks and every session has to be manually closed either in the Mart Admin console or the… more »
    Top Answer:I like the connectivity or the lineage between the models and usability.
    Top Answer:Technical support could be better and more human.
    Ranking
    2nd
    Views
    7,893
    Comparisons
    4,134
    Reviews
    16
    Average Words per Review
    1,685
    Rating
    8.7
    4th
    Views
    5,735
    Comparisons
    3,608
    Reviews
    9
    Average Words per Review
    584
    Rating
    8.0
    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


    Offer
    Learn more about erwin Data Modeler (DM)
    Learn more about SAP PowerDesigner
    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
    Insurance Company28%
    Financial Services Firm22%
    Government17%
    Logistics Company11%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm18%
    Comms Service Provider10%
    Government9%
    REVIEWERS
    Financial Services Firm25%
    Consumer Goods Company13%
    Healthcare Company13%
    Pharma/Biotech Company13%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider15%
    Financial Services Firm13%
    Government10%
    Company Size
    REVIEWERS
    Small Business37%
    Midsize Enterprise3%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise12%
    Large Enterprise74%
    REVIEWERS
    Small Business40%
    Midsize Enterprise20%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise15%
    Large Enterprise71%
    Buyer's Guide
    SAP PowerDesigner vs. erwin Data Modeler (DM)
    July 2022
    Find out what your peers are saying about SAP PowerDesigner vs. erwin Data Modeler (DM) and other solutions. Updated: July 2022.
    611,060 professionals have used our research since 2012.

    erwin Data Modeler (DM) is ranked 2nd in Architecture Management with 19 reviews while SAP PowerDesigner is ranked 4th in Architecture Management with 8 reviews. erwin Data Modeler (DM) is rated 8.8, while SAP PowerDesigner is rated 8.0. The top reviewer of erwin Data Modeler (DM) writes "Improves accuracy for generating target databases, allows us to pull metadata from a database, and makes it easy to display information and models". 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 IDERA ER/Studio, Visio, AWS Well-Architected Tool, Lucidchart and Sparx Systems Enterprise Architect, whereas SAP PowerDesigner is most compared with Sparx Systems Enterprise Architect, Visio, IDERA ER/Studio, erwin Evolve and SAP Enterprise Architecture Designer. 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.