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 process of creating visual representations of data structures using erwin Data Modeler allows you to see everything you are doing, and you have visuals to see what you are going to do and what has been done so far."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"There is absolutely no problem with the stability."
"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."
"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."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"The fitting model is very intuitive."
"erwin Data Modeler's ability to generate database code from a model for a wide array of data sources saves time in development, as utilizing the solution allows me to accomplish tasks in minutes compared to the extended time required for manual processes."
"Creating flowcharts and documentation is easy to do and the results are very nice."
"Documenting complicated workflows and technology integrations so that we can go back to it has also been a benefit. And without having to dig into a lot of technical, the codes, the documents, I can simply understand on a high level what's happening."
"The most valuable feature is the ease of use, and just being able to drag and drop."
"The interface is easy for a layperson to use and adapt to."
"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."
"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 architecture and brainstorming features worked exceptionally well for me; no one in the organization had used it for brainstorming, and my implementation really helped with the visuals and capturing people's opinions and divergent thought processes."
"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

"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"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."
"There is a lack of local support in the China region."
"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 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."
"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."
"This is a very complex product."
"I would like the solution to be more user-friendly to deploy."
"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."
"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."
"I would like an on-premises version of the software that I can just download and use. I think that it's easier that way."
"One downside is that you can only modify things online, but when you download work, you download it as an image. It would be useful to have an option to modify it locally."
"Although it comes with a lot of pre-existing tools, it would help if it had some more design templates. By now, they must know what kinds of things people are trying out, and that should help them create more templates. I would also like to see a little more automation."
"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."
"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."
"If you're trying to expand a comments box that is sitting on top of the chart, it automatically defaults to assuming you're trying to connect it to the next step in the process, when all you're trying to do is make the box bigger. It automatically goes to the arrow, but I just want to resize the box. That gets a little cumbersome because it does it every single time. It's not just a bug."
 

Pricing and Cost Advice

"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"The tool is expensive."
"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."
"The solution is expensive."
"Pricing is very high compared to any other product."
"erwin Data Modeler by Quest is an expensive solution."
"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."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"The pricing is very reasonable, and they have a free trial available that you can play with."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"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."
"The price and licensing are good."
"Its pricing is very affordable and reasonable for the features that it provides. I am using its basic plan, and for my usage, it is perfectly reasonable. It suits perfectly."
"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."
"I was using the free version of Lucidchart, which was very helpful."
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.