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."It has centralized storage so that a data model can be shared by different teams."
"We can create mappings in erwin and possibly data dictionaries."
"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 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."
"The fitting model is very intuitive."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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."
"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."
"The ability to have more than one person editing at the same time is the most valuable feature. You can have one diagram and have multiple users on it at the same time. We haven't been able to do that on other software. So that's the main reason we moved to Lucidchart."
"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."
"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."
"In general, this product has improved our organization because it makes accessing up-to-date processes and planning a lot easier."
"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 templates are quite valuable, as is the fact that you can export to PDF, to a Visio document, or as a picture. These are valuable features for me because they give me the ability to make changes in any other product that I'm using. I'm not bound by one platform."
"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 erwin Data Modeler is quite complex to use."
"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."
"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."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"There is a lack of local support in the China region."
"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."
"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."
"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 might already exist and I haven't used it, but in terms of improvement, I would like a hot-key system for some of the diagrams to auto-generate things a bit quicker to be able to produce charts a lot faster, or have more standard templates that you can just go to if you're trying to generate something quickly."
"If it could be a little more visual, in terms of being able to make it stand out a little bit more, then that would be helpful."
"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."
"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."
"What I do find extremely frustrating is that when I've sent the sheet to non-license holders, you have to create an account. You create a username and password. The path taken to create that account is so confusing that everyone thinks that they have to give their credit card number, and then they're reluctant. They don't want to go through the sheet."
"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."
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.