SAP Enterprise Architecture Designer vs erwin Data Modeler by Quest comparison

erwin by Quest and SAP are both solutions in the Enterprise Architecture Management category. erwin by Quest is ranked #3 with an average rating of 8.2, while SAP is ranked #23. erwin by Quest holds a 11.0% mindshare in AM, compared to SAP’s 0.8% mindshare. Additionally, 95% of erwin by Quest users are willing to recommend the solution, compared to 100% of SAP users who would recommend it.

erwin Data Modeler by Quest

Read 38 erwin Data Modeler by Quest reviews

4,727 Views
2,584 Comparison Views

95% willing to recommend

SAP Enterprise Architecture...

Read 1 SAP Enterprise Architecture Designer review

307 Views
206 Comparison Views

100% willing to recommend

erwin Data Modeler by Quest

SAP Enterprise Architecture...

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 SAP LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management.

To learn more, read our detailed Enterprise Architecture Management Report (Updated: December 2024).

Buyer's Guide

Enterprise Architecture Management

December 2024

Download the complete report

Helped 824,067 peers since 2012

Categories and Ranking

erwin Data Modeler by Quest

Ranking in Enterprise Architecture Management

3rd

Average Rating

8.6

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

Business Process Design (9th)

SAP Enterprise Architecture...

Ranking in Enterprise Architecture Management

23rd

Average Rating

8.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of December 2024, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 11.0%, up from 10.0% compared to the previous year. The mindshare of SAP Enterprise Architecture Designer is 0.8%, down from 0.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Enterprise Architecture Management

Featured Reviews

JorgeSanz

Data Governance Senior Advisor at Abu Dhabi National Oil Company

Streamline data modeling and automate network changes for increased efficiency

The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.

Read full review

Artur Chyziewicz

Co-Owner at Edusolution s.c.

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 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."

"Quest can create conceptual and physical data models to facilitate effective communication between business and IT. It can also integrate expertise from various engineering and database systems within your organization to enhance data management and administration."

"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."

"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."

"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."

"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."

"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 generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."

More erwin Data Modeler by Quest pros

"Traceability is a fantastic feature."

Cons

"I am not so happy with its speed. Sometimes, it can have problems with connections."

"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 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."

"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 the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."

"The interface must be improved."

"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 by Quest cons

"The algorithm is outdated and should be upgraded."

Pricing and Cost Advice

"The price of erwin Data Modeler is very expensive, in particular for this part of the world."

"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."

"erwin Data Modeler by Quest is an expensive solution."

"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."

"The tool is expensive."

"There is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."

"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."

"The solution is expensive."

More erwin Data Modeler by Quest pricing and cost advice

Information not available

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

824,067 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

19%

Manufacturing Company

Government

Computer Software Company

University

14%

Educational Organization

Financial Services Firm

Retailer

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?

The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.

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

Ask a question

Earn 20 points

Comparisons

SAP PowerDesigner vs erwin Data Modeler by Quest

Compared 28% of the time

IDERA ER/Studio vs erwin Data Modeler by Quest

Compared 17% of the time

Lucidchart vs erwin Data Modeler by Quest

Compared 15% of the time

Visio vs erwin Data Modeler by Quest

Compared 10% of the time

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

Compared 44% of the time

Sparx Systems Enterprise Architect vs SAP Enterprise Architecture Designer

Compared 29% of the time

MEGA HOPEX vs SAP Enterprise Architecture Designer

Compared 27% of the time

More SAP Enterprise Architecture Designer Competitors

Product Reports

Buyer's Guide

erwin Data Modeler by Quest

December 2024

Download erwin Data Modeler by Quest product report

Buyer's Guide

Enterprise Architecture Management

December 2024

SAP Enterprise Architecture Designer report

Download 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

December 2024

Download Free Report

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

DOWNLOAD NOW

824,067 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.