Skills 101 : erwin - Themes and Active Model Templates

In this Skills 101 session, Andy delivers a comprehensive deep dive into erwin Data Modeler themes and Active Model Templates (AMTs), demonstrating how these tools bring consistency, readability, and efficiency to enterprise data modeling workflows. He begins by guiding viewers through the process of cloning and customizing themes—adjusting colors, fonts, backgrounds, and display rules to create clean, standardized diagram visuals that help teams easily interpret complex models. He also shows how themes help reinforce modeling standards without slowing down productivity. The session then transitions into building and applying Active Model Templates, including setting naming standards, domains, user‑defined properties, and reusable diagram structures. Andy illustrates how templates accelerate repeatable modeling tasks, ensure adherence to naming and domain rules, and enable seamless synchronization between model changes and template updates. He also demonstrates binding and unbinding templates, comparing versions through the catalog manager, and overriding template settings when necessary—all essential techniques for maintaining consistent enterprise‑wide modeling practices.. Toward the end, Andy showcases erwin’s powerful forward‑engineering capabilities, generating DDL for multiple platforms—including SQL Server, Azure Synapse Lakehouse, Databricks, and PostgreSQL—while highlighting how the same logical model can be transformed to meet the standards of 33 supported database technologies. He closes by emphasizing how erwin’s modeling framework strengthens data quality initiatives and feeds into the broader Quest Data Management Platform, forming the foundation for trusted, AI‑ready data across the enterprise. Learn More