ER/Studio 21.1 Expands Data Models Into Semantic Layers for AI and Analytics

New semantic generators turn definitions and relationships in enterprise data models into reusable semantic layers for AI, Power BI, dbt, and governance.

AUSTIN, TX, UNITED STATES, September 14, 2026 /EINPresswire.com/ — ER/Studio, an enterprise data architecture and modeling platform, announced the availability of ER/Studio 21.1, introducing new semantic generation capabilities in Data Architect that turn business definitions and relationships captured in Enterprise Logical Data Models into reusable semantic assets for analytics, governance, and AI.

Organizations already use enterprise data models to define critical business concepts, relationships, rules, and terminology. ER/Studio 21.1 builds on that foundation by generating semantic models and machine-readable semantic assets from those existing models, allowing teams to reuse established business context across technologies including Microsoft Power BI, Microsoft Purview, Collibra, dbt, and open semantic ecosystems.
The result is a more consistent semantic backbone that can help organizations reduce conflicting definitions, limit duplicated semantic modeling, and provide analytics and AI applications with clearer business context.

“AI is making consistent business meaning more important than ever,” said Jamie Knowles, Product Director of ER/Studio. “Organizations have spent years capturing critical business knowledge in their enterprise data models, but much of that context has traditionally remained inside the modeling environment. ER/Studio 21.1 makes that knowledge reusable, allowing organizations to carry governed business meaning into analytics, governance, and AI instead of recreating it independently in every platform.”

“The challenge for enterprises isn’t a lack of data. It’s making sure that data means the same thing everywhere it is used,” said Max Hunsicker, General Manager of ER/Studio. “ER/Studio 21.1 extends the value of enterprise data modeling beyond database design by making established business meaning reusable across analytics, governance, and AI. That gives organizations a stronger foundation for scaling these initiatives without continually recreating the same context.”

New Semantic Generation Capabilities in ER/Studio 21.1
ER/Studio 21.1 introduces several new capabilities designed to make enterprise business context reusable across modern data environments:
• Semantic Generator: Converts Enterprise Logical Data Models into machine-readable semantic assets, including Resource Description Framework (RDF), SHACL constraints, and SKOS mappings, for governance platforms, knowledge graphs, semantic technologies, and AI applications.
• Microsoft Power BI Semantic Layer Generator: Generates Tabular Model Definition Language (TMDL) structures and Power BI Project (PBIP) files from analytics-ready physical star schemas while carrying business names, descriptions, and metadata into Power BI.
• Open Semantic Interchange Generator (Beta): Creates OSI semantic definitions from ER/Studio models to support reusable business meaning across analytics technologies.
• dbt Semantic Layer Generator (Beta): Generates dbt Semantic Layer artifacts from ER/Studio physical data models while preserving connections to business definitions inherited from Enterprise Logical Data Models.
Together, these capabilities reinforce a central principle behind ER/Studio 21.1: define business meaning once and reuse it across the technologies that depend on it.

By making enterprise model metadata reusable across analytics, governance, and AI environments, organizations can reduce the need to recreate semantic definitions independently in each platform and help limit semantic drift as their data ecosystems expand.
Expanded Support for Enterprise Database Platforms

ER/Studio 21.1 also adds support for Microsoft SQL Server 2025, IBM Db2 z/OS 13, and IBM Db2 LUW 12, helping architecture teams keep their models aligned with current enterprise database environments.
ER/Studio 21.1 is available now.

Learn more about ER/Studio 21.1 at: https://utm.io/usQRK

About ER/Studio
ER/Studio is an enterprise data architecture and modeling platform that helps organizations design, understand, govern, and connect complex data environments. For more than 30 years, ER/Studio has helped data architects, modelers, developers, and governance teams create shared business meaning across enterprise data and translate business requirements into scalable data systems.
With conceptual, logical, and physical data modeling, enterprise metadata, governance integration, and collaboration capabilities, ER/Studio helps organizations build a trusted foundation for data, analytics, and AI.

Kortney Phillips
ER/Studio
+1 8145537522
kortney.phillips@idera.com
Visit us on social media:
LinkedIn
YouTube
X

ER/Studio 21.1: Turn Enterprise Data Models Into Reusable Semantic Layers for AI, Power BI, dbt, and Governance

Media gallery