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 Aug 19, 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
4th
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
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 August 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 10.0%, down from 10.4% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 12.7%, down from 17.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
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.
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

"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."
"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."
"One of the best aspects of the tool is its reverse engineering capability."
"It is a scalable solution...The technical support team is fine."
"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."
"We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"One of the best aspects of the tool is its reverse engineering capability."
"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 advantages of Enterprise are that it's cheaper and much more practical than MagicDraw."
"It has led some teams to do better code reviews - to be less focussed on coding conventions (syntax) and more focussed on the semantics because of the abstraction level clear design affords."
"Simplified our task at maintaining architecture information and traceability with requirements."
"The most valuable features are the flexibility and adaptability of Sparx Enterprise Architect."
"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"
"The product offers very good support for all mainstream modeling notations and architectural frameworks."
"We can easily use it with our new customers."
"Customizable and tailored to the environment. Several template frameworks are provided."
 

Cons

"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 am not so happy with its speed. Sometimes, it can have problems with connections."
"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."
"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."
"The interface must be improved."
"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 model mark could be better because it crashes sometimes."
"This is a very complex product."
"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 product could be improved in terms of its ease of use and documentation. While it offers a lot of functionality, it can be difficult to grasp how to utilize these features effectively."
"More challenging than other tools to maintain documents and document versions for an architecture board review."
"The window froze for five or ten seconds. You can click and click again and it takes a second to come up. It might have been specific to a version."
"In a future release, they should improve portfolio planning."
"Greater OMG UML and XMI compliance"
"The solution's interface could be more straightforward."
"Even if there are web-based tools in the Enterprise Architecture tool ecosystem (like Prolaborate), the main modeling application is still a fat client application."
 

Pricing and Cost Advice

"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."
"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 no costs in addition to the standard licensing fees."
"Likewise, the solution is a little pricey."
"The price should be lower in order to be on the same level as its competitors."
"The tool is expensive."
"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."
"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."
"The pricing for ultimate version is steeply high."
"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."
"We have an annual license, and it's very affordable."
"We paid 1200 euros as a once-off cost. All add ons and integrations come at an additional cost."
"There is no license required for this solution."
"It is cheaper than other solutions. Its cost is around $686 per year. There are no costs in addition to the standard licensing fees."
"It’s the best deal in town, by far."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
865,295 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
Financial Services Firm
13%
Government
12%
Manufacturing Company
10%
Computer Software Company
9%
 

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 and other solutions. Updated: July 2025.
865,295 professionals have used our research since 2012.