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
44
Ranking in other categories
Enterprise Architecture Management (2nd), Business Process Design (9th), Data Governance (13th)
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 7.8%, down 11.0% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 23.1% mindshare, up 22.3% since last year.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler7.8%
LeanIX11.2%
Sparx Systems Enterprise Architect10.3%
Other70.7%
Enterprise Architecture Management
Mind Mapping Software Market Share Distribution
ProductMarket Share (%)
Lucidchart23.1%
Visio28.2%
draw.io14.9%
Other33.8%
Mind Mapping Software
 

Featured Reviews

Alton Thibodeaux - PeerSpot reviewer
Data Warehouse Architect at a healthcare company with 10,001+ employees
Data modeling has supported secure migration from legacy platforms to cloud analytics
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 back into spreadsheets. The only thing I wish is that their API documentation was a little bit clearer and that it had better examples of successful code. To me, examples are worth a hundred pages of reference documentation. Just give me an example of how you use it, and that really helps. I know that's a nitpicking thing, but I wish their API documentation had a lot more examples of code that actually worked to do the things that they're talking about. As far as erwin Data Modeler itself goes, when we have a lot of tables, I have some erwin Data Modeler files that have thousands of tables in them, up to 3,000 or 4,000 tables. When erwin Data Modeler files start getting that big, it takes a really long time, I'd say a minute or more, to open the file. Whenever I'm working in it, sometimes there are operations that also take a long time, so as erwin Data Modeler files get larger, the response time really slows down. An irritation is that every now and then, when I'm working and usually when I have multiple erwin Data Modeler files open at the same time, I get a glitch where a lot of the text fields get solid black, the first eight characters of column names might be blacked out with a rectangle. All I have to do is close erwin Data Modeler, shut it down, and bring it back up, and then everything is fine. It doesn't happen all the time, only occasionally, maybe once or twice a week, and those are the only two things I can say. The previous version of erwin Data Modeler used to crash unaccountably, but this one hasn't ever crashed on me, so it's been a lot more stable than the previous version that we had.
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

"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"The modeling portion of the tool is the most valuable. There are some notes, naming standards, and other functions that we use as well. There's a whole boatload of functionality in this thing and we use maybe 10% of it. It seems to be pretty common that not all the functionality is fully utilized. But it's just got gobs and gobs of stuff that you can implement if you so choose to."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"This tool is beneficial to any organization as it is foundational; there is no better way than this, and it is a must-have for every organization, whether large or small."
"It has centralized storage so that a data model can be shared by different teams."
"My favorite feature of erwin Data Modeler is that we can export and import tables directly from the databases, and it is easy to map from table to table and column to column."
"I love the way erwin Data Modeler creates data models and presents them for our users."
"Ease of use is especially critical because if I am conducting brainstorming sessions with my team, I have to be able to quickly put things on the monitor so that I don't lose their attention and focus. Ease of use is definitely helpful when I do that... The fact that I don't get lost within the software and am able to quickly generate visuals onscreen, so that it doesn't break the momentum, is a huge win."
"It is a very effective tool for documenting processes and using it has improved our efficiency significantly."
"One of the features that I really like is the collaboration aspect of it. During the pandemic, it's very important that we're able to collaborate virtually."
"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."
"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."
"It is important that Lucidchart accommodates both Mac and PC users because if you support Mac, that means you also support the mobile applications on the iPad... Some of the other employees have access to an iPad, but not all of them do. When we're trying to talk through a process with them on-the-fly, or at the point of occurrence, it's so much nicer if we can both have it up on the iPad. That's why I would say the Mac support is essential."
"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."
"The interface is easy for a layperson to use and adapt to."
 

Cons

"There is a lack of local support in the China region."
"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 still use Visio for conceptual modeling, and that's mainly because it is easier to change things, and you can relax some of the rules. DM's eventual target is a database, which means you actually have to dot all the Is and cross all the Ts, but in a conceptual model, you don't often know what you're working with. So, that's probably a constraint with erwin. They have made it a lot easier, and they've done a lot, but there is probably still room for improvement in terms of the ease of presentation back to the business. I'm comparing it with something like Visio where you can change colors on a box, change the text color and that sort of stuff, and change the lines. Such things are a whole lot easier in Visio, but once you get a theme organized in erwin, you can apply that theme to all of the objects. So, it becomes easier, but you do have to set up that theme."
"The erwin Data Modeler is quite complex to use."
"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 like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."
"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 reverse engineering in Oracle Databases needs improvement, as there are issues."
"It would be really helpful if we could create a process flow based on a Word Document or a PPT file."
"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."
"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"
"Perhaps it already exists, but if there were software to install the solution on a Mac, that would be helpful. I see that it's not in the App Store, so that's something that could be improved."
"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."
"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."
"It would be nice to have more features that help me visually present information. Since I use it as a canvas, my use case for it is probably very specific. I use it as a way to present information to people visually on a large mind map. So, it would be nice to be able to have more graphical things to clean it up, like a header, banners, or something to help draw attention to certain areas. I would also like more infographic-like features, because I am kind of limited to float chart shapes. This makes the solution a little cumbersome."
"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."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"The price should be lower in order to be on the same level as its competitors."
"The solution is expensive."
"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."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"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."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"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 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."
"The pricing and licensing are fine, though I wish they didn't require you to buy the licenses in batches of five."
"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."
"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."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
879,259 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise3
Large Enterprise33
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?
For the review, I would assign an eight because it has its own limitations. It has a very steep learning curve, limited support for NoSQL or streaming systems, and potentially a high licensing cost...
What is your primary use case for erwin Data Modeler by Quest?
I used erwin Data Modeler for approximately two to three years on a project. I used erwin Data Modeler for multi-level data modeling, conducting conceptual, logical, and physical data modeling with...
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?
I wish Lucidchart would add dark mode to improve the user experience.
 

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: November 2025.
879,259 professionals have used our research since 2012.