ER/Studio 21.1 introduces new capabilities that help organizations extend enterprise data architecture beyond modeling into analytics, governance, and AI. This release transforms Enterprise Logical Data Models into reusable semantic assets, automates semantic layer generation for leading analytics platforms, and expands support for the latest enterprise database technologies.
With the new Semantic Generator, semantic layer generators for Microsoft Power BI, Open Semantic Interchange (OSI), and dbt, plus support for SQL Server 2025 and IBM Db2 z/OS 13 and LUW 12, ER/Studio 21.1 helps organizations establish a trusted semantic foundation while continuing to modernize their enterprise data platforms.
Enterprise Logical Data Models already capture the business definitions, relationships, identifiers, and rules that describe how an organization understands its data. ER/Studio 21.1 extends the value of those models by transforming them into machine-readable semantic assets that support governance, analytics, knowledge graphs, and AI.
The new Semantic Generator automatically produces standards-based semantic outputs, including Turtle RDF, SHACL constraints, and SKOS mappings, allowing organizations to establish a governed semantic backbone that preserves business meaning across the enterprise.
Key Highlights
ER/Studio 21.1 introduces automated generation of Microsoft Power BI semantic models directly from analytics-ready physical star schemas.
By carrying business names, descriptions, and metadata from the Enterprise Logical Data Model into Power BI, organizations can reduce manual semantic modeling, improve consistency across reports, and provide a stronger foundation for Microsoft Fabric, Copilot, and Power BI Q&A experiences.
Key Highlights
ER/Studio now supports generation of Open Semantic Interchange semantic layer definitions, helping organizations create portable semantic assets that can be reused across multiple analytics platforms.
This beta capability supports emerging open standards while helping reduce semantic drift and duplicated business logic.
Key Highlights
Organizations using dbt can now generate Semantic Layer artifacts directly from ER/Studio physical data models.
Business definitions, relationships, and metadata inherited from Enterprise Logical Data Models remain consistent across operational systems and analytics engineering workflows, helping reduce manual effort while improving trust in metrics and dashboards.
Key Highlights
ER/Studio 21.1 adds support for Microsoft SQL Server 2025, allowing organizations to continue modeling, reverse engineering, and generating DDL while modernizing to Microsoft’s latest database platform.
Key Highlights
Organizations upgrading to the latest IBM Db2 releases can now take advantage of full platform support within ER/Studio.
New support includes advanced indexing capabilities and security-related trigger syntax, helping keep enterprise models synchronized with production implementations while reducing manual post-generation changes.
Key Highlights
ER/Studio 21.1 extends enterprise data architecture beyond traditional modeling by transforming Enterprise Logical Data Models into reusable semantic assets for governance, analytics, and AI. Combined with automated semantic layer generation and support for the latest enterprise database platforms, this release helps organizations create a stronger semantic foundation for modern data ecosystems.
See the full release details and download ER/Studio 21.1 today.
Schedule a personalized demonstration to see ER/Studio 21.1 in action and learn how the new semantic capabilities can help strengthen your data architecture, analytics, governance, and AI initiatives.
