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 Aug 19, 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
3rd
Average Rating
8.6
Reviews Sentiment
6.6
Number of Reviews
40
Ranking in other categories
Business Process Design (9th), Data Governance (14th)
IBM Rational System Architect
Ranking in Enterprise Architecture Management
20th
Average Rating
7.4
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.8%, down from 10.7% compared to the previous year. The mindshare of IBM Rational System Architect is 2.0%, up from 2.0% 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.8%
IBM Rational System Architect2.0%
Other89.2%
Enterprise Architecture Management
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
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.
GM
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'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."
"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."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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."
"Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."
"The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc."
"The principal feature that I liked is that the solution has a very graphic interface."
"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. It's easy to work with."
"The solution is pretty stable."
 

Cons

"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"erwin is not as robust as a data warehousing project I've been on in the past."
"We can only get licenses through partners."
"The solution's reporting side needs to be improved."
"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."
"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."
"This is a very complex product."
"It does not have a cloud application."
"This solution can be more user-friendly and easier to use, with better dashboards."
"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."
"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 are no costs in addition to the standard licensing fees."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"There are two license options and the pricing is reasonable."
"The price should be lower in order to be on the same level as its competitors."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"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."
"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."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
868,787 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
Manufacturing Company
18%
Financial Services Firm
12%
Government
10%
Computer Software Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise3
Large Enterprise29
No data available
 

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?
I do not recall the pricing from about a year and a half ago, but it seems reasonable.
What needs improvement with erwin Data Modeler by Quest?
erwin Data Modeler could improve its UI as it still feels old school and not very modern. There are many features, and I would expect good documentation detailing each feature, including when and h...
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: September 2025.
868,787 professionals have used our research since 2012.