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.7%, up 9.9% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 24.0% mindshare, up 18.8% 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

"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"There is absolutely no problem with the stability."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"It has centralized storage so that a data model can be shared by different teams."
"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 data lineage feature is very valuable."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"One of the best aspects of the tool is its reverse engineering capability."
"I like how all the contacts in my chart are linked to LinkedIn. That's what makes it really easy for outreach and for making sure we have all the contacts right there in front of us when we need to."
"I really like the drag and drop feature because it makes the work easier. It is very easy to use. All the pieces are very good. All the icons and all the fields are available in the left panel. So, I just click, drag, and then edit a piece. When I showed it to my managing director, he was very inspired, and he also got a premium account for himself."
"Lucidchart is a 10 out of 10 when it comes to documenting things such as processes, systems, and new teams. It's just so user-friendly. The fact that even if you've never used Lucidchart, if you take a template and adapt it, you'll inevitably find something to fit your needs, but it's also perfect for building from scratch. It's the ease of use, clarity, and the different functionalities that make it incredibly useful."
"The interface is really good and it is very easy to use."
"The most valuable feature is the ease of use, and just being able to drag and drop."
"One of the features that I really like is the collaboration aspect of it. During the pandemic, it's very important that we're able to collaborate virtually."
"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 sticky notes are among the most valuable features. Also, the fact that it has templates so that I don't have to do things myself, starting from scratch, is very helpful. In addition, it's really easy to use. You can add stuff by clicking, without having to go to the options. You just click on something and the options you can use appear."
 

Cons

"As someone who has used it for a long time, I have seen stability vary from version to version."
"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 would like the solution to be more user-friendly to deploy."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"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 erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"I would like the solution to be less rigid in terms of its theory."
"One of the best aspects of the tool is its reverse engineering capability."
"Lucidchart subset their older components or something like that had happened. I don't entirely know the totality of it, but we were forced to upgrade to a different integration with Lucid than what we had. I've had a lot of frustrations with that because I've lost a lot of diagrams. I can't get them back and I'm getting pop-ups that are showing me that our data will be loading and I can't run four or five years of my engineering diagrams"
"I don't know if I will be able to add some animations if I want to. I believe the problem may be the program's process flows but if I want to transfer it into a PPP or any other document, I can only do image transfer."
"When you log in the first time, they ask you a lot of questions, such as what are you going to use it for. Half of the things weren't applicable to me. I couldn't see the skip button, so I picked random things because none of the given options was applicable to me. It is a tech startup, and I am in a consultant role. I use it for a variety of things, but the questions were tailored for HR professionals who are creating org structures or IT professionals who are doing data flow diagrams. What if I do both of them depending on the project I'm working on? I just felt that I am wasting time with those questions and just wanted them to stop asking me these questions and get into charting."
"I've had an issue is when you create, let's say, a rectangle box. You can write some text in it and give it a name, and, depending on how you shape the size of the box, the text will rearrange itself to fit. That is, except if your box is very, very narrow, but very long, like a long, narrow rectangle in a vertical position. In this case, the text will always go out of the rectangle."
"This might already be a feature, but I remember sometimes when we're just all viewing, if you accidentally click, then there's an arrow that pops up, and you have to go back and delete it. A lot of times there are accidental arrows being drawn when really we're just trying to present to each other."
"I would like to have more text boxes to write more comments so I can write a small note below a picture. I would like some flexibility."
"I would really like to be able to set default appearance settings for new documents because I have a set of appearance settings that I always use. I end up setting that manually every time. There may be a way to do that, and maybe I am not able to find it. This is my only major point of feedback for improvement. There are other little nitpicky things, such as being able to lock layers without them looking like a big red line around them would be nice, but every graphic design software does that, so I understand why they have that. All my concerns are nitpicks. They're not big."
"When I download a flowchart as a PDF file, it breaks it up. I would like to see the continuous display of flow charts, even if they are larger than one page."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool."
"Though the solution is not cheap, it's worth the money."
"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 don't specifically know what we're paying now. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. In the mid-2000s, it was something like 1,200 AUD a seat. I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite."
"Likewise, the solution is a little pricey."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"There are no costs in addition to the standard licensing fees."
"We signed up for the month-to-month and it charged us all at once for the whole year. I believe we signed up for the $7.99 one. I think that was the price."
"The price of this product is a little bit high. It is probably 20% higher than what I expected to pay for such a solution."
"The pricing is very reasonable, and they have a free trial available that you can play with."
"I was using the free version of Lucidchart, which was very helpful."
"I was using the paid version, but at $12 USD per month, I canceled the plan because it was a little bit too expensive for me."
"The pricing is very competitive. It is more cost-effective than some competing products, such as Visio."
"Pricing comes in at about $100 for a year's subscription, which is very reasonable if this is a tool that you will use more than once."
"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.
850,671 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
Financial Services Firm
13%
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: May 2025.
850,671 professionals have used our research since 2012.