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
 

Categories and Ranking

erwin Data Modeler by Quest
Average Rating
8.6
Number of Reviews
38
Ranking in other categories
Enterprise Architecture Management (3rd), Business Process Design (9th)
Lucidchart
Average Rating
8.6
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 10.9%, up 10.1% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 22.7% mindshare, up 20.8% since last year.
Enterprise Architecture Management
Mind Mapping Software
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Jun 19, 2024
Streamline data modeling and automate network changes for increased efficiency
We are implementing erwin to streamline data modeling and automate network changes for increased efficiency and comprehensive data development. This option simplifies the need for better data indexing Quest can create conceptual and physical data models to facilitate effective communication…
MichaelChirinian - PeerSpot reviewer
Mar 2, 2022
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

"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."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"There is absolutely no problem with the stability."
"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."
"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."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"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."
"There is no alternative to Lucidchart if you want to describe a five-step process with bullet points. I believe every person who ever worked with PowerPoint on any type of documentation and then thought about which tool would actually help to describe what they're trying to do but without the words, would come up with Lucidchart."
"It is important to me that the solution accommodates both Mac and PC users because the developers in our company use Mac, then the business people use Windows. The technical people create the technical architecture using Lucidchart. So, it is important that it is compatible with both the systems."
"The ease of creating some of the maps and diagrams is most valuable. Lucidchart is just simpler and works more intuitively than other solutions that I have used in the past, such as Microsoft Visio. I am not in a creative role, but I know how to use Adobe Illustrator and other solutions like that. If I need to map out something that I've never mapped out before, and it is going to need a totally custom graphic, eight times out of 10, I'm going to go to Lucidchart rather than trying to build it in Illustrator. Its intuition and flexibility are really big features for me."
"Lucidchart is a lovely tool for creating visual representations of any process or organization."
"The swimlanes feature is one that I use a lot. I have used swimlane diagrams to create business process flows and I think that it does the job pretty well."
"The usability is very nice in terms of flowchart components that are available."
"It's very easy to use. I didn't go through any tutorials or any documentation. It was very easy for me to start. It is intuitive. Right after logging in, I was able to quickly just drag and drop and do the things I wanted to do, without any prior knowledge of the solution."
 

Cons

"The solution's model mark could be better because it crashes sometimes."
"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."
"I would like the solution to be more user-friendly to deploy."
"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."
"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."
"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."
"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 reverse engineering in Oracle Databases needs improvement, as there are issues."
"One of the things that I find frustrating is that all of our Tableau information is on a server, so when I send that out people can't open it and use it. I then have to go back and do extra work to convert everything into an Excel format that everybody can use. It would be really important to me, if I send something out to somebody who doesn't have a Lucid account, that they can just click and see it, instead of having to log in and create an account."
"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."
"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."
"The UML diagram that it gave me initially was a huge flow with a bunch of UML tables, and I wasn't going to need that many. If it was a more simple linkage between the tables then it would be easier to finish projects, instead of having to select unnecessary tables and delete them."
"A couple of times when I tried to move a line, connecting two shapes on an organizational chart, occasionally the line doesn't move as intuitively as I think it should. I have to fiddle around with it a few times to get it to do what I want it to do."
"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."
"I would like to have more text boxes to write more comments so I can write a small note below a picture. I would like some flexibility."
"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..."
 

Pricing and Cost Advice

"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"Likewise, the solution is a little pricey."
"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 price should be lower in order to be on the same level as its competitors."
"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 Data Modeler by Quest is an expensive solution."
"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."
"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."
"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."
"I have a subscription as an individual user for one year, and it is not expensive."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"The pricing is very reasonable, and they have a free trial available that you can play with."
"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."
"We chose Lucid based on the price comparison between it and draw.io... Lucidchart was about 15 percent cheaper per user... I was surprised to learn that it came with a separate subscription model and was not included in my existing Lucidchart subscription."
"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 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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
815,854 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
9%
Computer Software Company
9%
Government
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: November 2024.
815,854 professionals have used our research since 2012.