Released: Mar 19, 2024

Actualizaciones en 20.1

Características

• 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

Actualizaciones en 20.0

Características

• 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

Actualizaciones en 19.3.5

Características

• 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

Actualizaciones en 19.3.4

Características

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

Correcciones

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

Released: Jun 14, 2023

Actualizaciones en 19.3.3

Características

• Added OKTA SSO support for Team Server log in.
• Security improvements.
• Parent and Child Entities are now listed for Relationship lines.
• REST API performance improvements.
• Added Microsoft Azure Active Directory SSO support for Team Server log in.

Correcciones

• Cannot see datasets while reverse engineering Google BigQuery.
• Role names are not propagated for Containment lines.
• Batch publishing diagram fails.
• Team Server displays <!%_EMBT_REPO_OVERFLOW_%!> for attachments where...

Released: Oct 12, 2022

Actualizaciones en 19.3

Características

• Added support for Google BigQuery data warehouse - This functionality allows you to reverse engineer a live database, import BigQuery SQL files, and generate both SQL DDL code for new databases and also ALTER scripts through the Compare/Merge tool. This new functionality leverages existing MongoDB and JSON file support, where ER/Studio transforms between relational Logical models to hierarchical Physical models, repeatably handling nested objects to take advantage of BigQuery...

Released: Jun 1, 2022

Actualizaciones en 19.2

Características

• Added support for MongoDB 4.x - This release includes tolerance support for MongoDB 4.0-4.4.
• Added SCRAM authentication option as default for MongoDB.
• Added support for importing JSON Objects from JSON documents - ER/Studio Data Architect now lets you create a data model by importing JSON files using a JSON document, in .json or .txt format. Importing these files allows you to create a MongoDB physical model or JSON Instance physical model.
• Added support for switching a MongoDB...

Released: Nov 16, 2021

Actualizaciones en 19.1.1

Correcciones

• Resolved the View Validation Results window scroll issue.
• PostgreSQL CHAR/VARCHAR is no longer off by four bytes when reverse-engineering.
• Import from SQL Script for Snowflake now handles UNBOUNDED, CLUSTER BY.
• Resolved an issue with the Macro functions on Model object lists.
• Long object names now are supported for PostgreSQL reverse-engineer.
• PK constraints now are properly imported from SQL on SQL Server.
• DDL now is generated for sequences without schema names.
• Reverse-engineering...

Released: Aug 1, 2021

Actualizaciones en 19.1

Características

• Added support for the following Oracle 12c and later features:
  • External tables - External tables allow Oracle to query data stored outside of the database in flat files. Use the Table Editor option to designate an external table and gain access to the External Table Properties dialog for further definition of the table.
  • Added support for saving varchar size units as BYTE or CHAR for physical models.
  • Subpartitioning by RANGE - Range partitioning distributes data based on a given...

Released: Jun 4, 2021

Actualizaciones en 19.0.0

Características

• Added support for Microsoft Azure Active Directory Password authentication method.
• Allows users to log in to Team Server when logging into Repository.
• Allows users to relate Business Terms with ER Objects.
• Added support for the 'where' clause for Microsoft SQL Server and Microsoft Azure SQL DB filtered index.
• Added support for the ‘Columnstore’ indexes for SQL Server 2012.
• Added support for Spatial Indexes for SQL Server and Azure SQL DB.
• Allows users to define table and index...