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

Mindshare comparison

As of August 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.0%, down from 10.0% compared to the previous year. The mindshare of IBM Rational System Architect is 3.0%, up from 1.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Mindshare Distribution
ProductMindshare (%)
erwin Data Modeler8.0%
IBM Rational System Architect3.0%
Other89.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

"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 excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."
"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"Erwin Data Modeler is well organized, and the screen layout is intuitive."
"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"One of the best aspects of the tool is its reverse engineering capability."
"The tool is also very intuitive and easy to use."
"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 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 main advantage of the solution and its most valuable aspect is the customization of the meta-model."
"The solution is pretty stable."
"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 is not as robust as a data warehousing project I've been on in the past."
"I would like the solution to be more user-friendly to deploy."
"It has a very steep learning curve, limited support for NoSQL or streaming systems, and potentially a high licensing cost."
"The interface must be improved."
"I would like to see improved reporting and, potentially, dashboards built on top of that."
"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."
"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"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."
"We are not happy with this product and are not planning to continue with it."
"Some aspects of the user interface lack a common navigational or functional framework."
"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 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."
"Integration with all other software, like Microsoft, to facilitate an exchange, is not great."
"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."
 

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."
"Though the solution is not cheap, it's worth the money."
"There are two license options and the pricing is reasonable."
"The solution is expensive."
"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 primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
908,834 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Marketing Services Firm
7%
Manufacturing Company
7%
Government
6%
Financial Services Firm
15%
Comms Service Provider
10%
Manufacturing Company
9%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise40
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: August 2026.
908,834 professionals have used our research since 2012.