erwin Data Modeler by Quest Reviews

I have used Erwin for the last 20 to 30 years. As a data architect, I primarily use the data modelling tool. The MODEL MART functionality offers version control.

One of the best aspects of the tool is its reverse engineering capability. I can connect to a database and generate a new model. It creates foreign key relationships, both defined and implied, mapping them in my diagram. The ease of toggling from a logical model to a physical model is a great feature. It makes my job much easier to visualise my data model and relationships. Transitioning from a logical to a physical environment with just a switch is key. If I define my target database, it can generate my DDL for forward engineering.

We are implementing erwin to streamline data modeling and automate network changes for increased efficiency and comprehensive data development. This option simplifies the need for better data indexing.

Quest can create conceptual and physical data models to facilitate effective communication between business and IT. It can also integrate expertise from various engineering and database systems within your organization to enhance data management and administration.

I am using the solution for data modeling. We also use erwin Data Intelligence Suite for data governance.

We like that we can go straight from Data Modeler to Data Intelligence Suite. We can go from the business glossary to the data catalog. It gives us a holistic view. The product lets us import different types of models from various databases. It also allows us to export or implement them within the same databases based on new changes.

We use erwin Data Model to create logical and physical data models.

The solution has been very helpful. The logical and physical data models provide visualization for communication across the business, among the data team, and technical team. Without this solution, communication would be difficult.

The easiest way of exposing or sharing the model to all the users at the enterprise level is the feature I found to be valuable in the solution.

They should merge all those products because apart from the Mark Server, they have the Web Portal, which requires a separate installation and license. And it's not easy to maintain, but very easy to use. So you need additional resources such as memory, unlike if they merge those Web Portal and Mark Server, which would be a great solution.

I think they should be more open to or ready to be agnostic to any databases, such as MongoDB. Any database available in the market should be ready in their drivers because I don't think they can be ready. So all the popular databases like Oracle, MySQL, Microsoft, and SQL Server, but I haven't seen any connector in Cosmos DB SQL, so it should be in the big data or cloud solution.

We use the solution for data modeling.

We believe that the solution would help provide some structure to our data modeling and data design practices.

I use erwin Data Modeler for a metadata project. I don't have thousands of tables to manage or a data warehouse or anything.

erwin Data Modeler helps us reverse engineer and keep track of data before converting from one tool to another. erwin allows us to track data and share it with business analysts.

I use the solution for reverse engineering as well as forward engineering. I do logical and physical modeling, and some of what I'm doing right now is reverse engineering from actual databases because they have no diagrams. The solution helps me diagram the current and help me design the future.

Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.