erwin provides a data management platform for managing both structured and unstructured data types. It is an open-standards data hub designed to allow customers to manage their data wherever it might be stored (in-house relational databases, or public or private cloud). The platform handles big data governance, control, customization and web-based publishing and reporting. The vendor says erwin Data Modeler is used by more than 50,000 professional s in 60+ countries to get big…
N/A
Lucidchart
Score 8.7 out of 10
N/A
Lucidchart is a diagramming application that helps teams to clarify complexity, align their insights, and build faster. With this cloud-based solution, users can work visually and collaborate in real-time while building flowcharts, mockups, and UML diagrams. Lucidchart is utilized in over 180 countries by more than 25…
I was unable to find embarcadero or Datanamic DeZign in the list of other products, but those are two others I have used, along with Visio over the years for data modeling. Erwin is one of the premier tools in the space. I would rate it as a top tool, comparable to …
I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.
Lucidchart has been very, very helpful and applicable in my line of work as i am constantly trying to solve complex data modeling and database design issues. I therefore use the ERD options frequently to aid in my overall comprehension of the problems at hand. Furthermore, I find a a lot of use out of the more general options with both the DFD and UML shapes and options, which lend aid to brainstorming on analytics needs, product journeys, etc. I have previously attempted to do some work with a data dictionary and/or data catalog in Lucidchart, just for the heck of it. I was sad to find it wasn't a very plausible option from what i could tell, but would love to see some kind of solution there maybe
Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.
Large number of predefined charts, diagrams, flows
A great repository of various symbols and objects
The easiness of using and manipulating objects and shapes. There is a lot of auto-editing and adjusting which the software does for you which saves a lot of your time.
Easy way of duplicating shapes.
While working with the app everything feels organic and natural. You don't get the clunky/limited feeling which happens with some other similar apps.
I had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.
It's quite easy to get started with Lucid and I think the usability has been improving overtime. So there isn't anything I feel unsatisfied or I want to complain. I would say that there are a lot more features in Lucid that I know are powerful but I don't know how to use them. It doesn't block me to do my day to day tasks and that's probably why I don't have much motivation to learn. When I tried in the past, I have the impression that wasn't super easy to learn and I couldn't really see how to apply those features into what I want to do.
CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.
While we have not had many occasions where we needed to engage Lucidchart support, they have been very helpful and provided the required information and service when we did have to engage them. SLAs on replies to our queries were more than met and we are satisfied with the level of support we received.
Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.
Lucidchart is much easier to use than Visio. Lucidchart also does a better job diagraming other cloud environments outside of Microsoft that Visio lacks. I also find that the auto-alignment features in Lucidchart are much smoother than in Visio. Finally, I feel the overall visuals look better in Lucidchart than in Visio.
It sure has. It has saved me a lot of time. Think of all the time I could have wasted trying to learn a program that does the same thing, whereas Lucidchart just does it with ease, learn as you go, and be a boss at it.
Lucidchart has increased productivity. My diagrams have helped co-workers find connectivity and helped them troubleshoot devices. This has saved time and increased productivity.
