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 Nov 23, 2025

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
2nd
Ranking in Business Process Design
8th
Average Rating
8.6
Reviews Sentiment
5.9
Number of Reviews
44
Ranking in other categories
Data Governance (15th)
Sparx Systems Enterprise Ar...
Ranking in Enterprise Architecture Management
5th
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 January 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.3%, down from 11.1% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 9.3%, down from 14.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler8.3%
Sparx Systems Enterprise Architect9.3%
Other82.4%
Enterprise Architecture Management
 

Featured Reviews

Alton Thibodeaux - PeerSpot reviewer
Data Warehouse Architect at a healthcare company with 10,001+ employees
Data modeling has supported secure migration from legacy platforms to cloud analytics
I write code and I write code accessing erwin Data Modeler's API, the Application Programming Interface, so that I can use Excel to update erwin Data Modeler and then get those updates and put them back into spreadsheets. The only thing I wish is that their API documentation was a little bit clearer and that it had better examples of successful code. To me, examples are worth a hundred pages of reference documentation. Just give me an example of how you use it, and that really helps. I know that's a nitpicking thing, but I wish their API documentation had a lot more examples of code that actually worked to do the things that they're talking about. As far as erwin Data Modeler itself goes, when we have a lot of tables, I have some erwin Data Modeler files that have thousands of tables in them, up to 3,000 or 4,000 tables. When erwin Data Modeler files start getting that big, it takes a really long time, I'd say a minute or more, to open the file. Whenever I'm working in it, sometimes there are operations that also take a long time, so as erwin Data Modeler files get larger, the response time really slows down. An irritation is that every now and then, when I'm working and usually when I have multiple erwin Data Modeler files open at the same time, I get a glitch where a lot of the text fields get solid black, the first eight characters of column names might be blacked out with a rectangle. All I have to do is close erwin Data Modeler, shut it down, and bring it back up, and then everything is fine. It doesn't happen all the time, only occasionally, maybe once or twice a week, and those are the only two things I can say. The previous version of erwin Data Modeler used to crash unaccountably, but this one hasn't ever crashed on me, so it's been a lot more stable than the previous version that we had.
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 solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"It is a scalable solution...The technical support team is fine."
"The fitting model is very intuitive."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"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."
"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 most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"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."
"Its ease of use and the breadth of the toolkit are most valuable. It has an incredible repository of artifacts to work with, and they're all cross-referenced. It works with a whole bunch of different standards. It works with BPMN, which is Business Process Modeling Notation, and it also works with something called TOGAF, which is the Open Group Architecture Foundation. There are different layers when you're dealing with architecture. There is the user interface, application, data, data servers, and all that kind of stuff. You have the infrastructure, hardware, and software layers, and then you have the application and business capability layers. You can model a business process and decompose it into all of the applications, data, and hardware to support it."
"Sparx has got a range of modeling features, and I am comfortable with all its offering. I've used a lot of tools over the phone. I found EA Spark, probably the most feature rich product all in all compared to other products. The solution is very cost-effective and that is its best feature. It's a very good delivery architecture tool, which also has enterprise architecture capabilities, and it's got full life cycle processes and software development. So for me, it's a pretty comprehensive tool"
"Simplified our task at maintaining architecture information and traceability with requirements."
"We use it to develop and maintain the Enterprise Conceptual Model, migrated from erwin a couple of years ago."
"It's easy to search within the solution."
"I like that there is support for software patterns."
"The platform is stable and reliable."
"Its ability to reference and link to components from any diagram."
 

Cons

"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."
"This is a very complex product."
"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."
"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."
"We can only get licenses through partners."
"I would like to have more data sources from other, different vendors. In recent years, the vendor has reduced the number of data sources, and I would like to have more data sources for every brand. For example, with Oracle, I would like to have compatibility for many versions, including old ones, not just the most recent."
"Erwin Data Modeler is a good product, but I recently experienced a problem where I was not able to open an erwin Data Modeler file because its version had automatically changed."
"It should be made Windows compatible."
"The UI is a little bit outdated. It should be more fresh and clean."
"They should make the Save button easier to find. A simplified user interface for a lighter user would probably be useful. I am not sure if such an interface is already there."
"The solution needs to offer better support for the mobile-based system. Right now, it's not working."
"I have found the solution is lacking options. The general usability needs improvement and more compliance to CML definitions."
"In a future release, they should improve portfolio planning."
"I would like it to be less of a general tool. Currently, it is not a Swiss army knife that can do everything. It is not specialized for our purposes. We are a civil engineering company. We build things. We work mostly in what is known as Infra world in the Netherlands, which comprises objects such as bridges, locks, and water management. We would like to see more focus on such types of projects. It would be nice if it has more specializations. At the moment, it is very generic, and you have to create everything yourself. Our focus is more on user requirement management, which is currently very basic. I would like to see a lot more functionality in this area. Its basic functions for adding user requirements are perfect, but we need more features. Currently, it has limited possibilities for our requirements. I would also like to see better contract management and have it managed in a certain way."
"It really did not work for logical modeling. The look is very old-fashioned. You can't make the diagrams easy on the eye, so we ended up drawing them again in Visio anyhow."
 

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."
"There are two license options and the pricing is reasonable."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"Likewise, the solution is a little pricey."
"The tool is expensive."
"Pricing is very high compared to any other product."
"There are no costs in addition to the standard licensing fees."
"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."
"The license for Sparx Systems Enterprise Architect is paid yearly, but I don't handle that area. It's good for its price, so I'm rating it a five out of five, but I'm not using it much. I also don't have information regarding additional costs apart from the standard licensing fees."
"There is no license required for this solution."
"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."
"We had a yearly license."
"It's reasonably priced for large organizations."
"They have the price on their site for the enterprise version, and we do receive a small discount."
"It is cheaper than other solutions. Its cost is around $686 per year. There are no costs in addition to the standard licensing fees."
"The pricing for ultimate version is steeply high."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
879,711 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Manufacturing Company
8%
Government
8%
Computer Software Company
6%
Financial Services Firm
13%
Government
10%
Manufacturing Company
10%
Computer Software Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise3
Large Enterprise33
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?
Regarding pricing, I am unsure what the exact price is for erwin Data Modeler, but I believe it is not useful for an individual. It is more targeted toward an enterprise level since organizations l...
What needs improvement with erwin Data Modeler by Quest?
For the review, I would assign an eight because it has its own limitations. It has a very steep learning curve, limited support for NoSQL or streaming systems, and potentially a high licensing cost...
What is your primary use case for erwin Data Modeler by Quest?
I used erwin Data Modeler for approximately two to three years on a project. I used erwin Data Modeler for multi-level data modeling, conducting conceptual, logical, and physical data modeling with...
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: December 2025.
879,711 professionals have used our research since 2012.