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."Evolve's reverse engineering ability is quite useful."
"We can efficiently deploy business models into the databases and generate SQL scripts."
"The ability to share and collaborate on the solution is its most valuable feature."
"The initial setup was really straightforward and the deployment was done within one day."
"I really liked that it mapped out processes and was able to attach the data model to the appropriate process. You could map out the process, then when you got down to a specific couple of data elements, you could attach the table in the database that supported that process. You could connect it with erwin Data Modeler for that."
"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."
"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."
"Evolve is like a tank. You can do whatever you want with the solution, but you need to customize it. I think that it's not very aligned with the framework for enterprise architecture. MEGA is focused on these enterprise architectures, but it's only for that. With Evolve, you can do everything you want with professional services."
"We are able to document the data lineage and data flows of our data from one system to another."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"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."
"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."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"They need to develop Evolve's user experience. For example, MEGA has a useful client view that helps with impact analysis. MEGA provides information about the processes, services, infrastructure, and portfolio of applications in one central view. It lets you see the periphery and relationships among components. This view is impressive, and Evolve doesn't have it."
"If it had fewer features to model all kinds of architecture, it would be less complicated."
"They have improved the search engine a little bit but it can always be improved more. The more data you put inside it, the more you want to use it."
"There might be improvement required to better support some of the MPP databases for non-relational data structures and NoSQL databases."
"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."
"The solution's integration capabilities with other tools in our system has not been all that well done. We have people who use ARIS, who use System Architect and, of course, Visio. erwin has very limited ways to import and export from those kinds of tools. It's not a very easy thing to do."
"Add some ability to do conditional Visualization on the models and in reports (some ideas) – maybe as a specialized Theme or Diagram or Display."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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 needs the most improvement are semantic lineage and usability."
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"When building the relationships there should be a little more flexibility."
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 33 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.