We performed a comparison between erwin Data Modeler by Quest and Visio based on real PeerSpot user reviews.
Find out in this report how the two Business Process Design solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"The product lets us import different types of models from various databases."
"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 solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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."
"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."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"The diagramming and swimlane features allow for separating business functions."
"Very interactive with an intuitive interface."
"It's a very meat and potatoes type of product and isn't overly designed. It's very easy to find your way through the solution, as it's not too complicated."
"The fact that you could program in VBA is most valuable."
"I like to use Visio because it gives me a quick view of the things I had to put in a model for a company. I don't use it as an interface, though."
"It's my understanding that the initial setup is straightforward."
"It is stable. I have never experienced any issues."
"It is very easy for people to start using this tool, and we can import Visio templates that are already published by vendors such as Azure without any issue."
"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"There is a lack of local support in the China region."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"The solution's model mark could be better because it crashes sometimes."
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"The solution should have better integration capabilities with MacOS and Linux."
"As a user, it, unfortunately, lacks recognition by Microsoft products."
"The price could be better."
"The only downside to Visio is the learning curve."
"I would like to see traceability. It doesn't have it. You cannot find one object amongst several sheets of Visio diagrams."
"I would like to see Visio become some kind of enterprise architecture, which it is not."
"Something that needs to improve, is the interface interaction with other tools."
"The export and import functionality from Visio to other tools and the import and export functionality from other tools to Visio are areas with shortcomings."
erwin Data Modeler by Quest is ranked 9th in Business Process Design with 37 reviews while Visio is ranked 1st in Business Process Design with 101 reviews. erwin Data Modeler by Quest is rated 8.6, while Visio 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 Visio writes "A software for drawing a variety of diagrams which include flowcharts, org charts, building plans, floor plans, data flow diagrams". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Lucidchart, Sparx Systems Enterprise Architect and AWS Well-Architected Tool, whereas Visio is most compared with Sparx Systems Enterprise Architect, Bizagi, Visual Paradigm, IBM Blueworks Live and ARIS BPA. See our Visio vs. erwin Data Modeler by Quest report.
See our list of best Business Process Design vendors.
We monitor all Business Process Design 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.