This article provides an overview of how Quest Data Modeler integrates with Erwin Data Modeler, focusing on the cloud-based modeling experience. It highlights the features, functionalities, and the collaborative potential of these tools for data modeling.
Quest Data Modeler is a separate product from Erwin Data Modeler, designed to complement it rather than replace it. Both tools work together to enhance the data modeling process, providing users with a range of functionalities tailored to their needs.
Quest Data Modeler operates alongside Erwin Data Modeler, allowing users to create new models and work with existing ones. It supports reverse engineering of cloud databases, specifically Snowflake, Databricks, and Microsoft Fabric.
The user interface of Quest Data Modeler is designed to be simple and intuitive, catering to users who may not require the full capabilities of Erwin Data Modeler. It features a light mode and a dark mode, providing flexibility in user preferences.
Users can create conceptual, logical, or physical models. The process involves selecting a database and incorporating templates as needed. The Wizards used for model creation are similar to those in Erwin Data Modeler, ensuring continuity for existing users.
Models can be imported from Erwin Data Modeler by saving them as JSON files. Quest Data Modeler supports the import of logical and conceptual models, while physical models are limited to specific databases.
Quest Data Modeler allows users to reverse engineer databases or script files to build logical or physical models. Authentication methods for connecting to databases are consistent with those used in Erwin Data Modeler.
The AI model generator is a standout feature, enabling users to create models through prompt-based modeling. Users can input prompts to generate models, import data from spreadsheets, or even use images to create models. A prompt gallery is available to assist users in crafting effective prompts.
Quest Data Modeler aims to democratize data modeling by allowing data engineers and analysts to participate in the modeling process. This collaboration reduces the iteration cycle and enhances the alignment between business needs and data models.
Quest Data Modeler and Erwin Data Modeler together create a powerful ecosystem for data modeling. By leveraging the strengths of both tools, organizations can enhance their data modeling capabilities, improve collaboration, and respond more effectively to business needs.
