Try our new research platform with insights from 80,000+ expert users

Lucidchart vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

erwin Data Modeler by Quest
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (3rd), Business Process Design (9th)
Lucidchart
Average Rating
8.6
Reviews Sentiment
8.1
Number of Reviews
54
Ranking in other categories
Mind Mapping Software (2nd), Visual Collaboration Platforms (3rd)
 

Mindshare comparison

erwin Data Modeler by Quest and Lucidchart aren’t in the same category and serve different purposes. erwin Data Modeler by Quest is designed for Enterprise Architecture Management and holds a mindshare of 10.9%, up 9.9% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 24.3% mindshare, up 18.2% since last year.
Enterprise Architecture Management
Mind Mapping Software
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.
MichaelChirinian - PeerSpot reviewer
Intuitive, integrates well, and is a great way to change text into visual ideas
I'm not a super user, and there might be a way of doing it that I haven't explored, but I was looking for some specific icons that are just standard icons, and I found the icon library to be very focused on architecture icons. It didn't have as many standard or generic icons. Another thing that somewhat irritated me is the fact that there is a paste function in the menu, but when you right-click and select paste, it tells you that you can't use paste. You must press Command-V or Apple-V to paste. They give you a menu option to paste, but every time you use that, they say, "We don't accept it." On top of that, normally, you'd have an option for paste or paste values, but when you use the paste function, you don't have that capability. So, to copy text from one place, I have to use Command-V to paste it, but if I don't like the format, I've got to go back and do copy style and then paste style on top of that. It is a small detail, but when you're doing diagrams, it is annoying that they don't support paste values. It is a small irk. I'm not penalizing it, and I still think it is a five-star product. In terms of other bigger things, I don't really have any comments or criticism so far.

Quotes from Members

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

Pros

"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."
"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"One of the best aspects of the tool is its reverse engineering capability."
"The principal feature that I liked is that the solution has a very graphic interface."
"The product lets us import different types of models from various databases."
"Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."
"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."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"Lucidchart is very visual in nature, and it is something that we do use extensively for stakeholder mapping, for example. If you want to build graphs for things like who the decision-makers are in a particular organization, Lucidchart can be used for that."
"The flow chart is most valuable. It is a very user-friendly and simple-to-use product. Quite quickly, I was able to understand how to use it and just get on with my process flow."
"The most valuable feature is the ease of use, and just being able to drag and drop."
"I love the simplicity and how clean all the different boxes, arrows, and charts can be. Especially with something complicated like our sales flow, it could be really easy to be all cluttered and everything like that, but my favorite feature is how clean it is, how straightforward it makes our flow look, and how easy it is to understand. Lucidchart accommodates both Mac and PC users which is important to us because at my company right now, our sales floor and then every other computer we have as a company is a Mac, but a lot of our employees actually have PCs and Android as well. So it's really beneficial because if we're ever on the go or we need to make a change, it's versatile and is open for both Mac and PC."
"I love the fact that you can just integrate a drawing into Google Slides. I build a lot of visuals in Lucidchart, and then, rather than sharing them directly from Lucidchart, I just build Google Slides decks for senior management, and I link the Lucidchart on the cloud version to a slide image. That makes it easy. This way, I can build in one tool and show in another."
"The interface is easy for a layperson to use and adapt to."
"It is important to me that the solution accommodates both Mac and PC users because the developers in our company use Mac, then the business people use Windows. The technical people create the technical architecture using Lucidchart. So, it is important that it is compatible with both the systems."
"I've been using Lucidchart for quite simple things, but it's definitely much easier making process maps using Lucidchart than it is using Google Docs for basically everything. It's much simpler in terms of how easy it is to use Lucidchart. The way that you can get the arrows on the flow charts, based on the process mapping, you can drag the arrows from one box to another and it automatically shows you where you can put it. It makes decisions for you in terms of if you have a decision diamond, then the line is automatically a yes or no. This just makes it so much easier."
 

Cons

"It does not have a cloud application."
"I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else."
"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."
"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."
"One of the best aspects of the tool is its reverse engineering capability."
"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 reverse engineering in Oracle Databases needs improvement, as there are issues."
"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."
"In terms of improvement, there can be more templates. There are good templates but there could still be more."
"When you want to add text to a connector arrow, I have not figured out how to position the text vertically. It always wants the text to stay horizontal."
"The main improvement I would like to see is for them to improve the help section on the flow charts or on the formatting."
"When my colleague initially tried to edit the file that I shared with him, he had some trouble. This is something that should be improved."
"It would be nice to be able to import not just contacts from Salesforce but also leads. In the beginning, when I was still learning the ropes and my way around it, I couldn't find such an option. There might be an option, but I just don't know about it."
"The communication with sales has been pretty poor. They have been spotty in terms of response. So far, that has been our problem with it. We were in contact with one of their representatives, but he just kind of disappeared one day and we couldn't find him anymore. He has not been responsive to email."
"In terms of improvement, they should make it very clear, whether it's a single A4 page or two A4 pages, it should be mapped out. Either I don't know how to use it, or it's not there, but having to stick to margins so I can see what's going to be on different pages when I print it or move it to a PDF has been my only challenge so far."
"What I do find extremely frustrating is that when I've sent the sheet to non-license holders, you have to create an account. You create a username and password. The path taken to create that account is so confusing that everyone thinks that they have to give their credit card number, and then they're reluctant. They don't want to go through the sheet."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"Likewise, the solution is a little pricey."
"Though the solution is not cheap, it's worth the money."
"The solution is expensive."
"The price should be lower in order to be on the same level as its competitors."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
"I was using the free version of Lucidchart, which was very helpful."
"The price was low enough to make me think that it was fine, I'll go for it. I think it's $80 or so. It's not too expensive."
"We chose Lucid based on the price comparison between it and draw.io... Lucidchart was about 15 percent cheaper per user... I was surprised to learn that it came with a separate subscription model and was not included in my existing Lucidchart subscription."
"I have only used the trial version and have not yet paid for it, or explored the pricing options."
"I had a quick glimpse of it. It was about 100 Canadian Dollars a year for just me. I don't know if there are any additional costs."
"The pricing is very competitive. It is more cost-effective than some competing products, such as Visio."
"I have a subscription as an individual user for one year, and it is not expensive."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
845,406 professionals have used our research since 2012.
 

Top Industries

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

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 is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...
LucidChart vs LucidSpark for brainstorming sessions over Zoom
Hi @Krista Thompson ​ - Yes, LucidSpark is a much more nimble and, in some ways, user-friendly tool than LucidChart. LucidSpark is designed to do a better job managing multiple users participating ...
Do you recommend Lucidchart?
I definitely recommend Lucidchart. I feel it is one of the top visual collaboration platforms that’s available on the market. Out of all the solutions I have tried, it is by far the best for diagra...
 

Also Known As

erwin DM
No data available
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Google, Salesforce, Adobe, Whirlpool, Uber, Wal Mart, Pearson, Twitch, Riot Games, Western Union, Trimble, Starbucks
Find out what your peers are saying about SAP LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: March 2025.
845,406 professionals have used our research since 2012.