SAP Enterprise Architecture Designer vs erwin Data Modeler by Quest comparison

erwin Data Modeler by Quest
Read 37 erwin Data Modeler by Quest reviews
  • 6,064 Views
  • 3,191 Comparison Views
94% willing to recommend
SAP Enterprise Architecture...
Read 1 SAP Enterprise Architecture Designer review
  • 427 Views
  • 286 Comparison Views
100% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive Summary
We performed a comparison between erwin Data Modeler by Quest and SAP Enterprise Architecture Designer based on real PeerSpot user reviews.

Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed Enterprise Architecture Management Report (Updated: May 2024).
Buyer's Guide
Enterprise Architecture Management
May 2024
Download the complete report
Helped 787,061 peers since 2012
 

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Number of Reviews
37
Ranking in other categories
Database Design (1st), Business Process Design (9th)
SAP Enterprise Architecture...
Ranking in Enterprise Architecture Management
19th
Average Rating
8.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Market share comparison

As of June 2024, in the Enterprise Architecture Management category, the market share of erwin Data Modeler by Quest is 13.2% and it increased by 26.3% compared to the previous year. The market share of SAP Enterprise Architecture Designer is 0.3% and it decreased by 3.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
Unique Categories:
Business Process Design
2.1%
No other categories found
 

Featured Reviews

DS
Jul 26, 2023
A tool that you can use in multiple environment and creates data dictionaries
I use erwin Data Modeler for a metadata project. I don't have thousands of tables to manage or a data warehouse or anything erwin Data Modeler helps us reverse engineer and keep track of data before converting from one tool to another. erwin allows us to track data and share it with business…
Read full review
Artur Chyziewicz - PeerSpot reviewer
Jul 19, 2022
Great training available with traceability a key feature
I use this solution to model enterprise software architecture. We are customers of SAP and an educational organization in Poland.  Traceability is a fantastic feature.  They should upgrade the algorithm. The solution currently has an old algorithm and there are now free tools on the market that…
Read full 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 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."
"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."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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."
"The fitting model is very intuitive."
"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."
"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."
"It is a scalable solution...The technical support team is fine."
More erwin Data Modeler by Quest pros
"Traceability is a fantastic feature."
 

Cons

"I still use Visio for conceptual modeling, and that's mainly because it is easier to change things, and you can relax some of the rules. DM's eventual target is a database, which means you actually have to dot all the Is and cross all the Ts, but in a conceptual model, you don't often know what you're working with. So, that's probably a constraint with erwin. They have made it a lot easier, and they've done a lot, but there is probably still room for improvement in terms of the ease of presentation back to the business. I'm comparing it with something like Visio where you can change colors on a box, change the text color and that sort of stuff, and change the lines. Such things are a whole lot easier in Visio, but once you get a theme organized in erwin, you can apply that theme to all of the objects. So, it becomes easier, but you do have to set up that theme."
"erwin is not as robust as a data warehousing project I've been on in the past."
"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."
"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."
"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."
"The erwin Data Modeler is quite complex to use."
"The solution's reporting side needs to be improved."
"It does not have a cloud application."
More erwin Data Modeler by Quest cons
"The algorithm is outdated and should be upgraded."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"There are no costs in addition to the standard licensing fees."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"Likewise, the solution is a little pricey."
"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 of erwin Data Modeler is very expensive, in particular for this part of the world."
"Though the solution is not cheap, it's worth the money."
"erwin Data Modeler by Quest is an expensive solution."
More erwin Data Modeler by Quest pricing and cost advice
Information not available
report
See which vendors are best for you
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
See recommendations
787,061 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Government
10%
Computer Software Company
9%
Manufacturing Company
8%
Financial Services Firm
10%
Government
10%
University
9%
Educational Organization
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
See all answers
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
erwin Data Modeler by Quest is an expensive solution.
See all answers
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
See all answers
What do you like most about SAP Enterprise Architecture Designer?
Traceability is a fantastic feature.
See all answers
What is your experience regarding pricing and costs for SAP Enterprise Architecture Designer?
Licensing costs are very reasonable. We pay the equivalent of around $300 per year.
See all answers
What needs improvement with SAP Enterprise Architecture Designer?
They should upgrade the algorithm. The solution currently has an old algorithm and there are now free tools on the market that offer better options for drawing algorithms. I'd like to see a Polish ...
See all answers
 

Comparisons

SAP PowerDesigner vs erwin Data Modeler by Quest Logo
SAP PowerDesigner vs erwin Data Modeler by Quest
Compared 27% of the time
IDERA ER/Studio vs erwin Data Modeler by Quest Logo
IDERA ER/Studio vs erwin Data Modeler by Quest
Compared 15% of the time
Lucidchart vs erwin Data Modeler by Quest Logo
Lucidchart vs erwin Data Modeler by Quest
Compared 13% of the time
Visio vs erwin Data Modeler by Quest Logo
Visio vs erwin Data Modeler by Quest
Compared 12% of the time
Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest Logo
Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest
Compared 8% of the time
More erwin Data Modeler by Quest Competitors
SAP PowerDesigner vs SAP Enterprise Architecture Designer Logo
SAP PowerDesigner vs SAP Enterprise Architecture Designer
Compared 65% of the time
MEGA HOPEX vs SAP Enterprise Architecture Designer Logo
MEGA HOPEX vs SAP Enterprise Architecture Designer
Compared 35% of the time
More SAP Enterprise Architecture Designer Competitors
 

Product Reports

Buyer's Guide
erwin Data Modeler by Quest
June 2024
erwin Data Modeler by Quest reportDownload erwin Data Modeler by Quest product report
Buyer's Guide
Enterprise Architecture Management
May 2024
SAP Enterprise Architecture Designer reportDownload SAP Enterprise Architecture Designer product report
 

Also Known As

erwin DM
SAP EA Designer
 

Learn More

erwin by Quest
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.

The SAP Enterprise Architecture Designer Web application is a user-friendly, collaborative tool for creating and maintaining a complete landscape architecture that is easy to capture and understand visually. People in a wide variety of roles can readily use it, so all necessary stake-holders can participate directly in the planning and design of the architecture. You can manage change by providing effective governance of your architecture changes and calculating their costs and benefits, so that you can keep implementation efficient and cost-effective. Through robust traceability in this multirole, intuitive, collaborative environment, you gain the insight to support compliance at the outset and throughout architecture change cycles.

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Information Not Available
Buyer's Guide
Enterprise Architecture Management
May 2024
Download Free Report
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: May 2024.
DOWNLOAD NOW
787,061 professionals have used our research since 2012.
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.