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

Lucidchart vs erwin Data Modeler 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
Average Rating
8.6
Reviews Sentiment
6.6
Number of Reviews
40
Ranking in other categories
Enterprise Architecture Management (3rd), Business Process Design (9th), Data Governance (14th)
Lucidchart
Average Rating
8.6
Reviews Sentiment
8.1
Number of Reviews
56
Ranking in other categories
Mind Mapping Software (2nd), Visual Collaboration Platforms (3rd)
 

Mindshare comparison

erwin Data Modeler and Lucidchart aren’t in the same category and serve different purposes. erwin Data Modeler is designed for Enterprise Architecture Management and holds a mindshare of 8.8%, down 10.7% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 24.8% mindshare, up 21.6% since last year.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler8.8%
LeanIX13.1%
Sparx Systems Enterprise Architect11.3%
Other66.8%
Enterprise Architecture Management
Mind Mapping Software Market Share Distribution
ProductMarket Share (%)
Lucidchart24.8%
Visio29.6%
draw.io16.0%
Other29.599999999999994%
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.
Michael Verruto - PeerSpot reviewer
Visual approach facilitates clarity and process efficiency in complex real estate tasks
I haven't done much with Lucidchart's integration with other popular apps such as Teams, though one of my colleagues mentioned it can be added. This has sparked my interest to look into integration with Excel and Word, though we haven't implemented these features yet in our less than a year of operation. I access Lucidchart from multiple devices, including iPhone, iPad, and PC desktop. Our PCs are all laptops, so we can work remotely. I've collaborated with people from home on my iPad while they were on their laptop, though this isn't our routine behavior. I would recommend Lucidchart to others, but I'd also recommend exploring other options. It depends on what your fit and feel is for what you're trying to accomplish. For heavy users or technical users, Lucidchart might be very appealing. It has more capabilities than I'm currently using. The Highway Bridge Maintenance group, who are familiar with Agile processes, speak positively about it. For average users, they might find similar functionality in Miro or other less expensive alternatives. Overall Rating: 9 out of 10

Quotes from Members

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

Pros

"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"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."
"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."
"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"The interface is very good and easy to use. We don't need documentation on how to use it. It is self-explanatory, which is very convenient for a new user."
"Its ease of use is most valuable. As compared to draw.io, connecting the lines and doing things like that are much easier in Lucidchart. It has been great for some of the process flow diagrams and data flow diagrams. I can export these diagrams as PDFs and share them with team members."
"The interface is very user-friendly and it is not a hassle to use the site at all. They did a really good job in that regard."
"The ability to have more than one person editing at the same time is the most valuable feature. You can have one diagram and have multiple users on it at the same time. We haven't been able to do that on other software. So that's the main reason we moved to Lucidchart."
"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."
"The most valuable features are the different templates that they have already created, as well as all the different shapes you can use in the process charts because each shape stands for a different element or thing that's being done. It's easy to distinguish between different steps using the already set-out shapes."
"The usability is very nice in terms of flowchart components that are available."
"It is a very effective tool for documenting processes and using it has improved our efficiency significantly."
 

Cons

"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."
"erwin is not as robust as a data warehousing project I've been on in the past."
"This is a very complex product."
"I would like the solution to be more user-friendly to deploy."
"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
"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."
"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."
"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."
"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."
"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."
"There is a basic function that I struggle with, in the interface, which is having to switch between the editing and navigation modes. A lot of clicks are required when switching between edit and navigation modes and I think that many could potentially be avoided by handling the tasks at the same time."
"One area for improvement is the fact that I had to create two sheets. I had to create a process flow diagram, and I had to create a timeline. I wasn't able to do that in one sheet. If they could add that kind of feature, where you could input a timeline and different types of templates into one worksheet, that would be really useful. I had to include two and then cut and paste, and that was an extra step for me."
"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'm not sure if this feature is already there, but it would be good if we can import a cloud database in the web version."
"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."
"Lucid should create some proper documentation and video tutorials to demonstrate the capabilities of the product to new users. It should explain everything that it offers and everything that it can be used for."
 

Pricing and Cost Advice

"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"There are two license options and the pricing is reasonable."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"There are no costs in addition to the standard licensing fees."
"Though the solution is not cheap, it's worth the money."
"Likewise, the solution is a little pricey."
"The solution is expensive."
"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."
"The pricing is very reasonable, and they have a free trial available that you can play with."
"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."
"I have a subscription as an individual user for one year, and it is not expensive."
"There is a nominal charge for the paid version of the product. They have a free version available and from what I could see, there was not much difference between it and the pro version."
"Pricing-wise, it is pretty fair. I don't really know what group pricing looks like, but right now, I pay $10 a month for my Lucid subscription. One thing I would say is that I do worry about my bosses being okay with paying $10 a month for every single employee because we would have around 20 people. It makes me a little nervous about whether they are going to pay $200 a month for people to be able to use this software. At the same time, from where I'm sitting, it's totally worth it. We save a thousand dollars from using this software. It's still a no-brainer."
"I have only used the trial version and have not yet paid for it, or explored the pricing options."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"I pay $95 a year for it. It seems like a reasonable price."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
872,655 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
Financial Services Firm
13%
Manufacturing Company
9%
Computer Software Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise3
Large Enterprise29
By reviewers
Company SizeCount
Small Business23
Midsize Enterprise14
Large Enterprise21
 

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?
I do not recall the pricing from about a year and a half ago, but it seems reasonable.
What needs improvement with erwin Data Modeler by Quest?
erwin Data Modeler could improve its UI as it still feels old school and not very modern. There are many features, and I would expect good documentation detailing each feature, including when and h...
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...
What needs improvement with Lucidchart?
The system is a bit clumsy when it comes to stylizing to match corporate imaging styles. In real estate, we need everything to have the same look and feel as our materials. Beyond dropping a logo i...
 

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, Quest Software and others in Enterprise Architecture Management. Updated: October 2025.
872,655 professionals have used our research since 2012.