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

"Currently in the market, there is no competitor to erwin Data Modeler; everything is very powerful, such as performing reverse engineering from an existing database and deploying that on Databricks or Snowflake."
"I compare erwin Data Modeler with other solutions such as ER/Studio and believe it stands out as an enterprise-grade data modeling tool capable of serving different industries, such as finance, healthcare, and telecom."
"We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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."
"The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."
"I have used most of the modeling tools available, but I found that erwin Data Modeler is the most suitable data modeling tool in our current industry."
"The product lets us import different types of models from various databases."
"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."
"Lucidchart enables me to put down on paper what I was visualizing in my head. It makes it more shareable than only using words."
"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."
"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."
"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."
"It gives information about the roles and responsibilities of any architecture system and the exact system flow, business flow, or process flow. It also gives information about how the development team should take it forward. It shows the gap analysis in the flow charts and makes it easy to define the actor and his roles and responsibilities in the organization."
"The organizational charts for visualizing and understanding team hierarchies and relationships are the reason why we purchased the package that would allow me to do more with it. I tried to find all the cheap ways to do things but the ease of access and the already preset structure that Lucidchart had in place made it easier. Out of all the choices that I saw come across my desk, Lucidchart was the best and easiest choice."
"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."
 

Cons

"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."
"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"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."
"This is a very complex product."
"We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from individual desktops and get them into a single data model, when multiple data modelers are working on a particular project. It becomes a nightmare for the senior data modeler to bring them together, especially when it comes to recreating them when you want to merge them."
"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."
"I would rate the visualization feature in erwin Data Modeler a six out of ten because the visualization is somewhat poor and some of the features are not user-friendly."
"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."
"Sometimes, I have created charts with a lot of layers, which locks down parts of the chart and hides parts of the chart to edit it. If they have a better way to deal with specific layers when it gets complex, then that would be helpful. I would like to see something like an illustrator program, where they have a pallet of these layers that I want and don't want as well as being able to see each layer individually. That is the one thing that could be helpful."
"They should make it more user-friendly. The only option is either to use the existing template with already existing colors and gradients. If you want to do custom colors and gradients, then it's too complicated to use and should be simplified."
"The main improvement I would like to see is for them to improve the help section on the flow charts or on the formatting."
"It might already exist and I haven't used it, but in terms of improvement, I would like a hot-key system for some of the diagrams to auto-generate things a bit quicker to be able to produce charts a lot faster, or have more standard templates that you can just go to if you're trying to generate something quickly."
"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."
"Wireframing can be improved. For mock-ups and wireframing, only 10% of what is required is there. If they can develop this feature, it would be much better because it will then provide everything. Currently, we can design network diagrams, processes, etc., but we should also be able to do wireframing."
"The layering is something that can be improved because sometimes, it is confusing for me when I'm trying to get to the layer that I want to edit."
"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."
 

Pricing and Cost Advice

"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"erwin Data Modeler by Quest is an expensive solution."
"Though the solution is not cheap, it's worth the money."
"There are no costs in addition to the standard licensing fees."
"The price should be lower in order to be on the same level as its competitors."
"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."
"One of the reasons we were able to get approval within two hours from our management was that it was cheap enough. We have a 3% or 10% collaboration package, which comes out to be 70 bucks a year. It was very cheap, and we had no issues actually getting the full version. It was very affordable for a business."
"I pay $95 a year for it. It seems like a reasonable price."
"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."
"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."
"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."
"The pricing and licensing are fine. It has a lot of features that I prefer over some of the other programs, which is good. Being that it is web-based, I feel that it is acceptable that it's on a monthly pay basis. However, I think I pay on an annual basis, which is fine with me."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"I have only used the trial version and have not yet paid for it, or explored the pricing options."
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: January 2026.
881,707 professionals have used our research since 2012.