We performed a comparison between IBM Rational System Architect and IDERA ER/Studio 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."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."
"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 solution is pretty stable."
"It does the job."
"The most valuable feature of the solution is generating DDL (data definition language)."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"The tool is simple to use."
"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."
"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."
"This solution can be more user-friendly and easier to use, with better dashboards."
"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"What needs the most improvement are semantic lineage and usability."
"The screens are a bit outdated. They could use a new look and feel."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The only thing I had an issue with was licensing, and the support was very good."
"We would always like to see Repository performance improve, checking in and checking out."
Earn 20 points
IBM Rational System Architect is ranked 21st in Enterprise Architecture Management while IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 34 reviews. IBM Rational System Architect is rated 7.4, while IDERA ER/Studio is rated 8.4. The top reviewer of IBM Rational System Architect writes "Modeling is useful, but many features need improvement and technical support is lacking". On the other hand, the top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". IBM Rational System Architect is most compared with Sparx Systems Enterprise Architect and erwin Data Modeler by Quest, whereas IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and erwin Evolve by Quest. See our IBM Rational System Architect vs. IDERA ER/Studio 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.