Page History

What's New in ER/Studio Data Architect 20.1.x

For the new features and fixed issues in the latest version of ER/Studio Data Architect (version 18.5), see What's New.

System Requirements

Repository (ER/Studio Data Architect Professional only)

...

As standard, we include the reverse engineering from database and forward engineering of data definition language (DDL). Our core products also import from a SQL file and feature ALTER script generation from our compare and merge wizard.

MetaWizard Bridges

ER/Studio Data Architect includes a subset of  MetaWizard import bridges  to access files from common modeling tools.

ER/Studio Enterprise Team Edition includes the full list of  MetaWizard import and export bridges  that can import metadata from a wide range of technologies such as databases, data lake structures, flat files, business intelligence (BI), and data movement (ETL) tools.Please also refer to the product documentation ER/Studio Data Architect Import Bridges and ER/Studio MetaWizard Import/Export Bridges.

Version History

Version 20.1

• Adds support for Index column ordering in PostgreSQL 10.x-12.x
• Allows user-defined names for the History Table in Azure SQL DB and SQL Server

Version 18.5

• Offers new user interface features
• Supports Oracle 18c and 19c

Version 18.4

• Support Snowflake as core platform
• Added logical data types
• Added features for PostgreSQL

Version 18.3

• Expanded support for Amazon Redshift
• Expanded support for PostgreSQL

Version 18.2

• Supports Amazon Redshift
• New MITI bridge support

...

• Allows a user to select a region when reverse engineering in Google BigQuery

Version 20.0

• Includes an improved Diagram Data Version Upgrade user interface

• Repository Options dialog box now allows users to select whether to add DDL code to Team Server

• Adds support for comments on View Columns in the View Editor

• Includes the ability to change a relationship type for containment relationships in Google BigQuery and MongoDB

Version 19.3.5

• Improves connectivity to multiple Microsoft database platforms

• Adds support for Multi-Factor Authentication for reverse engineering of Azure SQL DB and Synapse

Version 19.3.4

• There are no new features but there are some fixed issues in this release.

Version 19.3.3

• There are no new features but there are some fixed issues in this release.

Version 19.3

• Adds support for Google BigQuery data warehouse

Version 19.2.2

• There are no new features but there are some fixed issues in this release.

Version 19.2

• Improves support for MongoDB
• Includes hierarchical visualization of MongoDB, XML, and JSON
• Supports JSON Instance files
• Allows users to switch between MongoDB and JSON Instance hierarchical platforms

Version 19.1.1

• There are no new features

...

• but there are some fixed issues in this release.

Version

...

19.1

There are no new features for this product version release.

Version 18.0

• Adds support for multiple Oracle 12c and later features
• Adds support for multiple Oracle 11g and later features

Version 19.0.1

• Supports additional features for SQL Server Temporal Tables
• Supports additional features for SQL Server In-Memory Optimized Tables
• Allows users to switch between open files
• Adds the Universal Mappings button to the Repository ribbon
• Adds the Diagram Properties button to the Model ribbon
• Adds quotation marks to the Field Names when generating the database JSON

Version 19.0

• Supports 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
• Supports the 'where' clause for SQL Server and Azure SQL DB filtered index
• Supports the ‘Columnstore’ indexes for SQL Server 2012
• Supports Spatial Indexes for SQL Server and Azure SQL DB
• Allows users to define table and index compression for SQL Server
• Allows users to model temporal tables in SQL Server
• Supports extended properties for SQL Server Tables and Columns
• Supports SQL Server 2019
• Adds tolerance support for MySQL 8.0
• Allows users to generate MongoDB model output as plain JSON
• Supports Azure Synapse Analytics
• Supports Inheritance Relationships for PostgreSQL
• Allows TLS between Data Architect and Repository
• Supports WITH CTE for SQL Server 2005+, Azure SQL DB, and Azure Synapse Analytics
• Improved publishing of models into Team Server
• Improved repository password encryption
• New option to to select SQL Server driver
• Supports Oracle Database 12c R2
• Discontinued 32-bit edition
  

|  

Newtabfooter
alias Resources url http://www.idera.com/resourcecentral

 | 

Newtabfooter
alias About Us url http://www.idera.com/about/aboutus

  | 

Newtabfooter
alias Legal url https://www.idera.com/legal/termsofuse