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
9th
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
3rd
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 April 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 10.9%, up from 9.9% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 13.9%, down from 18.8% 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

"It has centralized storage so that a data model can be shared by different teams."
"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"One of the best aspects of the tool is its reverse engineering capability."
"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."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."
"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 is a scalable solution...The technical support team is fine."
"The TOGAF ADM model is most valuable. It is also very cheap as compared to other options in the market."
"The solution is easy to use, supports SysML and UML, and is able to connect to MATLAB. This is very important for us."
"Using Sparx Enterprise Architect allowed my customer to detail and make the company's IT strategy visible and accessible to all. The system provided clear roadmaps for IT development and helped to keep up-to-date documentation of systems and processes."
"Sparx Systems Enterprise Architect supports multiple modeling languages like ArchiMate for database design, software lifecycle visualization, and team management."
"The solution saved a lot of time, about 30%."
"The profiles and ready-made templates are an extremely helpful feature. This is one of the biggest features that I find very useful in Sparx."
"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."
"It's like a repository. So far, we use it only for Information Modelling."
 

Cons

"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."
"erwin is not as robust as a data warehousing project I've been on in the past."
"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."
"We can only get licenses through partners."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"It is not a very stable solution. I rate the stability five out of ten."
"I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"More challenging than other tools to maintain documents and document versions for an architecture board review."
"Using EA involves a steep learning curve if you want to understand its capabilities and functionality."
"The Business Process Modeling or BPM feature can be improved to make it more interactive and user friendly because it is a tool for technical people. My current use is only for business process modeling notation and putting in the icons etc. You need to take them in as a class, which makes things very complex. Because of this complexity, it is not an easy-to-handle solution. Enterprise Architect is not very good for mockups. We cannot create user screens and other similar kinds of stuff, which is bad. For these things, we prefer to use Axure RP and other similar solutions. They should either remove this feature from this product or provide some kind of connectivity with Axure RP so that people can do better mockups of screens and import them. They need to augment and strengthen the BPM feature, which is the main feature. They need to put in some elements like artificial intelligence and augmented reality. They should look into such features because these things are coming up."
"There should be a MATLAB-specific toolbox added to the solution with better compatibility. The connections currently are good but in the future, it needs a huge improvement."
"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."
"I would like to see integration with Confluence or any other TRM, and the capability to integrate with the data storage, such as a repository similar to GitHub."
"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."
"I think the product is good. When I'm trying to do something specific for some part of project documentation, it's hard to get it figured out if you don't use it all the time. It's such a massive tool, it's hard to figure out how to dig in and get to the documentation where you have to be to get some idea of what to do. There are not a lot of examples that I'm aware of to be able to do that."
 

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."
"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."
"Though the solution is not cheap, it's worth the money."
"Likewise, the solution is a little pricey."
"There are two license options and the pricing is reasonable."
"erwin Data Modeler by Quest is an expensive solution."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"The solution is expensive."
"We had a yearly license."
"Pricing and licensing is very attractive, simple, and straightforward."
"The licensing is not as expensive as some of the other data modeling tools such as Erwin."
"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."
"The pricing for ultimate version is steeply high."
"Pricing and licensing are suitable even for small companies."
"We have an annual license, and it's very affordable."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
848,716 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
Educational Organization
18%
Financial Services Firm
11%
Government
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 by Quest and other solutions. Updated: April 2025.
848,716 professionals have used our research since 2012.