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 Nov 23, 2025

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
2nd
Average Rating
8.4
Reviews Sentiment
5.9
Number of Reviews
47
Ranking in other categories
Business Process Design (7th), 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 February 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.4%, down from 11.2% compared to the previous year. The mindshare of IBM Rational System Architect is 2.1%, up from 1.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler8.4%
IBM Rational System Architect2.1%
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

"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."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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."
"It is a scalable solution...The technical support team is fine."
"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."
"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."
"My favorite feature of erwin Data Modeler is that we can export and import tables directly from the databases, and it is easy to map from table to table and column to column."
"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"The solution is pretty stable."
"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."
"We have seen ROI with this solution over the years that we have used it."
 

Cons

"It is not a very stable solution. I rate the stability five out of ten."
"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."
"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."
"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
"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."
"Sometimes when I want to open the attribute editor, it stops working and the whole application freezes."
"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."
"I would like the solution to be less rigid in terms of its theory."
"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."
"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."
"This solution can be more user-friendly and easier to use, with better dashboards."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"There are two license options and the pricing is reasonable."
"There are no costs in addition to the standard licensing fees."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"The price should be lower in order to be on the same level as its competitors."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"erwin Data Modeler by Quest is an expensive solution."
"Likewise, the solution is a little pricey."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
881,733 professionals have used our research since 2012.
 

Top Industries

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

Company Size

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

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
Regarding pricing, I am unsure what the exact price is for erwin Data Modeler, but I believe it is not useful for an individual. It is more targeted toward an enterprise level since organizations l...
What needs improvement with erwin Data Modeler by Quest?
I write code and I write code accessing erwin Data Modeler's API, the Application Programming Interface, so that I can use Excel to update erwin Data Modeler and then get those updates and put them...
What is your primary use case for erwin Data Modeler by Quest?
I work for CVS with a pretty big database as a data modeler on the PBMs, the Caremark PBM side, which is the Pharmacy Benefits Manager. There's a retail side too for all the stores, but our data wa...
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: February 2026.
881,733 professionals have used our research since 2012.