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
3rd
Ranking in Business Process Design
9th
Average Rating
8.6
Reviews Sentiment
6.6
Number of Reviews
40
Ranking in other categories
Data Governance (14th)
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 October 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.8%, down from 10.7% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 11.3%, down from 15.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
Sparx Systems Enterprise Architect11.3%
erwin Data Modeler8.8%
Other79.9%
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 principal feature that I liked is that the solution has a very graphic interface."
"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."
"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 product lets us import different types of models from various databases."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"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."
"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."
"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."
"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."
"A feature I like most about Sparx Systems Enterprise Architect is its ease of use."
"There are a lot of features in Enterprise Architect. It allows us to take on a lot of tasks."
"The platform is stable and reliable."
"The solution saved a lot of time, about 30%."
"Its most valuable feature is the Zachman Framework."
"It is simple to build the first model for the solution."
"Sparx Systems Enterprise Architect is very flexible and it is simple to define the metamodel. Additionally, it is lightweight on resources."
 

Cons

"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 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."
"It is not a very stable solution. I rate the stability five out of ten."
"It does not have a cloud application."
"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."
"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 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 reverse engineering in Oracle Databases needs improvement, as there are issues."
"Not visually appealing."
"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."
"Their technical support is not good in India. I wrote to them because I had a question, but I never got an answer. So, I just left it behind."
"I think that collaboration can be better."
"This solution is quite complex to use. It would be nice if the learning curve wasn't so steep."
"I have found the solution is lacking options. The general usability needs improvement and more compliance to CML definitions."
"This solution should have better ease of use for the uninitiated."
"The UI is a little bit outdated. It should be more fresh and clean."
 

Pricing and Cost Advice

"There are no costs in addition to the standard licensing fees."
"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."
"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."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"The price should be lower in order to be on the same level as its competitors."
"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."
"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 Corporate Edition, or one of the bundles, is the way to go."
"The pricing for ultimate version is steeply high."
"The licence has a costly upfront fee which gets you access. You have to pay an annual maintenance fee, which is less."
"I think our license costs roughly $1,000 a year, but I could be wrong."
"It is cheap."
"Enterprise licensing is competitive. What would be helpful if they load the pricing for consultants, you know, people who are consultants for clients. So the license is fine for end-user organizations. Still, they should consider lowering the license to support this adoption, particularly for people who are consultants like myself."
"They have the price on their site for the enterprise version, and we do receive a small discount."
"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.
868,759 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
11%
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 Enterprise29
By reviewers
Company SizeCount
Small Business38
Midsize Enterprise20
Large Enterprise58
 

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?
I do not recall the pricing from about a year and a half ago, but it seems reasonable.
What needs improvement with erwin Data Modeler by Quest?
erwin Data Modeler could improve its UI as it still feels old school and not very modern. There are many features, and I would expect good documentation detailing each feature, including when and h...
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: September 2025.
868,759 professionals have used our research since 2012.