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

"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."
"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 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."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"It has centralized storage so that a data model can be shared by different teams."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"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."
"Sparx Systems Enterprise Architect was easy to set up and it took just twenty minutes."
"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."
"I have found the Meta Model tuning feature useful as it provides me with an overview of all my work needs."
"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."
"The solution saved a lot of time, about 30%."
"It is a very rich tool in terms of the functionality, and the types of diagrams, that you can create in this tool."
 

Cons

"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."
"The solution's model mark could be better because it crashes sometimes."
"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."
"The solution's reporting side needs to 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."
"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."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"It took me a while to figure out how to use the report generation features effectively. So, it would be really nice if they had a way to make that a little bit more interactive and a little bit more straightforward."
"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 stability and performance of Sparx Systems Enterprise Architect could still be improved. Setup for it is also slightly complicated and could be improved."
"The Portfolio Management features can be added in the next release. As it helps you to manage more portfolio of projects and architectures of cost projects on a portfolio level. This would be an important feature in the next release."
"For data modeling, it is not very mature when comparing with other data modeling tools."
"It could be more user-friendly. The tools could be more simple to use. It's a very complex solution. Because I am a business analyst, I use these tools to manage requirements, and I make models in UML, BPMN, and ArchiMate, and it's complex. In the next release, I would like to see more integrations."
"The documentation needs a bit of improvement. What I find is that when I'm trying to do something specific for some part of a project, in terms of documentation, it's kind of hard to get at figuring out if you don't use it all the time."
"I think that collaboration can be better."
 

Pricing and Cost Advice

"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"The price should be lower in order to be on the same level as its competitors."
"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."
"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."
"This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
"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."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"There are no costs in addition to the standard licensing fees."
"Pricing and licensing are suitable even for small companies."
"Pricing and licensing is very attractive, simple, and straightforward."
"The solution is quite expensive."
"The Corporate Edition, or one of the bundles, is the way to go."
"There is a license for this solution. When comparing this solution to others it is priced well."
"Use floating licenses strategically."
"It is very economical and low cost. You have to pay for a one-time license, and it is active forever."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
850,671 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
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.
850,671 professionals have used our research since 2012.