We performed a comparison between erwin Data Modeler by Quest and IBM Rational System Architect based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"We can create mappings in erwin and possibly data dictionaries."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"It is a scalable solution...The technical support team is fine."
"The principal feature that I liked is that the solution has a very graphic interface."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"The user interface is good. It's both clear and comprehensible. It's easy to work with."
"We have seen ROI with this solution over the years that we have used it."
"The solution is pretty stable."
"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."
"I would like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."
"This is a very complex product."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"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."
"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."
"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."
"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."
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 20th 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, Visio, Lucidchart and Sparx Systems Enterprise Architect, whereas IBM Rational System Architect is most compared with Sparx Systems Enterprise Architect, SAP PowerDesigner and MEGA HOPEX.
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.