erwin Data Modeler

erwin Data Modeler by Quest is an award-winning graphical data modeling solution helping leading organizations worldwide find, visualize, design, deploy and standardize high-quality enterprise data assets. As the gold standard for more than 30 years, erwin Data Modeler has helped thousands of organizations reduce costs and enable faster time to value when designing, developing and delivering the data sources their businesses rely on each day. By automating and standardizing model design tasks, erwin fuels business alignment, ensures data integrity, and simplifies downstream integration. Visualization of database schema, market-leading model comparison capabilities, and integration with semantic and governance detail ensure and accelerate data source understanding.

erwin Data Modeler provides cross-platform DBMS support with native connectivity, schema modeling, database design, migration and engineering support for Microsoft Azure SQL Database and Azure Synapse. Speed the adoption of the Azure Synapse with robust design, documentation and CDM driven semantic integration for data lakes, data warehouses and other applications, collaborative modeling governance and the automated transformation of legacy models to deployable Azure Synapse models.

Key erwin Data Modeler capabilities include:

• A modern, customizable logical and physical data modeling environment.
• The widest array of DBMS support, including all major NoSQL DBs, and out-of-the-box model integration bridges.
• Support for ERD, JSON, Data Vault, and Dimensional modeling.
• Integration with third-party semantic models, including the Microsoft Common Data Model.
• Tight integration with Git and GitHub.
• Comprehensive compare and sync capabilities with design layer support.
• Reusable design standards templates.
• Auto-documentation of existing databases into graphical models.
• Centralized model repository and collaborative modeling with conflict resolution and change management with auditing.
• Model and metadata reporting and web publication.
• Optional integration with erwin Data Intelligence by Quest for data catalog, data quality, data governance and data literacy.