Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest comparison

Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest

Download the complete report

Helped 845,040 peers since 2012

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

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

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

Data Governance Senior Advisor at Abu Dhabi National Oil Company

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.

Read full review

Milan Sterba

Senior Enterprise Architect at Deepview S.r.o.

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.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"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."

"The data lineage feature is very valuable."

"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."

"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."

"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."

"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."

"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."

More erwin Data Modeler by Quest pros

"Sparx Systems Enterprise Architect was easy to set up and it took just twenty minutes."

"It's a stable and scalable solution. I like that it's similar to Rational Rose."

"This is a useful tool for IT people who need to design their solution architecture."

"The Business Process Modeling or BPM part is the most valuable. Its ability to simulate scenarios is also very useful. It can also create descriptions of the workflows. It has a feature in which if you create some BPMN process, a workflow diagram, and the description inside, you can actually simulate the whole scenario, and you get the description. That's very handy."

"Sparx technical support is good."

"Modeling is a part of my work, and it has a lot of standard modeling languages. It is quite wide, and a lot is possible in it. We are not programming it ourselves, but if you are into programming and developing software yourself, you can go further and do a lot with Sparx. You can work from the framework and go into the details. With this solution, you get a lot of value at a low cost. It is also quite intuitive in terms of use. I like the use of it."

"We use it to develop and maintain the Enterprise Conceptual Model, migrated from erwin a couple of years ago."

"We can easily use it with our new customers."

More Sparx Systems Enterprise Architect pros

Cons

"This is a very complex product."

"The solution's reporting side needs to be improved."

"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."

"One of the best aspects of the tool is its reverse engineering capability."

"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."

"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 erwin Data Modeler is quite complex to use."

"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."

More erwin Data Modeler by Quest cons

"Because its easy to create diagrams one needs to be vigilant on the housekeeping of orphaned fragments - I have written my own scripts to do this, maybe they are available now."

"The documentation could be better. Where I work, we speak French and we don't speak English, so we don't have anything in French. It's perfect in English, but we need something in French."

"I have found the solution is lacking options. The general usability needs improvement and more compliance to CML definitions."

"The UI is a little bit outdated. It should be more fresh and clean."

"When collaborating with other people, it needs to be more user-friendly."

"When many users are accessing the system at the same time, Sparx slows down. It can't easily support a large team."

"The areas of improvement should be focused on utility service such as producing better graphics, perhaps having a wider image library set and producing better models for working directly with customers."

"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."

More Sparx Systems Enterprise Architect cons

Pricing and Cost Advice

"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 primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."

"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."

"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 is very high compared to any other product."

"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."

"The solution is expensive."

More erwin Data Modeler by Quest pricing and cost advice

"They have the price on their site for the enterprise version, and we do receive a small discount."

"There is no license required for this solution."

"The pricing is reasonable."

"Pricing and licensing is very attractive, simple, and straightforward."

"The solution is quite expensive."

"It is very economical and low cost. You have to pay for a one-time license, and it is active forever."

"Its price is very good for the value that you get with it."

"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."

More Sparx Systems Enterprise Architect pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.

See recommendations

845,040 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

19%

Manufacturing Company

10%

Government

Computer Software Company

Educational Organization

18%

Financial Services Firm

11%

Government

10%

Manufacturing Company

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?

SAP PowerDesigner vs erwin Data Modeler by Quest

Comparisons

Compared 31% of the time

IDERA ER/Studio vs erwin Data Modeler by Quest

Compared 18% of the time

Lucidchart vs erwin Data Modeler by Quest

Compared 15% of the time

Visio vs erwin Data Modeler by Quest

Compared 8% of the time

AWS Well-Architected Tool vs erwin Data Modeler by Quest

Compared 4% of the time

More erwin Data Modeler by Quest Competitors

Visual Paradigm vs Sparx Systems Enterprise Architect

Compared 17% of the time

Visio vs Sparx Systems Enterprise Architect

Compared 12% of the time

No Magic MagicDraw vs Sparx Systems Enterprise Architect

Compared 10% of the time

Lucidchart vs Sparx Systems Enterprise Architect

Compared 9% of the time

IBM Rational System Architect vs Sparx Systems Enterprise Architect

Compared 3% of the time

More Sparx Systems Enterprise Architect Competitors

Product Reports

erwin Data Modeler by Quest

Download erwin Data Modeler by Quest product report

Sparx Systems Enterprise Architect

Download Sparx Systems Enterprise Architect product report

Sparx Systems Enterprise Architect report

Also Known As

erwin DM

No data available

Overview

erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

erwin by Quest

Sparx Systems Enterprise Architect is an enterprise solution that helps streamline, accelerate, and integrate software, system, and business development. With this intuitive modeling and design solution, enterprises can stay in control of their workplaces, enable collaboration, support their teams and colleagues, and manage complex projects. Software architects, business analysts, project managers, developers, support staff, and testers can unite under a single repository. Through numerous view points and potential sub-systems, users are offered a unified view in a complex environment.

With Sparx Systems Enterprise Architect, users are also offered a shared model option which can be accessed quickly and securely by in-office and remote team members through the Enterprise Architect’s Pro Cloud Server. Building a coherent, verifiable model can be done by connecting and integrating a variety of behavioral and structural information in visual form. As a result, Enterprise Architect offers high performance, flexibility, and the ability to model, manage, and trace every stage of the business development and modeling process.

Sparx Systems Enterprise Architect Features

Sparx Systems Enterprise Architect assists in creating a unified and accessible vision in business development by offering a flexible platform with a unique set of rich features. These features include:

Test and debug - Streamline software development and visualize software with the simulation process. Users can test and confirm correct behavior, set and oversee test points, and debug and examine software.

Track tasks - Track, prioritize, and assign individual and group tasks to assist in the model’s development. Users can visually monitor their progress through the Gantt chart.

Open standards - Users can visualize and analyze running software with integrated custom tools. They can also run advanced simulations, team-based repositories, testing tools, and version control. In addition, the solution supports enterprise architecture frameworks such as UPDM and TOGAF.

Simulation - Create and debug embedded solutions by simulating behaviors and state models. Users can specify events, triggers, constraints, and more. Users can also specify extensive and complex structural systems and create custom domain-specific solutions.

Reviews from Real Users

Sparx Systems Enterprise Architect merges high-end tools, online availability, a dedication to open standards, and accessible pricing so enterprises can stay in control of their workplaces, whether remote or in-office. Users particularly like the architectural frameworks and the scalability.

Marc L., a principal architecture enterprise solution adviser at Cronomagic Canada, notes, "The product offers very good support for all mainstream modeling notations and architectural frameworks."

An enterprise architect at a manufacturing company writes, "Scalable solution for modeling, project sharing, and collaboration. Support for it is good."

Sparx Systems

Sample Customers

Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples

OmniLink

Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest