ER/Studio Data Architect 21.0

Released: Mar 18, 2026

Updates in 21.0

Features

  • 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.

Fixes

  • 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.