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

Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024

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 by Quest
Ranking in Enterprise Architecture Management
3rd
Ranking in Business Process Design
10th
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
No ranking in other categories
Sparx Systems Enterprise Ar...
Ranking in Enterprise Architecture Management
2nd
Ranking in Business Process Design
4th
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 July 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 10.2%, up from 10.0% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 13.2%, down from 17.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

Saswata Mondal - PeerSpot reviewer
The creation of data models is easy and quick, and the fitting model is very intuitive
The ease and quick ability to create the model is valuable. The fitting model is very intuitive. The other cool feature is the reverse engineer feature. If we connect to the database, we can reverse engineer from the database itself of the physical model. That gives us the relationship of the data if not much documentation is available.
Milan Sterba - PeerSpot reviewer
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

"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"The solution is excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."
"It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"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."
"The data lineage feature is very valuable."
"Scalable solution for modeling, project sharing, and collaboration. Support for it is good."
"The installation was very easy."
"Sparx technical support is good."
"I have found the Meta Model tuning feature useful as it provides me with an overview of all my work needs."
"Provides a single repository for all architecture work."
"Ability to model and create view under same roof."
"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"
"Its traversability is most valuable. I can use ArchiMate, and I can create a UML model. ArchiMate is for logical enterprise architecture, UML is for software engineering, and BPMN is for business processes. I can build it to have multiple models, and they are also traversable, which is not something that every tool allows. If there is a huge organization, you can segment it and have separate models for business technology or internal resource management system. You don't need to keep them in one model, and you can decide to segregate them."
 

Cons

"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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."
"We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from individual desktops and get them into a single data model, when multiple data modelers are working on a particular project. It becomes a nightmare for the senior data modeler to bring them together, especially when it comes to recreating them when you want to merge them."
"We can only get licenses through partners."
"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 system to more "intellectually" build a scheme, place icons, and connect lines on the schemes."
"The reporting needs improvement."
"It could be more user-friendly. The tools could be more simple to use. It's a very complex solution. Because I am a business analyst, I use these tools to manage requirements, and I make models in UML, BPMN, and ArchiMate, and it's complex. In the next release, I would like to see more integrations."
"The integration could be improved."
"In general, we now have a problem with Sparx Enterprise Architect because many analysts think it's too complicated to use in a giant environment."
"The UI could be improved and made a little bit more presentable."
"There used to be that feature in ArchiMate Modeling of Enterprise Architect called inherited relationships. Now it's gone."
"The automatic creation of reports based on the model elements could be improved."
 

Pricing and Cost Advice

"There are two license options and the pricing is reasonable."
"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."
"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."
"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."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"The solution is expensive."
"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 quite 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."
"This product has a paid license, with a yearly subscription option."
"We paid 1200 euros as a once-off cost. All add ons and integrations come at an additional cost."
"In terms of cost, Sparx EA is probably one of the cheapest tools I have ever used."
"It is very economical and low cost. You have to pay for a one-time license, and it is active forever."
"Pricing and licensing is very attractive, simple, and straightforward."
"I use my own license. So, I just bought the professional version, which costs $800 or something like that. In the company where I am working, we have floating licenses. They are probably more expensive. Its licensing is affordable, but we are talking about a large organization, and there could be modelers or viewers of the models. We don't know how much that would cost us."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
861,524 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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.
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.
What needs improvement with erwin Data Modeler by Quest?
As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...
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 by Quest and other solutions. Updated: July 2025.
861,524 professionals have used our research since 2012.