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."Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"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."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"It has centralized storage so that a data model can be shared by different teams."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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 had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"Easy to work on."
"When it comes to documenting things like processes, systems, and new teams, I'd give it an eight or nine out of ten. It's very high because it's fairly intuitive, there's a low learning curve, and it's easy to get immediate output. You can get results very quickly without a lot of direct effort. You don't usually take a week-long series of training. You don't need to go through a lot of hoops to make it work."
"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."
"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."
"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."
"Lucidchart is a lovely tool for creating visual representations of any process or organization."
"Lucidchart's capabilities for visualizing and understanding process flows or workflows is excellent. The way that you put together the parts of charts and edit the chart are all very intuitive and easy to use."
"Its ease of use is most valuable. As compared to draw.io, connecting the lines and doing things like that are much easier in Lucidchart. It has been great for some of the process flow diagrams and data flow diagrams. I can export these diagrams as PDFs and share them with team members."
"The solution's model mark could be better because it crashes sometimes."
"I would like the solution to be less rigid in terms of its theory."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"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."
"We can only get licenses through partners."
"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 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."
"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 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."
"The communication with sales has been pretty poor. They have been spotty in terms of response. So far, that has been our problem with it. We were in contact with one of their representatives, but he just kind of disappeared one day and we couldn't find him anymore. He has not been responsive to email."
"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."
"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."
"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."
"It would be really helpful if we could create a process flow based on a Word Document or a PPT file."
"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."
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.