For the best web experience, please use IE11+, Chrome, Firefox, or Safari

erwin Data Modeler

erwin Data Modeler by Quest is an award-winning data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. Discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts. 
What's New in erwin Data Modeler 2021 R1 20:32

Benefits of the erwin data modeling tool

erwin data models reduce complexity, making it easier to design, deploy and understand data sources to meet business needs. erwin Data Modeler also automates and standardizes model design tasks, including complex queries, to improve business alignment, ensure data integrity and simplify integration. With erwin Data Modeler, users experience these benefits:

Visualization of any data from anywhere

See structured or unstructured enterprise data regardless of location – in a relational or NoSQL database, a data warehouse, whether on-premises or in the cloud – within a single interface.

Automated data model & database schema generation

Automatically generate data models and database designs to increase efficiency and reduce errors.

Centralized model development & management

An integrated view of conceptual, logical and physical data models helps business and technical stakeholders understand data structures and meaning.

Data literacy, collaboration & accountability

Improve data intelligence and decision-making across the enterprise by maximizing the ability of stakeholders to use, understand and trust relevant data.

Agile application development

Consolidate and build applications with hybrid architectures, including traditional, NoSQL and Big Data, in the cloud and on-premises.

Increased data quality

By using data models to define and deploy enterprise data standards, you’ll realize more consistency and higher quality in data management.

Reduced risks & costs

Automation and standardization of data definitions and structures reduces risks and costs, plus you can test changes and new applications before they go into production.

Successful cloud adoption

Automated schema engineering and deployment accelerates and ensures successful adoption of cloud platforms, like Snowflake and Microsoft Azure, including auto documenting existing schema into reusable models.

erwin Data Modeler versions

erwin Data Modeler provides logical and physical modeling and schema engineering for relational, NoSQL and Big Data databases, data warehouses and data lakes. erwin Data Modeler is available in several versions with additional options to help customers improve the quality and agility of their data capabilities:
Learn More
Standard Edition
Workgroup Edition
Navigator Edition
Safyr Option
Web Portal
Standard Edition

Standard Edition

Includes reusable standards such as model templates, domains, automation macros, naming and datatype standards, and the widest range of model integration and interoperability bridges.

Why data modeling is better with erwin

erwin Data Modeler has been the most trusted name in data modeling for more than 30 years. The world’s top financial services, healthcare, critical infrastructure and technology companies, including those on the Fortune 500, use the erwin modeling tool. In today’s data-driven enterprise, its benefits have expanded to a wide range of architects, business analysts and data administrators to support their strategic initiatives. These are some of erwin Data Modeler’s unique advantages:

Modern, customizable modeling environment

Automate complex and time-consuming tasks for more effective database design, standardization, deployment and maintenance across all your database platforms. Visualize complex business and technical data structures, automatically generating data models in a single, intuitive interface.

Breadth of DBMS integrations & metadata bridges

Translate the technical format of the major cloud and on-premises database platforms into highly graphical models rich in metadata, thanks to built-in interfaces. erwin Data Modeler also provides out-of-the-box bridges for metadata exchange and transformation from other modeling environments, data management platforms and metadata exchange formats.

Model & database comparisons

The Complete Compare facility, with Quick Compare templates, automates bidirectional synchronization of models, scripts and databases; compares one item with another; displays any differences and permits selective updates, generating ALTER scripts when necessary.

Roundtrip engineering

Forward- and reverse-engineering of database code and model exchange ensures efficiency, effectiveness and consistency in designing, standardizing, deploying and documenting data structures for comprehensive enterprise database management.

Data catalog & business glossary integration

erwin Data Modeler is an essential source of, and one of the best ways to view, metadata. It’s a critical enabler of data governance and intelligence, so metadata from erwin data models can be harvested automatically and then ingested into our data catalog and business glossary.

Customer reviews

 

erwin Data Modeler: The Foundation of Data Governance & Intelligence

One of the most compelling use cases for erwin Data Modeler lies in its connection to the increasingly important and evolving realm of data governance. erwin Data Modeler Workgroup Edition provides a controlled central repository of data definitions and visibility into where and how properly defined data should be used.

With the addition of the erwin Data Intelligence Suite by Quest, you can:

  • Automatically harvest metadata from erwin data models and feed it into the erwin Data Catalog by Quest.
  • Create and integrate business and semantic metadata to augment physical data for ingestion into erwin Data Catalog to provide important context.
  • Accelerate the creation of business terms and rules within the erwin Data Literacy by Quest business glossary.
  • Make enterprise data assets accessible and understandable within the context of role-based views.
  • Provide guidance on the use of data and guardrails to ensure data policies and best practices are followed.

So data isn’t just for data professionals and developers. It’s everyone’s business if an enterprise wants to uncover meaningful insights that drive strategic use and business value. Data modeling is the foundation of enterprise metadata management and any data governance or data intelligence effort.

Get started now

erwin Data Modeler is a proven technology for improving the quality and agility of an organization’s overall data capability – and that includes data governance and data intelligence.

Support and services

Product Support

Get the help you need to install, configure and use erwin products.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.