Lucidchart vs erwin Data Modeler by Quest comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between erwin Data Modeler by Quest and Lucidchart based on real PeerSpot user reviews.

Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management.
To learn more, read our detailed Enterprise Architecture Management Report (Updated: February 2024).
757,198 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc.""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 have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature.""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.""The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically.""What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes.""The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."

More erwin Data Modeler by Quest Pros →

"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.""Easy to work on.""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.""The ability for Lucidchart to create database schemas or modify existing data structures is strong. That's what I initially introduced it for in our organization. The script that Lucidchart provides works with other systems like Oracle, SQL Server, and Postgres that I can copy-paste, and get a quick dump of metadata and import into has saved me a ton of steps that I didn't have to manually create these tables. I had a lot of things where I still had to put in the linkages between tables, but I didn't have to type in every field name, every data type, and everything else that came in. That saved me tons of time.""The interface is easy for a layperson to use and adapt to.""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.""Lucidchart's capabilities for understanding workflows is high. I use a couple of different programs, like MindManager, and what I like about using Lucidchart is that it is all web-based. So, I can quickly go into a web browser, drag and drop a bunch of files, pictures, or notes, draw some flow lines, and rapidly be able to create a visual representation of what I am trying to do. As a product manager, I can quickly organize thoughts that way and show people what we are working on.""The interface is very user-friendly and it is not a hassle to use the site at all. They did a really good job in that regard."

More Lucidchart Pros →

Cons
"This is a very complex product.""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 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 find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it.""The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model.""Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use.""The solution's reporting side needs to be improved.""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."

More erwin Data Modeler by Quest Cons →

"It can have more colors or graphics. Currently, it is a little boring. It can have a little bit more fun factor.""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.""In terms of improvement, there can be more templates. There are good templates but there could still be more.""Wireframing can be improved. For mock-ups and wireframing, only 10% of what is required is there. If they can develop this feature, it would be much better because it will then provide everything. Currently, we can design network diagrams, processes, etc., but we should also be able to do wireframing.""They could provide more documentation or tutorials of ERDs or DDD on the Lucidchart site. That could be better.""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.""Although it comes with a lot of pre-existing tools, it would help if it had some more design templates. By now, they must know what kinds of things people are trying out, and that should help them create more templates. I would also like to see a little more automation.""As far as I know, LucidChart can’t be automated with Visual Basic .Net like Visio."

More Lucidchart Cons →

Pricing and Cost Advice
  • "The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
  • "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."
  • "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."
  • "The price should be lower in order to be on the same level as its competitors."
  • "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."
  • "There are no costs in addition to the standard licensing fees."
  • "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."
  • "The price of erwin Data Modeler is very expensive, in particular for this part of the world."
  • More erwin Data Modeler by Quest Pricing and Cost Advice →

  • "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 pricing and licensing are fine, though I wish they didn't require you to buy the licenses in batches of five."
  • "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."
  • "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."
  • "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."
  • "The pricing is very reasonable, and they have a free trial available that you can play with."
  • "Pricing-wise, it is pretty fair. I don't really know what group pricing looks like, but right now, I pay $10 a month for my Lucid subscription. One thing I would say is that I do worry about my bosses being okay with paying $10 a month for every single employee because we would have around 20 people. It makes me a little nervous about whether they are going to pay $200 a month for people to be able to use this software. At the same time, from where I'm sitting, it's totally worth it. We save a thousand dollars from using this software. It's still a no-brainer."
  • "I have a subscription as an individual user for one year, and it is not expensive."
  • More Lucidchart Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
    757,198 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
    Top Answer:The solution's model mark could be better because it crashes sometimes.
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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… more »
    Ranking
    Views
    6,668
    Comparisons
    3,534
    Reviews
    11
    Average Words per Review
    432
    Rating
    7.9
    2nd
    Views
    1,350
    Comparisons
    1,140
    Reviews
    4
    Average Words per Review
    1,268
    Rating
    9.8
    Comparisons
    Also Known As
    erwin DM
    Learn More
    erwin by Quest
    Video Not Available
    Lucid Software
    Video Not Available
    Overview

    erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

    Our online diagram application makes it easy to sketch and share professional flowchart diagrams.  From brainstorming to project management, we support all of your communication needs. That’s why millions of users choose Lucidchart.

    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
    Top Industries
    REVIEWERS
    Financial Services Firm28%
    Insurance Company21%
    Government14%
    Energy/Utilities Company7%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Government10%
    Computer Software Company9%
    Manufacturing Company7%
    REVIEWERS
    Computer Software Company18%
    Manufacturing Company11%
    Wellness & Fitness Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Financial Services Firm13%
    Computer Software Company12%
    Manufacturing Company8%
    Government6%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise7%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    REVIEWERS
    Small Business41%
    Midsize Enterprise25%
    Large Enterprise34%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise13%
    Large Enterprise68%
    Buyer's Guide
    Enterprise Architecture Management
    February 2024
    Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: February 2024.
    757,198 professionals have used our research since 2012.

    erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 12 reviews while Lucidchart is ranked 2nd in Mind Mapping Software with 4 reviews. erwin Data Modeler by Quest is rated 8.6, while Lucidchart is rated 8.6. The top reviewer of erwin Data Modeler by Quest writes "The creation of data models is easy and quick, and the fitting model is very intuitive". On the other hand, the top reviewer of Lucidchart writes "Intuitive, integrates well, and is a great way to change text into visual ideas". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Sparx Systems Enterprise Architect and AWS Well-Architected Tool, whereas Lucidchart is most compared with Lucidspark, Figma, Sparx Systems Enterprise Architect, Visual Paradigm and IBM Blueworks Live.

    We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.