We performed a comparison between erwin Data Modeler by Quest and erwin Evolve by Quest 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 solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"We can create mappings in erwin and possibly data dictionaries."
"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."
"It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases."
"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."
"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."
"The feature that stands out for me is the ease of configuring objects and the screens to show them. It's really easy to add a new type of object in this reference. Creating a new type of object, using it, and evolving it a little bit in terms of what we can document about it are the main features that made us decide to use this provider."
"We use erwin Evolve to publish to the website. This allows us to enable publishing our website using parameterisation features. In a very fast, quick way, we can publish a table or chart onto a website."
"Evolve's reverse engineering ability is quite useful."
"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."
"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."
"I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"This is a very complex product."
"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."
"The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."
"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."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."
"Business process modelling could be improved."
"If it had fewer features to model all kinds of architecture, it would be less complicated."
"Add some ability to do conditional Visualization on the models and in reports (some ideas) – maybe as a specialized Theme or Diagram or Display."
"I would like to see an improvement in the output of the solution."
"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."
"There might be improvement required to better support some of the MPP databases for non-relational data structures and NoSQL databases."
"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."
"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."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while erwin Evolve by Quest is ranked 9th in Enterprise Architecture Management with 19 reviews. erwin Data Modeler by Quest is rated 8.6, while erwin Evolve by Quest is rated 7.8. 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 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". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and Avolution ABACUS, whereas erwin Evolve by Quest is most compared with Sparx Systems Enterprise Architect, LeanIX, SAP PowerDesigner, IDERA ER/Studio and Avolution ABACUS. See our erwin Data Modeler by Quest vs. erwin Evolve by Quest report.
See our list of best Enterprise Architecture Management vendors and best Business Process Design 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.