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
5.9
Number of Reviews
46
Ranking in other categories
Enterprise Architecture Management (2nd), Business Process Design (8th), Data Governance (15th)
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.3%, down 11.1% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 22.7% mindshare, up 22.5% since last year.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler8.3%
LeanIX10.1%
Sparx Systems Enterprise Architect9.3%
Other72.3%
Enterprise Architecture Management
Mind Mapping Software Market Share Distribution
ProductMarket Share (%)
Lucidchart22.7%
Visio26.7%
draw.io14.0%
Other36.6%
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 allows us to reuse entities and attributes."
"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 solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"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."
"The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases."
"It is a scalable solution...The technical support team is fine."
"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."
"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."
"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."
"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."
"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."
"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."
"For documenting processes and systems, I would rate the solution a nine out of 10. I'm not aware of any other software that is as usable as this, because of the templates. They make documenting these things really easy."
"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."
 

Cons

"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."
"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."
"Sometimes when I want to open the attribute editor, it stops working and the whole application freezes."
"The interface must be improved."
"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."
"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."
"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."
"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 an on-premises version of the software that I can just download and use. I think that it's easier that way."
"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."
"What I do find extremely frustrating is that when I've sent the sheet to non-license holders, you have to create an account. You create a username and password. The path taken to create that account is so confusing that everyone thinks that they have to give their credit card number, and then they're reluctant. They don't want to go through the sheet."
"In terms of improvement, there can be more templates. There are good templates but there could still be more."
"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."
"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 wish there were a lot more automations. For instance, if I'm using a project management software to list out all my WBS [work breakdown structure] I wish Lucidchart had the functionality where it would take all the numbering and generate a tree diagram. Something like that would help so much, but right now it's still a manual task..."
"One of the issues has been that, as far as I understand, even to view it, the other person needs a Lucidchart account unless you send them a PDF. That's been a bit of an issue because some people in our organization don't have Lucidchart accounts, only certain people have logins. If we just want to collect comments from people, that's been a bit complicated."
 

Pricing and Cost Advice

"Though the solution is not cheap, it's worth the money."
"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."
"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."
"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very 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."
"There are two license options and the pricing is reasonable."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"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."
"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."
"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."
"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."
"I'm happy with the pricing of Lucidchart but I can't say I'm completely happy with it. It could be cheaper for what it offers, about $5 cheaper, or Lucid could charge $5 more and add more features, like automation. Right now, it's $15 per user per month... On the other hand, they have made their billing super-easy for users, such as for people who have to do expense reports. It is probably the easiest platform I'm using when it comes to billing for software as a service."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
881,082 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business15
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,082 professionals have used our research since 2012.