We performed a comparison between erwin Data Modeler by Quest and IBM Rational System Architect based on real PeerSpot user reviews.
Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It has centralized storage so that a data model can be shared by different teams."
"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 solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"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."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"There is absolutely no problem with the stability."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"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 solution is pretty stable."
"The user interface is good. It's both clear and comprehensible. It's easy to work with."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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 solution's reporting side needs to be improved."
"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."
"We can only get licenses through partners."
"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."
"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 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."
"The solution needs to better integrate with other products, like Microsoft."
"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."
"This solution can be more user-friendly and easier to use, with better dashboards."
Earn 20 points
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while IBM Rational System Architect is ranked 21st in Enterprise Architecture Management. erwin Data Modeler by Quest is rated 8.6, while IBM Rational System Architect is rated 7.4. The top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". On the other hand, the top reviewer of IBM Rational System Architect writes "Modeling is useful, but many features need improvement and technical support is lacking". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Lucidchart, Visio and Sparx Systems Enterprise Architect, whereas IBM Rational System Architect is most compared with Sparx Systems Enterprise Architect. See our IBM Rational System Architect vs. erwin Data Modeler by Quest report.
See our list of best Enterprise Architecture Management vendors.
We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.