No more typing reviews! Try our Samantha, our new voice AI agent.

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.7
Number of Reviews
50
Ranking in other categories
Business Process Design (5th), Data Governance (10th)
IBM Rational System Architect
Ranking in Enterprise Architecture Management
16th
Average Rating
7.4
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 7.2%, down from 10.7% compared to the previous year. The mindshare of IBM Rational System Architect is 2.8%, 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 Modeler7.2%
IBM Rational System Architect2.8%
Other90.0%
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 visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."
"The modeling product itself is far and above anything else that I've seen on the market."
"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."
"It is an invaluable tool for us; it has been part of our data governance process in regards to database design for at least 15 years."
"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."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"Erwin is by far the best tool I've ever used."
"The main advantage of the solution and its most valuable aspect is the customization of the meta-model."
"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."
"The user interface is good. It's both clear and comprehensible."
"We have seen ROI with this solution over the years that we have used it."
"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 user interface is good. It's both clear and comprehensible. It's easy to work with."
"The solution is pretty stable."
 

Cons

"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."
"It is not a very stable solution. I rate the stability five out of ten."
"I would like to see the reporting capabilities be more dynamic and more inclusive of information."
"What I did not like was that sometimes while I was creating relations, I was not getting errors. The errors only appeared when I tried to upload the model into a new database, which took a lot of time because I was creating a model, reproducing XML, and then trying to add the XML in the database."
"I would like to see more support for working with the big-data world. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."
"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another."
"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."
"While I do not have knowledge about pricing for erwin Data Modeler, I think it could improve by having a feature that allows the publishing of models, similar to how Power BI allows for dashboard publishing for different users within an organization, not just data modelers."
"This solution can be more user-friendly and easier to use, with better dashboards."
"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."
"We are not happy with this product and are not planning to continue with it."
"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."
"There needs to be more information at the outset about how to use the solution and how to deploy it."
"It was sold separately and it is not very easy for somebody who wants to use the solution for modeling to think that you have to select specific modules in order to use the product."
"The solution needs to better integrate with other products, like Microsoft."
"Some aspects of the user interface lack a common navigational or functional framework."
 

Pricing and Cost Advice

"An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"Though the solution is not cheap, it's worth the money."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"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."
"The tool is expensive."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
893,244 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise38
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?
The UI in erwin Data Modeler can be improved significantly because when any new person opens the tool, all the toolbars are kept open with many tools in view, making it appear chunky. If possible, ...
What is your primary use case for erwin Data Modeler by Quest?
I primarly use erwin Data Modeler for modeling purposes. Once we have the business requirement, we create the models in erwin Data Modeler, and then we perform forward engineering to get the query ...
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: April 2026.
893,244 professionals have used our research since 2012.