Allows users to export logical models in RDF Turtle (.ttl) format:
ER/Studio Data Architect 21.1 allows users to export a logical model or single submodel as a semantic model in RDF Turtle (.ttl) format. The exported file is a standards-compliant OWL 2 ontology that includes SHACL validation shapes and can optionally incorporate SKOS concepts generated from Team Server glossary terms associated with model objects.
Use this feature to integrate your data model with semantic web, knowledge graph, and data governance tools, such as ontology editors (for example, Protégé), RDF triple stores, and governance platforms. It also enables you to align your data model with your organization's enterprise vocabulary.
While viewing an active logical model or submodel, you can start exporting using one of the following methods:
In the ribbon menu, click File > Export File > Export RDF (Turtle).
In the Data Model Explorer tree, right-click the appropriate model, and then select Export RDF (Turtle).
In the Data Window, right-click an empty area within the logical diagram, and then select Export RDF (Turtle).
Allows users to export physical models in three industry-standard semantic formats:
Use ER/Studio Data Architect 21.1 to export a physical data model to one of the following industry-standard semantic formats used by modern BI and analytics-engineering tools:
Microsoft Power BI Semantic Layer Generator (TMDL).
Open Semantic Interchange (OSI) Generator (Beta).
DBT Labs Semantic Layer Generator (Beta).
All three formats are produced by a single sample macro called Physical Model Export to Semantic Formats. Users can choose the target format when running the macro. This macro reads a physical model (and, when present, its linked logical model for extra business context), and writes the corresponding files to a folder you select.
Added support for IBM Db2 including new features:
ER/Studio 21.1 adds support for:
IBM Db2 LUW v12.
IBM Db2 z/OS v13.
Added the following new features:
Db2 triggers SECURED / NOT SECURED syntax.
Db2 z/OS INCLUDE clause for unique indexes.
Added support for MS SQL Server 2025:
This release of ER/Studio includes support for MS SQL Server 2025.
ER/Studio 21.0.12026年5月18日
修正
Maintains DDL for replica views with column names containing parentheses.
Reverse engineers referenced external views with a different schema.
Handles case differences in referenced external views when reverse engineering from Snowflake.
Validates views that reference replica views immediately upon reverse-engineer.
Properly maintains child view validation when parent views are edited.
Validates views that contain quotes on table names in the view DDL.
Validates Snowflake views with inline column comments.
Improves performance saving files with many physical models.
Prevents re-use of database connection in rare race conditions.
Improves memory handling and cleanup in Repository service.
ER/Studio 21.0主要版本2026年3月18日
功能
Updates ER/Studio branding
New and more modern branding in many areas of the products. New colors, icons, and updated wizards and dialogs.
Introduces the AI Chatbot
Provides additional assistance to users through the use of the AI Help Chatbot. Accessed by clicking the question mark Help icon in the upper right-hand corner of the window, users can ask specific questions regarding the product and its use. The AI Help Chatbot then works with the user to find exactly what they are searching for.
Adds support for Replica Tables and Replica Views
Introduces support for cross-database references of Database.Schema.Table (Replica Table) and Database.Schema.View (Replica View) for the following database platforms:
Azure Synapse Analytics.
Snowflake.
SQL Server 2019 and 2022.
This feature allows users to work with Replica Tables and Replica Views and supports reverse engineering of external dependencies for Views.
Improves repository security by allowing ERDA to log in via SSO using Okta
Enterprise users who have Okta configured in Team Server now can log into Team Server and repository from Data Architect via SSO using Okta.
Adds support for TLS 1.3
ER/Studio Data Architect and Repository 21.0 now use TLS 1.3 as the default protocol for all secure communications. This support includes the following cipher suites:
TLS_AES_128_GCM_SHA256 Enabled by default.
TLS_AES_256_GCM_SHA384 Enabled by default.
TLS_CHACHA20_POLY1305_SHA256 Enabled by default.
TLS_AES_128_CCM_SHA256.
ER/Studio Enterprise
Enhanced security with updated core components.
Added ERBA Definition and Notes fields to Team Server Task pages.
Ensured compatibility with ER/Studio Data Architect and Team Server 21.0.x.
修正
Repository Project Names with special characters no longer prevent viewing objects in Team Server.
Add Team Server/Repository support for MS SQL Server 2025.
Users can now see diagrams properly in Team Server when applying No Access on a separate project.
Allows Get Diagram operations to complete with non-ASCII characters.
Removes unnecessary Where Used data from Repository for improved performance.
Imports inline column comments from SQL file for Snowflake.
Prevents crash when importing PostgreSQL 13-16 SQL with triggers.
Prevents crash when using Compare/Merge after performing Dernormalizations.
Updates the OpenSSL library.
Allows users to use the Snowflake view parsers for logical models.
Prevents crash when reverse-engineering views that reference external tables with JSON data.
Allows embedded JSON structures when custom JSON datatype is used
Provides the ability to publish diagrams on Confluence from Data Architect.
Prevents crash in Repository after database disconnect.
Improves performance when checking in Data Dictionary changes.
Updates and modernizes Welcome Page.
Introduces support for the AI Help Chatbot
Allows user to increase font size in trees and grids.
Generates correct alter SQL when modifying datatypes in PostgreSQL.
Properly removes internal Where Used data preventing increasing file size.
Allows Data Architect Universal Mappings editor to access Business Architect objects.
Correctly recreates constraints in SQL in extended alters.
Maintains View DDL properly after edit.
Allows Data Architect to log in to the Repository via SSO using Okta.
Significantly improves performances when closing a large file while other files remain open.
Adds support for cross-database references of Database.Schema.Table and Database.Schema.View.
Adds support for TLS 1.3 for connections with the Repository.
Prevents GUI font from being stretched.
Improves performance when closing the Macro editor.
Avoids Repository error after deleting models containing denormalizations.
Adds cleanup process to ensure temporary Repository files are removed after 24 hours.