Page History

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

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

System Requirements

Repository (ER/Studio Data Architect Professional only)

The Repository for ER/Studio Data Architect Professional is packaged with ER/Studio Team Server and must be installed on a separate server. For more information about ER/Studio Team Server, see ER/Studio Team Server Technical Specifications.

Database Platform Support

ER/Studio Data Architect can reverse and forward engineer data assets to document and design them. The following database platforms are supported.

Platforms

• Platforms marked with  S  can be selected for a single-platform license purchase.
• Platforms marked with  M  are available in our multi-platform license pack.
• Platforms marked with  A  are available in all packs.

Core Platforms

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.

Version History

Version

...

20.

...

• 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

Version 18.1.1

There are no new features for this product version release.

2

• Adds support for Databricks database platform

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

...

Version 18.0

...

• but there are some fixed issues in this release.

Version 19.1

• 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

|  

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