We performed a comparison between erwin Evolve by Quest 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."By placing the data and the metadata into a model, which is what the tool does, you gain the abilities for linkages between different objects in the model, linkages that you cannot get on paper or with Visio or PowerPoint. That is a huge discriminator."
"There is a model behind it. It's really nice that the Evolve front-end, as it builds a website, keeps those relationships in mind. You can even go to a procedure and see all the applications that are related to it. Then you can go into that application and see all the standard operating procedures that that application is a part of. It's just very connected."
"Workgroup Repository collection of data models allows research across models without worry about platform incompatibilities and provides easy KPIs about corporate data assets."
"The initial setup was really straightforward and the deployment was done within one day."
"Evolve's reverse engineering ability is quite useful."
"The most valuable features for us are impact analysis, where I can easily visualize the impact of change."
"Forward and reverse engineering were valuable features."
"The ability to share and collaborate on the solution is its most valuable feature."
"Straightforward setup."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"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."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"We are able to document the data lineage and data flows of our data from one system to another."
"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."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"The most valuable feature of the solution is generating DDL (data definition language)."
"I would like it to be easier to make changes and then deploy them into production, especially when you have multiple web servers or front-ends. It would be nice to make a change and then have it propagate to the production servers in a more automated fashion."
"What they need to do is to consolidate more of their products. For example, I was just looking and I couldn't figure out what erwin DT is. It's on the website but it would help if they could put information together and make it more clear as to what products they have and how they work with other things."
"With the Excel importing, the "up to date" part is the challenge. If we had a real-time integration, we could keep things up to date for whatever kinds of change points we had. With Excel, it is more that you have to export from one system then import it to another, so it's better for data that doesn't change that often."
"There might be improvement required to better support some of the MPP databases for non-relational data structures and NoSQL databases."
"The solution needs to focus on allowing for more integrations."
"It could have had a more streamlined navigation. It seemed that when you went to the explorer panel, there were just so many different ways of doing the work that I could not remember, "How did I do this? How did I get to that point in that model to get back to it?" If I wanted to build a new one, where do I start? It just seemed like there was such a smorgasbord of ways of doing it that it was just overwhelming."
"I feel that the UML drawing capability needs to be improved."
"Business process modelling could be improved."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"This solution needs more precise documentation."
"The only thing I had an issue with was licensing, and the support was very good."
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"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."
"When building the relationships there should be a little more flexibility."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
erwin Evolve by Quest is ranked 9th in Enterprise Architecture Management with 19 reviews while IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 34 reviews. erwin Evolve by Quest is rated 7.8, while IDERA ER/Studio is rated 8.4. The top reviewer of erwin Evolve by Quest writes "Enables us to present data and objects visually, in diagrams, and to make them available via the web. Also enables web-based editing of data". 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". erwin Evolve by Quest is most compared with Sparx Systems Enterprise Architect, LeanIX, erwin Data Modeler by Quest, SAP PowerDesigner and Avolution ABACUS, whereas IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and LeanIX. See our IDERA ER/Studio vs. erwin Evolve 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.