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
6.6
Number of Reviews
40
Ranking in other categories
Enterprise Architecture Management (3rd), Business Process Design (9th), Data Governance (14th)
Lucidchart
Average Rating
8.6
Reviews Sentiment
8.1
Number of Reviews
56
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.8%, down 10.7% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 24.8% mindshare, up 21.6% since last year.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler8.8%
LeanIX13.1%
Sparx Systems Enterprise Architect11.3%
Other66.8%
Enterprise Architecture Management
Mind Mapping Software Market Share Distribution
ProductMarket Share (%)
Lucidchart24.8%
Visio29.6%
draw.io16.0%
Other29.599999999999994%
Mind Mapping Software
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.
Michael Verruto - PeerSpot reviewer
Visual approach facilitates clarity and process efficiency in complex real estate tasks
I haven't done much with Lucidchart's integration with other popular apps such as Teams, though one of my colleagues mentioned it can be added. This has sparked my interest to look into integration with Excel and Word, though we haven't implemented these features yet in our less than a year of operation. I access Lucidchart from multiple devices, including iPhone, iPad, and PC desktop. Our PCs are all laptops, so we can work remotely. I've collaborated with people from home on my iPad while they were on their laptop, though this isn't our routine behavior. I would recommend Lucidchart to others, but I'd also recommend exploring other options. It depends on what your fit and feel is for what you're trying to accomplish. For heavy users or technical users, Lucidchart might be very appealing. It has more capabilities than I'm currently using. The Highway Bridge Maintenance group, who are familiar with Agile processes, speak positively about it. For average users, they might find similar functionality in Miro or other less expensive alternatives. Overall Rating: 9 out of 10

Quotes from Members

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

Pros

"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"It is a scalable solution...The technical support team is fine."
"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."
"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."
"One of the best aspects of the tool is its reverse engineering capability."
"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."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"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."
"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."
"The most valuable features are the different templates that they have already created, as well as all the different shapes you can use in the process charts because each shape stands for a different element or thing that's being done. It's easy to distinguish between different steps using the already set-out shapes."
"Lucidchart is a lovely tool for creating visual representations of any process or organization."
"The interface is very good and easy to use. We don't need documentation on how to use it. It is self-explanatory, which is very convenient for a new user."
"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 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."
"It is a very effective tool for documenting processes and using it has improved our efficiency significantly."
"I like the panel on the left of the screen that has all of the shapes that are available to use in the charts. It's easy to use because you can just drag and drop."
 

Cons

"erwin is not as robust as a data warehousing project I've been on in the past."
"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."
"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"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'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"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."
"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."
"The erwin Data Modeler is quite complex to use."
"As far as I know, LucidChart can’t be automated with Visual Basic .Net like Visio."
"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."
"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."
"The communication with sales has been pretty poor. They have been spotty in terms of response. So far, that has been our problem with it. We were in contact with one of their representatives, but he just kind of disappeared one day and we couldn't find him anymore. He has not been responsive to email."
"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."
"They should continue to bring in more shapes. For example, I saw something cool the other day that was a timeline and in between each step, there was a circle. I thought that that was very clean and that's something that I could see myself using. Lucidchart could come up with more visualizations. I'm not a designer so I would like to have more visuals. That would make my job easier because it would make my job much more professional looking but without having to be a designer myself."
"They could provide more documentation or tutorials of ERDs or DDD on the Lucidchart site. That could be better."
"There is a premium for the use of certain elements in Lucidchart... It becomes very annoying, especially if you are a first-time user of Lucidchart and you don't have a premium plan. It feels a little too restrictive, in terms of using very basic shapes and icons. It asks you to sign-up for the premium account, which I think shouldn't be the case."
 

Pricing and Cost Advice

"There are two license options and the pricing is reasonable."
"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."
"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."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"The tool is expensive."
"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."
"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."
"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."
"The pricing is very competitive. It is more cost-effective than some competing products, such as Visio."
"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."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"I pay $95 a year for it. It seems like a reasonable price."
"I have a subscription as an individual user for one year, and it is not expensive."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
870,701 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise3
Large Enterprise29
By reviewers
Company SizeCount
Small Business23
Midsize Enterprise14
Large Enterprise21
 

Questions from the Community

What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
I do not recall the pricing from about a year and a half ago, but it seems reasonable.
What needs improvement with erwin Data Modeler by Quest?
erwin Data Modeler could improve its UI as it still feels old school and not very modern. There are many features, and I would expect good documentation detailing each feature, including when and h...
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?
The system is a bit clumsy when it comes to stylizing to match corporate imaging styles. In real estate, we need everything to have the same look and feel as our materials. Beyond dropping a logo i...
 

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, Sparx Systems, Quest Software and others in Enterprise Architecture Management. Updated: September 2025.
870,701 professionals have used our research since 2012.