Released: May 23, 2025

Atualizações na 20.7

Recursos

• Added support for JSON Examples field
  • ER/Studio Data Architect 20.7 includes improvements for the JSON Instance database platform by now supporting "examples," which is a list of example values accepted by a field. When creating or editing a table, MongoDB and JSON Instance users may note a JSON tab which displays the JSON schema or JSON Instance. For JSON Instance, each field contains the default value, or first examples value, or first reference value, in that order of preference...

Released: Mar 10, 2025

Atualizações na 20.6

Recursos

• Data Vault Tools
  • New workflow macros generate Data Vault assets from model objects
    • Intelligent Hub Creation from Business Models.
    • Effortless Link & Satellite Generation.
    • Eliminating Source System-Driven Data Vaults.
    • Automated Data Lineage & Model Synchronization.
• Data Platform Support
  • Enables clients to design and document databases using the latest platform features
    • Oracle 23ai Support.
    • PostgreSQL 16 Support (includes support for include columns).
    • MS SQL Server 2022 Support...

Released: Dec 16, 2024

Atualizações na 20.5

Recursos

• PostgreSQL v16.x Support
  • Upgrade PostgreSQL support up to version 16.
  • Allow include columns for Postgres.
• Snowflake Support
  • Support for CTE views.
  • Support for hybrid tables.
  • Extended properties for a Primary Key Constraint.
• Google BigQuery Support
  • Support for Primary, FK, unique index and column defaults.
• Repository Security Improvements
  • Allow Data Architect to log in to the Repository via SSO using Azure Entra.

Released: Oct 26, 2024

Atualizações na 20.3.1

Recursos

• You can now resize the Entity Name text box in the Entity/Table Editor.
• Users can now access the Where tab from the Popout Attribute editor.

Correções

• Prevented the Diagram UI from freezing after multiple actions.
• Resolved a missing bitmap error for Business Data Objects.
• Resolved an issue with the Extended Properties API for Attributes in a macro.
• Resolved an issue resulting from canceling within the Domain Editor.
• Resolved an issue causing a crash when opening a file saved in ERDA...

Released: Aug 6, 2024

Atualizações na 20.3

Recursos

• Added support for Git - This release allows you to deploy a Devops process by integrating Data Architect with your Git repository. This feature allows you to commit CREATE DDL to your Git repository as well as use the Compare/Merge functionality to compare models with previous versions of that CREATE DDL in your Git repository. You can get started in setting up your Git integration by clicking the Git Options button in the Tools menu. You must be in the Physical Model view for this...

Released: Jun 8, 2024

Atualizações na 20.2

Recursos

• Added support for the Databricks database platform - This release includes a number of updates to support the Databricks database platform as a core platform, including basic constructs plus enhanced workflow capabilities. This functionality requires the installation of the Databricks ODBC driver, which allows reverse engineering operations to the Unity Data Catalog. Note that this implementation is based on the UDC version of Databricks and supports advanced features such as primary...

Released: Mar 19, 2024

Atualizações na 20.1

Recursos

• Added support for Index column ordering in PostgreSQL 10.x-12.x.
• You can now allow user-defined names for the History Table in Azure SQL DB and Microsoft SQL Server.
• Users can now select a region when reverse engineering in Google BigQuery.

Released: Nov 21, 2023

Atualizações na 20.0

Recursos

• Improved the 'Diagram Data Version Upgrade' user interface.
• Repository Options dialog box now allows users to select whether to add DDL code to Team Server.
• Added support for comments on View Columns in the View Editor.
• Added the ability to change a relationship type for containment relationships in Google BigQuery and MongoDB.

Released: Sep 27, 2023

Atualizações na 19.3.5

Recursos

• Improved database connectivity - Connectivity to the following Microsoft database platforms has been improved:
  • Azure SQL DB.
  • Azure SQL Managed Instance.
  • Azure Synapse.
  • SQL Server.
• Added support for Multi-Factor Authentication for Reverse Engineering of Azure SQL DB and Synapse - While generating a script file or database, reverse engineering an existing database, or using the Compare and Merge Utility, users can now choose from new authentication types for the following databases...

Released: Jun 15, 2023

Atualizações na 19.3.4

Recursos

• Added JSON modeling properties to COM API.
• Added the ability to select the number of items in an array in JSON - minItems and maxItems.

Correções

• PostgreSQL Table-level constraints generated incorrectly.
• JSON number field constraints must allow decimal values.
• JSON Strings with a format should not include width.
• Cannot set string without width in JSON.
• JSON format"date=time" incorrect syntax.
• Attachment binding disappears from foreign Key when deleting other attributes.
• Reverse engineer...