Try our new research platform with insights from 80,000+ expert users

Sparx Systems Enterprise Architect vs erwin Data Modeler comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 1, 2026

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

erwin Data Modeler
Ranking in Enterprise Architecture Management
1st
Ranking in Business Process Design
6th
Average Rating
8.4
Reviews Sentiment
5.9
Number of Reviews
48
Ranking in other categories
Data Governance (9th)
Sparx Systems Enterprise Ar...
Ranking in Enterprise Architecture Management
4th
Ranking in Business Process Design
5th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
99
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.3%, down from 11.0% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 8.2%, down from 14.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Mindshare Distribution
ProductMindshare (%)
erwin Data Modeler8.3%
Sparx Systems Enterprise Architect8.2%
Other83.5%
Enterprise Architecture Management
 

Featured Reviews

Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.
Milan Sterba - PeerSpot reviewer
Senior Enterprise Architect at Deepview S.r.o.
Efficient documentation generation through organized model structure with a good price-performance ratio
Whenever I begin a new project with Sparx, I have to spend time training people on how to use it since it is not straightforward. Although it's a powerful product with plenty of features, it's not easy for even experienced users to find their way without guidance. This is not the most user-friendly solution.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product lets us import different types of models from various databases."
"The principal feature that I liked is that the solution has a very graphic interface."
"The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."
"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."
"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."
"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."
"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"Currently in the market, there is no competitor to erwin Data Modeler; everything is very powerful, such as performing reverse engineering from an existing database and deploying that on Databricks or Snowflake."
"Automated document generation is a real time saver, no more cut and paste, no more keeping track of which diagrams are in which reports, no more last minute update panics. Just click a mouse and you've got an up to date report."
"Its ability to reference and link to components from any diagram."
"It provides good utilization and it's a convenient tool for building exact architectural work."
"A feature I like most about Sparx Systems Enterprise Architect is its ease of use."
"There are a couple of things. Price is one thing, but we also like the scriptability of it. We got into scripting it and automating tasks with it, and it is super duper easy to do and helpful. The API has improved over the years. We automate everything, and I love the automation aspects of it."
"Sparx technical support is good."
"Scalable solution for modeling, project sharing, and collaboration. Support for it is good."
"The platform is stable and reliable."
 

Cons

"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."
"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."
"I would like the solution to be more user-friendly to deploy."
"Sometimes when I want to open the attribute editor, it stops working and the whole application freezes."
"We can only get licenses through partners."
"It is not a very stable solution. I rate the stability five out of ten."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"The solution's reporting side needs to be improved."
"It should be made Windows compatible."
"The UI is a little bit outdated. It should be more fresh and clean."
"This solution is quite complex to use. It would be nice if the learning curve wasn't so steep."
"It would be nice to have it supported on the Linux operating system."
"From a practical point of view, we need speed and reliability for creating a model and doing some really meaningful tasks such as application landscape, refactoring, etc. These are two primary criteria. Sometimes, when you import something, it creates the object duplicates, or it allows you to do something that you're not supposed to do. For example, validation is missing. This could be frustrating because when you work at a high speed, you need to come back and start fixing things that the tool allowed you to go with, which is not quite good. So, there should probably be some internal mechanisms to advise you about what you're doing and what is probably not the best idea."
"This solution should have better ease of use for the uninitiated."
"In a future release, they should improve portfolio planning."
"When the model is large, it is a bit slow to render."
 

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."
"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."
"The tool is expensive."
"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."
"There are two license options and the pricing is reasonable."
"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 solution is expensive."
"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."
"It is cheap."
"Licenses are pretty low cost compared to, for example, ARIS."
"We had a yearly license."
"It's affordable. The only additional cost that we haven't yet figured out is the floating license. If you buy a floating license, you have to have a license management server, which comes at an additional cost that's not discussed. So, we haven't yet used the floating license. That’s because I haven't had a chance to figure that out."
"It's reasonably priced for large organizations."
"Sparx Systems Enterprise Architect is priced well. The price we pay is approximately $20 per month. Other solutions I have found to be much more expensive."
"The license I use is on-premise. We haven't gone to the cloud where we have to pay monthly or something like that. Sparx is cheaper than most similar tools."
"Pricing and licensing is very attractive, simple, and straightforward."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
884,076 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Manufacturing Company
8%
Government
7%
Performing Arts
5%
Financial Services Firm
13%
Manufacturing Company
10%
Government
10%
Computer Software Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise35
By reviewers
Company SizeCount
Small Business38
Midsize Enterprise20
Large Enterprise58
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
I have no idea about the setup cost because I did not buy the license.
What needs improvement with erwin Data Modeler by Quest?
As we all know, AI is taking up a majority of things. I felt that erwin Data Modeler is a bit of an outdated tool. It needs a new look and integrating AI into it would be much better for learning. ...
What is your primary use case for erwin Data Modeler by Quest?
For erwin Data Modeler, the use case was to create a data model for the organization. It articulates how data flows throughout the organization. For example, we have an employee table with two type...
What do you like most about Sparx Systems Enterprise Architect?
The stability has been good and satisfactory. I would rate the stability a ten out of ten.
What is your experience regarding pricing and costs for Sparx Systems Enterprise Architect?
One of the reasons many public sector institutions in the Czech Republic use it is that it provides a very good price-performance ratio. While it might be cumbersome to learn, it still delivers exc...
What needs improvement with Sparx Systems Enterprise Architect?
Whenever I begin a new project with Sparx, I have to spend time training people on how to use it since it is not straightforward. Although it's a powerful product with plenty of features, it's not ...
 

Also Known As

erwin DM
No data available
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
OmniLink
Find out what your peers are saying about Sparx Systems Enterprise Architect vs. erwin Data Modeler and other solutions. Updated: March 2026.
884,076 professionals have used our research since 2012.