ER/Studio 21.0 delivers meaningful updates shaped by how data teams are working today. As view-based warehouse designs become standard and governance expectations continue to rise, architects need better visibility into dependencies, simpler access controls, and a smoother day to day experience inside their modeling tools.
This release adds External Views support for Snowflake, SQL Server, and Synapse, Repository access via Okta SSO, a new in product AI Help Chatbot, and a refreshed Data Architect interface focused on clarity and usability.
With 21.0, ER/Studio removes a long-standing barrier to modeling today’s most common cloud warehouse patterns: view-based architectures built on external sources.
ER/Studio now supports External Views across Microsoft SQL Server, Azure Synapse Analytics, and Snowflake, enabling teams to confidently model databases where views reference external tables.
When reverse engineering, ER/Studio automatically captures upstream source metadata as lightweight replica objects, giving teams full visibility without forcing those sources into fully engineered physical models.
This reflects how many organizations build agile and cost-efficient Silver and Gold layers, where views provide flexibility without duplicating data, while still preserving governance and documentation.
Key Highlights:
ER/Studio 21.0 introduces Repository sign-in via SSO using Okta, helping teams simplify authentication and align ER/Studio access with enterprise identity standards.
With Okta SSO support, organizations can reduce sign-in friction, improve consistency across teams, and make Repository usage more seamless in managed environments.
Getting help while modeling is now faster than ever.
ER/Studio 21.0 adds a new AI Help Chatbot accessible directly from the Help menu.
Users can open a dedicated chatbot dialog, ask natural language questions, and receive guidance immediately without leaving ER/Studio. The chatbot runs alongside the modeling environment, allowing users to switch between work and support without interruption.
Links provided in responses open in the user’s default browser for easy follow-up.
Key Highlights:
ER/Studio 21.0 delivers a more modern look and feel across Data Architect, combining visual updates with practical usability improvements. The release introduces updated branding, refreshed icons throughout Explorer trees and dialogs, improved font handling, and a cleaner wizard experience with more usable working space.
The redesigned Welcome Page now serves as a practical starting point for both new and experienced users. With a modern browser style rendering engine, it provides direct access to video content, quick start guides, documentation, and curated learning resources, while ensuring pages display properly and links open in the user’s default browser.
Key Highlights:
With ER/Studio 21.0, teams can model External Views across today’s leading warehouse platforms, simplify Repository authentication with Okta SSO, get AI-powered help directly inside Data Architect, and work in a refreshed, modern UI built for daily productivity. See the full details here.
Schedule a one on one session to review ER/Studio 21.0 and discuss how the new features can support your warehouse architecture goals.
