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."The solution is excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."
"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."
"It is a scalable solution...The technical support team is fine."
"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’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."
"The data lineage feature is very valuable."
"There is absolutely no problem with the stability."
"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."
"The usability in general is good. The integration of uploading custom stencils is also very nice."
"It is pretty easy to use if you are looking for this type of solution."
"Visio is stable."
"What I like best about Visio is that it's flexible. Sometimes, if I need to draw quickly, I use Microsoft PowerPoint, but if I need icons, which Visio has, I use Visio. I also like that the solution gives me a much more powerful range of options."
"The product is stable."
"The solution is easy to understand with some hands-on experience."
"It's a very flexible solution."
"It is easy to use."
"There is a lack of local support in the China region."
"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."
"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."
"The interface must be improved."
"This is a very complex product."
"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."
"erwin is not as robust as a data warehousing project I've been on in the past."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"There is a limitation in Visio."
"When you use a BPA solution you can open an end-to-end process in one window, go down, or go up between layers to different places. You should be able to see descriptions of the steps of the process."
"It's not the easiest software to use. It's not user-friendly out-of-the-box."
"The price could be lower because it is too expensive in South America when paying in dollars or euros."
"The price could be better."
"Transferring data was one of the issues that I expected Visio to have resolved. I use the older version."
"Visio is not as scalable as other tools due to the proprietary restriction. You cannot customize it or scale it up like the way you do with Trello or Jira. Microsoft places restrictions on things that you can do with Visio."
"I would like to see the project planning element improved, although it won't happen because Microsoft deliberately made it worse."
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.