Visio vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Business Process Design
9th
Average Rating
8.6
Number of Reviews
37
Ranking in other categories
Enterprise Architecture Management (3rd), Database Design (1st)
Visio
Ranking in Business Process Design
1st
Average Rating
7.8
Number of Reviews
100
Ranking in other categories
Mind Mapping Software (1st)
 

Market share comparison

As of June 2024, in the Business Process Design category, the market share of erwin Data Modeler by Quest is 2.1% and it decreased by 29.7% compared to the previous year. The market share of Visio is 12.1% and it decreased by 4.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Business Process Design
Unique Categories:
Enterprise Architecture Management
13.2%
Mind Mapping Software
35.7%
 

Featured Reviews

GB
Oct 2, 2023
An easy-to-deploy data modeling solution that allows users to reuse entities and attributes
We use the solution for data modeling We believe that the solution would help provide some structure to our data modeling and data design practices. The product allows us to reuse entities and attributes. Whether we're working on a conceptual or logical model, once we have defined them, we can…
Martin Zwarthoed - PeerSpot reviewer
Mar 1, 2024
Provides a lot of flexibility in writing graphs and customizing them and has many features compared to its competitors
I use the solution to make graphs and schemas for infrastructure, application, and documentation We need proper documentation. The tool helps us during the project initiation to visualize things. I have used it for so long that it is the product that I can work my best with. It has a lot of…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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."
"It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"It is a scalable solution...The technical support team is fine."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"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."
"Architecture modeling software with satisfactory standard features. It's also stable and effective in facilitating communication with others."
"What I like about it is that the templates are easily findable and usable, and they are usually created for other software packages. It seems to be pretty much widely adopted in the industry."
"The most valuable feature of Visio is diagram creation. If you have a presentation, you can create your data model using Visio."
"The product is stable."
"It's my understanding that the initial setup is straightforward."
"The most valuable features are process mapping and identifying responsibilities."
"The fact that you could program in VBA is most valuable."
"It is easy to use."
 

Cons

"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."
"The solution's model mark could be better because it crashes sometimes."
"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 am not so happy with its speed. Sometimes, it can have problems with connections."
"It does not have a cloud application."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"I would like the solution to be less rigid in terms of its theory."
"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"Indeed, Visio should progress beyond its current stage of solely drawing diagrams and transition into a more advanced phase, possibly integrating with different packages or aligning with Microsoft's offerings. It could potentially evolve into a comprehensive business process management solution, comparable to tools like Addis or Signavio, thereby competing in the realm of process management tools. It might be advantageous to explore functionalities such as process simulations or benchmarking, introducing simulators to discern potential bottlenecks or errors within complex flow diagrams. This addition would prove valuable for business analysts seeking insights into the intricacies of their diagrams, aligning with the evolving trends observed over the past six years."
"The solution could improve by making it more modern."
"An area for improvement in Visio is pricing. It's a costly tool for my company because it only uses Visio occasionally."
"Its integration with other vendors can be better and support for other formats. For example, when we import a JPEG, we cannot customize it. Similarly, we can't utilize the BPML kind of diagrams."
"The Auto-Align has improved significantly from the previous release; however, it still jumbles the model if your process diagram has a fair degree of complexity."
"The solution's initial setup was a bit complex for me."
"Something that needs to improve, is the interface interaction with other tools."
"It would be nice if there is a database behind it. We have looked into this functionality, but all of the other solutions that have a database are very locked down, and you have to use them their way. You can't define your own stuff. For example, we have a system X, and I want to define system X myself and have it available. If I am ever going to make a change to system X, I want to pull up all the drawings that are associated with system X. I want to be able to search and pull all those drawings. Visio should have the ability to capture metrics associated with each step in the process. For example, based on a specific time, I should be able to link the data to a spreadsheet, which is kind of like the data analysis on the process."
 

Pricing and Cost Advice

"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"There is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."
"Pricing is very high compared to any other product."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"Though the solution is not cheap, it's worth the money."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"Likewise, the solution is a little pricey."
"The solution could be less expensive."
"Visio is included with our Microsoft enterprise license."
"We're in a Visio plan that is like $15 a month per user. At the moment, it is just the standard licensing fees that I'm aware of."
"We have about 10 to 15 people with Visio licenses in my company, but I wasn't involved in the direct negotiation of the prices since this was taken care of by my administrative office."
"I don't have any issue with the pricing. It has a subscription-based model, and the subscription is done on a yearly basis. Of course, we need internal approvals in place."
"My company does pay toward the licensing costs of Visio. It is a cheap product based on my experience, and since I purchased Visio for my own use."
"The price is reasonable for individual use but for an organization, the costs is high."
"We probably have an M-365 E3 license."
report
Use our free recommendation engine to learn which Business Process Design solutions are best for your needs.
787,104 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Government
10%
Computer Software Company
9%
Manufacturing Company
8%
Financial Services Firm
14%
Government
12%
Computer Software Company
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
How easy is it to migrate process flow charts (modeled using tools like Visio) into Bizagi?
I have been using Bizagi with a major project for a state government agency for about four years now. It is pretty straightforward to load in files that are BPMN 2.0 compliant. The option to load V...
What do you like most about Visio?
The diagrams Visio creates are quite impressive in the sense that we can cooperate with more colleagues in one task and see the flow of the process.
 

Also Known As

erwin DM
Microsoft Visio
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Thomas College, Hamburg Port Authority, Portigon AG, Conseil G_n_ral du d_partement des Hautes-Alpes, AAA Auto a. s., Commonwealth Financial Network, ICA, Abu Dhabi National Energy Company
Find out what your peers are saying about Visio vs. erwin Data Modeler by Quest and other solutions. Updated: May 2024.
787,104 professionals have used our research since 2012.