Try our new research platform with insights from 80,000+ expert users

IBM Rational System Architect vs erwin Data Modeler comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 1, 2026

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
Ranking in Enterprise Architecture Management
1st
Average Rating
8.4
Reviews Sentiment
5.9
Number of Reviews
48
Ranking in other categories
Business Process Design (6th), Data Governance (9th)
IBM Rational System Architect
Ranking in Enterprise Architecture Management
18th
Average Rating
7.4
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.3%, down from 11.0% compared to the previous year. The mindshare of IBM Rational System Architect is 2.2%, up from 1.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Mindshare Distribution
ProductMindshare (%)
erwin Data Modeler8.3%
IBM Rational System Architect2.2%
Other89.5%
Enterprise Architecture Management
 

Featured Reviews

Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.
GM
IT/Business Architect at a financial services firm with 51-200 employees
Lots of valuable features, especially the metamodel customization
In terms of what could be improved, we did not take the whole package with all the modules, and I think that the integration with other platforms like Office could be better. The reverse engineering of the database is already there, but in the next release I would like to see some pilot supplied with the solution in order to address any database.

Quotes from Members

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

Pros

"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"I compare erwin Data Modeler with other solutions such as ER/Studio and believe it stands out as an enterprise-grade data modeling tool capable of serving different industries, such as finance, healthcare, and telecom."
"Currently in the market, there is no competitor to erwin Data Modeler; everything is very powerful, such as performing reverse engineering from an existing database and deploying that on Databricks or Snowflake."
"The product lets us import different types of models from various databases."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"The modeling portion of the tool is the most valuable. There are some notes, naming standards, and other functions that we use as well. There's a whole boatload of functionality in this thing and we use maybe 10% of it. It seems to be pretty common that not all the functionality is fully utilized. But it's just got gobs and gobs of stuff that you can implement if you so choose to."
"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."
"We have seen ROI with this solution over the years that we have used it."
"The System Architect Product has greatly assisted the corporate strategic planning process in two areas: the simulation of scenarios for Enterprise Transformation Projects and providing a global view of Enterprise Capabilities and Functional Gaps."
"The user interface is good. It's both clear and comprehensible. It's easy to work with."
"There are a lot of features I find valuable, but I think that the metamodel customization is one of the best features that the solution offers."
"The solution is pretty stable."
 

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."
"The erwin Data Modeler is quite complex to use."
"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."
"I would like the solution to be less rigid in terms of its theory."
"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."
"I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else."
"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."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"There needs to be more information at the outset about how to use the solution and how to deploy it. The deployment process needs improvement."
"The solution needs to better integrate with other products, like Microsoft."
"This solution can be more user-friendly and easier to use, with better dashboards."
"Some aspects of the user interface lack a common navigational or functional framework."
"The reverse engineering of the database is already there, but in the next release I would like to see some pilot supplied with the solution in order to address any database."
 

Pricing and Cost Advice

"There are two license options and the pricing is reasonable."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"Pricing is very high compared to any other product."
"The solution is expensive."
"There are no costs in addition to the standard licensing fees."
"The tool is expensive."
"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."
"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."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
884,873 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Manufacturing Company
8%
Government
7%
Performing Arts
5%
Financial Services Firm
11%
Government
11%
Manufacturing Company
9%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise35
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
I have no idea about the setup cost because I did not buy the license.
What needs improvement with erwin Data Modeler by Quest?
As we all know, AI is taking up a majority of things. I felt that erwin Data Modeler is a bit of an outdated tool. It needs a new look and integrating AI into it would be much better for learning. ...
What is your primary use case for erwin Data Modeler by Quest?
For erwin Data Modeler, the use case was to create a data model for the organization. It articulates how data flows throughout the organization. For example, we have an employee table with two type...
Ask a question
Earn 20 points
 

Also Known As

erwin DM
Rational System Architect
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Wuxi Lake Cloud, Nationwide, ETI, IDS Scheer
Find out what your peers are saying about IBM Rational System Architect vs. erwin Data Modeler and other solutions. Updated: March 2026.
884,873 professionals have used our research since 2012.