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.4
Reviews Sentiment
5.9
Number of Reviews
47
Ranking in other categories
Enterprise Architecture Management (2nd), Business Process Design (7th), Data Governance (9th)
Lucidchart
Average Rating
8.6
Reviews Sentiment
8.1
Number of Reviews
62
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.4%, down 11.2% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 22.3% mindshare, down 22.6% since last year.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler8.4%
LeanIX9.5%
Sparx Systems Enterprise Architect8.6%
Other73.5%
Enterprise Architecture Management
Mind Mapping Software Market Share Distribution
ProductMarket Share (%)
Lucidchart22.3%
Visio24.8%
draw.io13.6%
Other39.3%
Mind Mapping Software
 

Featured Reviews

Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.
Faizuddin Shaik - PeerSpot reviewer
Principal Application Engineer at a financial services firm with 10,001+ employees
Visual planning has improved migration mapping but now needs broader cloud icon support
In my opinion, the best features Lucidchart offers include the toolkits they provide, such as the icons for AWS. These features allow us to use proper service icons rather than simple plain boxes for everything, helping us effectively map out the actual services instead of getting confused. The AWS icons and toolkits make my diagramming process easier and more effective because it is easy to explain and show to my customers which service is being used for a particular component. For instance, when using Amazon S3 for object storage or Amazon RDS for SQL, I can clearly indicate those services. If I need to show containers, I can pick those specific icons to demonstrate that, making it easier than reading it within a box. Lucidchart also offers other specific UML diagrams that I could use, including class diagrams, before I get into the code-level details.

Quotes from Members

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

Pros

"The product lets us import different types of models from various databases."
"The product allows us to reuse entities and attributes."
"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."
"One of the best aspects of the tool is its reverse engineering capability."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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."
"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."
"We can create mappings in erwin and possibly data dictionaries."
"In general, the usability is great. You have a ton of customization options with different colors, different borders, different thicknesses of lines, different types of arrows, et cetera. There's so much variety. You can really make a chart with all sorts of color-coding, and color charts in different colors, link them together, for example, or use different types of arrows for different types of links between the chart elements. That variety, while not a specific feature, is really useful. If you want to make a chart, you can basically do anything."
"Documenting things such as processes, systems, and new teams has been my primary use case. Lucidchart is really, really valuable for its ability to create a process chart from start to end. The web app makes it easy because everything is similar to other tools like Visio but Lucidchart feels a little bit more intuitive. It has been easy to use the web app. I definitely have learned a lot about how to bring in my own graphics or images in place of some of the shapes and I'm able to create and use the arrows within the processes, so it definitely has been useful for me."
"There is no alternative to Lucidchart if you want to describe a five-step process with bullet points. I believe every person who ever worked with PowerPoint on any type of documentation and then thought about which tool would actually help to describe what they're trying to do but without the words, would come up with Lucidchart."
"We are using Lucidchart a lot for documenting things, such as processes, systems, new teams, etc. Its ability to document processes is great. Some of the major pluses are the sheer number of templates and the flexibility in the types of things that you can document. This is a benefit because we are able to structure it in whatever format we want. So, we can take a template that maybe was designed for something different and not have to create it from scratch. We just modify it for our purposes."
"The usability is very nice in terms of flowchart components that are available."
"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 collaboration, hands-down, is the top feature. It is valuable because our company doesn't believe in working in silos... While I may be the one leading the efforts, it's very important that my team gets buy-in on decisions being made when we're designing. It's critical, especially in this virtual environment, when we're not in an office to have a team meeting and able to whiteboard something. Lucidchart is an extremely useful tool for our team."
"The swimlanes feature is one that I use a lot. I have used swimlane diagrams to create business process flows and I think that it does the job pretty well."
 

Cons

"The price should be reduced."
"I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"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."
"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."
"As erwin Data Modeler files get larger, the response time really slows down, and when I have multiple files open I sometimes get a glitch where a lot of the text fields get solid black and the first eight characters of column names might be blacked out with a rectangle."
"The solution's model mark could be better because it crashes sometimes."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"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."
"The UML diagram that it gave me initially was a huge flow with a bunch of UML tables, and I wasn't going to need that many. If it was a more simple linkage between the tables then it would be easier to finish projects, instead of having to select unnecessary tables and delete them."
"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."
"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."
"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."
"I am not quite sure what different functionalities it provides as well as the difficulties other people are facing. When I have a better understanding of the solution, I will increase my rating of it. No solution is perfect, so I am sure that I will be facing some problems in the future."
"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."
"If it could be a little more visual, in terms of being able to make it stand out a little bit more, then that would be helpful."
 

Pricing and Cost Advice

"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"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 tool is expensive."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"There are no costs in addition to the standard licensing fees."
"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."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"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."
"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."
"The price and licensing are good."
"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."
"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."
"I pay $95 a year for it. It seems like a reasonable price."
"The pricing is very reasonable, and they have a free trial available that you can play with."
"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
881,707 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Manufacturing Company
8%
Government
8%
Performing Arts
5%
Financial Services Firm
13%
Manufacturing Company
9%
Government
7%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise34
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise14
Large Enterprise25
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
Regarding pricing, I am unsure what the exact price is for erwin Data Modeler, but I believe it is not useful for an individual. It is more targeted toward an enterprise level since organizations l...
What needs improvement with erwin Data Modeler by Quest?
I write code and I write code accessing erwin Data Modeler's API, the Application Programming Interface, so that I can use Excel to update erwin Data Modeler and then get those updates and put them...
What is your primary use case for erwin Data Modeler by Quest?
I work for CVS with a pretty big database as a data modeler on the PBMs, the Caremark PBM side, which is the Pharmacy Benefits Manager. There's a retail side too for all the stores, but our data wa...
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 is your experience regarding pricing and costs for Lucidchart?
In terms of pricing, setup cost, and licensing, I feel that Lucidchart has provided us with good plans, as we have purchased it through AWS Marketplace. We got team plans that run around nine to te...
 

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, Quest Software, MEGA International and others in Enterprise Architecture Management. Updated: February 2026.
881,707 professionals have used our research since 2012.