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 February 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 11.2%, up from 9.9% compared to the previous year. The mindshare of Sparx Systems Enterprise Architect is 14.5%, down from 19.3% 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

"One of the best aspects of the tool is its reverse engineering capability."
"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."
"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 principal feature that I liked is that the solution has a very graphic interface."
"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."
"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."
"Its ability to reference and link to components from any diagram."
"Ability to maintain cross-references for all models in all levels - great tractability."
"Artifact templates are most valuable."
"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."
"Large variety of profiles and frameworks available out-of-the-box without the need for customization."
"We use it to develop and maintain the Enterprise Conceptual Model, migrated from erwin a couple of years ago."
"The solution saved a lot of time, about 30%."
"Customizable and tailored to the environment. Several template frameworks are provided."
 

Cons

"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."
"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."
"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."
"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"I would like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."
"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."
"As someone who has used it for a long time, I have seen stability vary from version to version."
"I would like the solution to be less rigid in terms of its theory."
"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."
"It really did not work for logical modeling. The look is very old-fashioned. You can't make the diagrams easy on the eye, so we ended up drawing them again in Visio anyhow."
"The integration could be improved."
"Using EA involves a steep learning curve if you want to understand its capabilities and functionality."
"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."
"The reporting needs improvement."
"The dashboard and connectivity could be improved."
"This solution should have better ease of use for the uninitiated."
 

Pricing and Cost Advice

"There are two license options and the pricing is reasonable."
"Pricing is very high compared to any other product."
"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."
"erwin Data Modeler by Quest is an expensive solution."
"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 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."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"Licenses are pretty low cost compared to, for example, ARIS."
"We paid 1200 euros as a once-off cost. All add ons and integrations come at an additional cost."
"It is very economical and low cost. You have to pay for a one-time license, and it is active forever."
"Use floating licenses strategically."
"This product has a paid license, with a yearly subscription option."
"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 affordable. The only additional cost that we haven't yet figured out is the floating license. If you buy a floating license, you have to have a license management server, which comes at an additional cost that's not discussed. So, we haven't yet used the floating license. That’s because I haven't had a chance to figure that out."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
838,713 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: January 2025.
838,713 professionals have used our research since 2012.