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."erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"The data lineage feature is very valuable."
"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."
"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."
"I like that once you create what you need, you can group that, at least within that drawing, and you have access to that new stencil object or that custom object throughout that drawing."
"The product is stable."
"Visio makes it easier than with other tools to do such tasks as changing things or coming up with one's own visual style for presentation purposes."
"Visio has allowed us to create good diagrams for our technical employees to consume. The solution provides templates, is straightforward, and has tools for the easy creation of diagrams."
"I like all the features. I go online, and everything pops there. It is in the cloud, and everything is there. Even if there is a crash, everything is still there. I don't lose anything. That's what is the most valuable and likable. It is really a professional solution for designing. The designs look really nice in the PDF."
"The interface is the most valuable aspect of this solution."
"They provide continual enhancements which are always very useful."
"Visio is stable."
"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."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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."
"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."
"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"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."
"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."
"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."
"It should be easier to transition into a new version without having to spend so much time in just one area."
"It could use easier custom icon sets."
"The simulation is an area that requires improvement."
"The solution should be included in Microsoft Office 365. For some reason, it's not. It should be bundled in with everything else."
"There is a limitation in Visio."
"The solution's initial setup was a bit complex for me."
"Occasionally, the automation feature that helps you easily add the "next step" goes crazy and it will move a bunch of stuff."
"The control flow feature needs to be improved. I compared Visio to Bizagi and found that control flow is better with Bizagi. The improvements that can be made to the solution depends on the user."
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.