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."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."
"One of the most valuable features is the website that sits on top of the database. There's a database of objects and how they are related, and you can make views and diagrams and visual elements out of that information on the website. The website is the part that is called Evolve and we use the Evolve Designer and publish the website out to our employees. They can click around and navigate and search, etc."
"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."
"Forward and reverse engineering were valuable features."
"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."
"The ability to share and collaborate on the solution is its most valuable feature."
"The most valuable features for us are impact analysis, where I can easily visualize the impact of change."
"Workgroup Repository collection of data models allows research across models without worry about platform incompatibilities and provides easy KPIs about corporate data assets."
"Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."
"The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"The tool is simple to use."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"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."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"I would like to see an improvement in the output of the solution."
"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."
"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."
"I feel that the UML drawing capability needs to be improved."
"The way that we are using it for application management, we have several KPIs. We want to follow and monitor them regarding a number of solutions. We cannot calculate this today. We would like real-time calculations along with the KPIs in order to improve the user experience. We would like the tool to be able to display this, not only as signals, but as charts."
"Evolve is primarily focused on the entity's licenses diagrams, but it would be nice if erwin could integrate case development, so that it shows the ER diagram plus certain inputs on the use cases and how the data is used. That deviates somewhat from the overall scope, so maybe they could call it a different product."
"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."
"This solution needs more precise documentation."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"The screens are a bit outdated. They could use a new look and feel."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"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."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"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."
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.