First Look at ER/Studio 21.1

01

ER/Studio Semantic Generator

Enterprise Logical Data Models contain far more than database structures. They capture the business concepts, definitions, relationships, and rules that explain how an organization understands its data.

The new ER/Studio Semantic Generator transforms these governed models into standards-based semantic assets that can be consumed by governance platforms, semantic technologies, knowledge graphs, analytics environments, and AI systems.

Instead of recreating business meaning across multiple platforms, organizations can define it once and reuse it everywhere.

02

Microsoft Power BI Semantic Layer Generator

Power BI has become one of the most widely used analytics platforms in the enterprise, making semantic consistency more important than ever.

The new Power BI Semantic Layer Generator creates semantic layer artifacts directly from analytics-ready physical star schemas while carrying forward business names, descriptions, and metadata inherited from the Enterprise Logical Data Model.

Analytics teams can begin with approved enterprise definitions instead of recreating them manually.

03

As organizations adopt multiple analytics platforms, maintaining consistent business meaning becomes increasingly difficult.

The Open Semantic Interchange (OSI) Generator produces standards-based semantic artifacts that support interoperability while preserving trusted enterprise definitions across evolving analytics ecosystems.

04

The new dbt Semantic Layer Generator enables analytics teams to generate dbt semantic layer artifacts directly from ER/Studio models while preserving governed business definitions, relationships, and metadata.

The result is less manual effort, greater consistency, and stronger alignment between enterprise architecture and analytics engineering.

05

Alongside its semantic innovations, ER/Studio 21.1 continues to expand support for the enterprise database platforms organizations rely on every day.