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."The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."
"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."
"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."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"We can create mappings in erwin and possibly data dictionaries."
"It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"The fitting model is very intuitive."
"The product allows us to reuse entities and attributes."
"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."
"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."
"The collaboration, hands-down, is the top feature. It is valuable because our company doesn't believe in working in silos... While I may be the one leading the efforts, it's very important that my team gets buy-in on decisions being made when we're designing. It's critical, especially in this virtual environment, when we're not in an office to have a team meeting and able to whiteboard something. Lucidchart is an extremely useful tool for our team."
"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."
"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."
"Lucidchart is a 10 out of 10 when it comes to documenting things such as processes, systems, and new teams. It's just so user-friendly. The fact that even if you've never used Lucidchart, if you take a template and adapt it, you'll inevitably find something to fit your needs, but it's also perfect for building from scratch. It's the ease of use, clarity, and the different functionalities that make it incredibly useful."
"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."
"It is a very effective tool for documenting processes and using it has improved our efficiency significantly."
"The solution's reporting side needs to be improved."
"erwin is not as robust as a data warehousing project I've been on in the past."
"The solution's model mark could be better because it crashes sometimes."
"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."
"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 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 am not so happy with its speed. Sometimes, it can have problems with connections."
"It would be nice to have more features that help me visually present information. Since I use it as a canvas, my use case for it is probably very specific. I use it as a way to present information to people visually on a large mind map. So, it would be nice to be able to have more graphical things to clean it up, like a header, banners, or something to help draw attention to certain areas. I would also like more infographic-like features, because I am kind of limited to float chart shapes. This makes the solution a little cumbersome."
"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."
"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."
"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."
"As far as I know, LucidChart can’t be automated with Visual Basic .Net like Visio."
"When I download a flowchart as a PDF file, it breaks it up. I would like to see the continuous display of flow charts, even if they are larger than one page."
"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."
"They could provide more documentation or tutorials of ERDs or DDD on the Lucidchart site. That could be better."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while Lucidchart is ranked 2nd in Mind Mapping Software with 54 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 product lets users import different types of models, but it is expensive, and the interface must be improved". On the other hand, the top reviewer of Lucidchart writes "Good brainstorming features, facilitates collaboration, and keeps us focused on our work". 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, Visio 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.