We just raised a $30M Series A: Read our story

Compare Lucidchart vs. erwin Data Modeler (DM)

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Sparx Systems, Planview, erwin, Inc. and others in Architecture Management. Updated: November 2021.
552,136 professionals have used our research since 2012.
Quotes From Members

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

Pros
"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.""The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases.""There is absolutely no problem with the stability.""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 a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for.""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.""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.""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."

More erwin Data Modeler (DM) Pros »

"Documenting complicated workflows and technology integrations so that we can go back to it has also been a benefit. And without having to dig into a lot of technical, the codes, the documents, I can simply understand on a high level what's happening.""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.""The wireframe and mock-up features have been the most useful so far. It's easy to create the mock-ups and then communicate to our development team what they need to look like. Lucidchart's capabilities for visualizing and understanding process flows or workflows is very good as well. I'm able to easily use any style of box that I need to create on a flowchart, to effectively communicate to our development team.""Lucidchart is a lovely tool for creating visual representations of any process or organization.""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 most valuable feature is the ease of use, and just being able to drag and drop.""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.""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."

More Lucidchart Pros »

Cons
"We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from individual desktops and get them into a single data model, when multiple data modelers are working on a particular project. It becomes a nightmare for the senior data modeler to bring them together, especially when it comes to recreating them when you want to merge them.""The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement.""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.""One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated.""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.""I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user.""I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk.""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 (DM) Cons »

"The flowcharting feature would be improved if it had some kind of prediction capability that helped to create the diagrams, such as the ability to automatically join components with my database.""I would really like to be able to set default appearance settings for new documents because I have a set of appearance settings that I always use. I end up setting that manually every time. There may be a way to do that, and maybe I am not able to find it. This is my only major point of feedback for improvement. There are other little nitpicky things, such as being able to lock layers without them looking like a big red line around them would be nice, but every graphic design software does that, so I understand why they have that. All my concerns are nitpicks. They're not big.""When my colleague initially tried to edit the file that I shared with him, he had some trouble. This is something that should be improved.""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...""In terms of improvement, there can be more templates. There are good templates but there could still be more.""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.""When you want to add text to a connector arrow, I have not figured out how to position the text vertically. It always wants the text to stay horizontal.""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."

More Lucidchart Cons »

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

More erwin Data Modeler (DM) Pricing and Cost Advice »

"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.""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 was using the free version of Lucidchart, which was very helpful.""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.""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.""The pricing and licensing are fine, though I wish they didn't require you to buy the licenses in batches of five.""The price and licensing are good."

More Lucidchart Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
552,136 professionals have used our research since 2012.
Questions from the Community
Top Answer: 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.
Top Answer: We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from… more »
Top Answer: We use erwin DM as a data modeling tool. All projects in the data warehouse area go through the erwin model first and get reviewed and get approved. That's part of the project life cycle. And then we… more »
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: The wireframe and mock-up features have been the most useful so far. It's easy to create the mock-ups and then communicate to our development team what they need to look like. Lucidchart's… more »
Top Answer: I would like to learn more about Lucidspark. When that was released, I was surprised to learn that it came with a separate subscription model and was not included in my existing Lucidchart… more »
Ranking
3rd
Views
5,114
Comparisons
2,375
Reviews
21
Average Words per Review
1,973
Rating
8.9
2nd
Views
6,264
Comparisons
4,970
Reviews
50
Average Words per Review
1,275
Rating
8.6
Comparisons
Also Known As
erwin DM
Learn More
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.

Offer
Learn more about erwin Data Modeler (DM)
Learn more about 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
Insurance Company29%
Financial Services Firm24%
Government18%
Logistics Company12%
VISITORS READING REVIEWS
Computer Software Company24%
Financial Services Firm18%
Comms Service Provider11%
Government8%
REVIEWERS
Computer Software Company16%
Manufacturing Company11%
Wellness & Fitness Company8%
Financial Services Firm8%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider17%
Educational Organization6%
Government5%
Company Size
REVIEWERS
Small Business37%
Midsize Enterprise4%
Large Enterprise59%
VISITORS READING REVIEWS
Small Business2%
Midsize Enterprise1%
Large Enterprise97%
REVIEWERS
Small Business41%
Midsize Enterprise25%
Large Enterprise34%
VISITORS READING REVIEWS
Small Business42%
Midsize Enterprise42%
Large Enterprise17%
Find out what your peers are saying about Sparx Systems, Planview, erwin, Inc. and others in Architecture Management. Updated: November 2021.
552,136 professionals have used our research since 2012.

erwin Data Modeler (DM) is ranked 3rd in Architecture Management with 21 reviews while Lucidchart is ranked 2nd in Mind Mapping Software with 50 reviews. erwin Data Modeler (DM) is rated 8.8, while Lucidchart is rated 8.6. The top reviewer of erwin Data Modeler (DM) writes "Allows us to bring in data from dozens of platforms and search holistically across all of them". On the other hand, the top reviewer of Lucidchart writes "Organizational charts help to visualize and understand team hierarchies and relationships". erwin Data Modeler (DM) is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, AWS Well-Architected Tool and Visual Paradigm, whereas Lucidchart is most compared with Lucidspark, Sparx Systems Enterprise Architect, Visio, Visual Paradigm and IBM Blueworks Live.

We monitor all 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.