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
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 March 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 11.0%, up from 10.0% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 14.2%, down from 19.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

"It has centralized storage so that a data model can be shared by different teams."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"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."
"It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"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 macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"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."
"Its most valuable feature is the Zachman Framework."
"Sparx offers good flexibility."
"We could capture the process models around 24 countries with all their local variations."
"The most valuable feature is the integrated data model, so if I change the name of an item, all models using that object are automatically updated."
"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."
"It is simple to build the first model for the solution."
"The solution saved a lot of time, about 30%."
"Sparx Systems Enterprise Architect supports multiple modeling languages like ArchiMate for database design, software lifecycle visualization, and team management."
 

Cons

"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."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."
"The interface must be improved."
"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."
"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."
"The solution's model mark could be better because it crashes sometimes."
"Its best features are not intuitive or easy to learn. Most companies I have worked with, when I see what they are doing with it , are not using more than 5% of what they could and should be doing with it."
"I would like the system to more "intellectually" build a scheme, place icons, and connect lines on the schemes."
"Inconsistent UI elements must be tidied up with the toolbox gaps removed."
"For data modeling, it is not very mature when comparing with other data modeling tools."
"It should be made Windows compatible."
"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."
"Insufficient control of metadata and standards."
"One room for improvement in Sparx Systems Enterprise Architect is that it's not very friendly. Another room for improvement in the tool is that it doesn't enable you to import the metadata from a database very easily, so reverse engineering of a database was very difficult. Its database modeling and entity-relationship modeling functions need improvement."
 

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 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 solution is expensive."
"Likewise, the solution is a little pricey."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"We paid 1200 euros as a once-off cost. All add ons and integrations come at an additional cost."
"I rate the solution's pricing a five out of ten."
"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."
"The solution is quite expensive."
"Its price is very good for the value that you get with it."
"The licensing is not as expensive as some of the other data modeling tools such as Erwin."
"Use floating licenses strategically."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
842,466 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%
Manufacturing 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: March 2025.
842,466 professionals have used our research since 2012.