Try our new research platform with insights from 80,000+ expert users

Lucidchart vs erwin Data Modeler by Quest 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 by Quest
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (3rd), Business Process Design (9th)
Lucidchart
Average Rating
8.6
Reviews Sentiment
8.1
Number of Reviews
54
Ranking in other categories
Mind Mapping Software (2nd), Visual Collaboration Platforms (3rd)
 

Mindshare comparison

erwin Data Modeler by Quest and Lucidchart aren’t in the same category and serve different purposes. erwin Data Modeler by Quest is designed for Enterprise Architecture Management and holds a mindshare of 11.1%, up 10.0% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 22.5% mindshare, up 19.7% since last year.
Enterprise Architecture Management
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.
MichaelChirinian - PeerSpot reviewer
Intuitive, integrates well, and is a great way to change text into visual ideas
I'm not a super user, and there might be a way of doing it that I haven't explored, but I was looking for some specific icons that are just standard icons, and I found the icon library to be very focused on architecture icons. It didn't have as many standard or generic icons. Another thing that somewhat irritated me is the fact that there is a paste function in the menu, but when you right-click and select paste, it tells you that you can't use paste. You must press Command-V or Apple-V to paste. They give you a menu option to paste, but every time you use that, they say, "We don't accept it." On top of that, normally, you'd have an option for paste or paste values, but when you use the paste function, you don't have that capability. So, to copy text from one place, I have to use Command-V to paste it, but if I don't like the format, I've got to go back and do copy style and then paste style on top of that. It is a small detail, but when you're doing diagrams, it is annoying that they don't support paste values. It is a small irk. I'm not penalizing it, and I still think it is a five-star product. In terms of other bigger things, I don't really have any comments or criticism so far.

Quotes from Members

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

Pros

"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"Quest can create conceptual and physical data models to facilitate effective communication between business and IT. It can also integrate expertise from various engineering and database systems within your organization to enhance data management and administration."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"We can create mappings in erwin and possibly data dictionaries."
"The interface is really good and it is very easy to use."
"I love the fact that you can just integrate a drawing into Google Slides. I build a lot of visuals in Lucidchart, and then, rather than sharing them directly from Lucidchart, I just build Google Slides decks for senior management, and I link the Lucidchart on the cloud version to a slide image. That makes it easy. This way, I can build in one tool and show in another."
"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."
"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 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."
"I really like the drag and drop feature because it makes the work easier. It is very easy to use. All the pieces are very good. All the icons and all the fields are available in the left panel. So, I just click, drag, and then edit a piece. When I showed it to my managing director, he was very inspired, and he also got a premium account for himself."
"Lucidchart's ability to create a visualization that people prefer to look at, over reading written documents, has definitely saved me a lot of time. Moreover, it has helped to make my code bug-free because I no longer have broken endpoints."
"The best part of Lucidchart is its comfortableness when sharing it with my teammates. Lucidchart provides me a folder for my ERD. I can make a dozen lists of my chart, then share them with my teammates easily through the diagrams of Lucidchart. This is their main comfortableness, which is the reason why I choose Lucidchart rather than some other chart program."
 

Cons

"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 to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."
"The solution's model mark could be better because it crashes sometimes."
"I would like the solution to be more user-friendly to deploy."
"As someone who has used it for a long time, I have seen stability vary from version to version."
"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."
"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."
"The erwin Data Modeler is quite complex to use."
"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 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."
"In terms of improvement, there can be more templates. There are good templates but there could still be more."
"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."
"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."
"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."
"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."
"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

"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."
"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"erwin Data Modeler by Quest is an expensive solution."
"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."
"Pricing is very high compared to any other product."
"There are no costs in addition to the standard licensing fees."
"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."
"The solution is expensive."
"We signed up for the month-to-month and it charged us all at once for the whole year. I believe we signed up for the $7.99 one. I think that was the price."
"I pay $95 a year for it. It seems like a reasonable price."
"The pricing is very reasonable, and they have a free trial available that you can play with."
"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."
"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."
"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 price and licensing are good."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
831,071 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
10%
Government
9%
Computer Software Company
8%
Financial Services Firm
14%
Computer Software Company
11%
Manufacturing Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
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...
Can we use a product like Lucidchart for "personal" use?
Absolutely! Lucidchart is a clever tool that is fit for purpose for whatever activity you would like - whether it's your thoughts or processes. There is a well-populated library of well-designed 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, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: January 2025.
831,071 professionals have used our research since 2012.