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

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

System Requirements

Type

PlatformVersion
Random Access Memory (RAM)
  • 4+ GB
Storage Disk Space
  • 2.5+ GB
Operating System

Microsoft Windows (64-bit)

  • 11
  • 10
  • 8.1
  • 7

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.

PlatformVersionPlatformCore Platform
Amazon Redshiftn/aS  MYes
Embarcadero InterBase
  • 2009
  • 2007
  • XE3
  • XE
M
Firebird
  • 2.x
  • 1.5
M
Google BigQueryn/aS M
Greenplum (Pivotal)
  • 4.2
M
Hadoop Hive
  • 0.13
  • 0.12
M
Hitachi HiRDBn/aM
IBM Db2 Common Servern/aM
IBM Db2 for iSeries
  • V5R2
  • V4R5
M
IBM Db2 for Linux, UNIX, and Windows (LUW)
  • 5.x to 10.x
S  MYes
IBM Db2 for z/OS
  • 5.x to 11.x
S  MYes
IBM Informix Dynamic Server
  • 9.x
M
IBM Informix OnLine and SEn/aM
IBM Netezza
  • 7.0
  • 6.0
  • 5.0
  • 4.6
M
JSON (Instance and Schema Files)n/aS M
Microsoft Access
  • 2013
  • 2000
  • 97
  • 95
  • 2.0
A
Microsoft Azure SQL Databasen/aS  MYes
Microsoft Azure Synapse Analyticsn/aS MYes
Microsoft SQL Server and 
Microsoft SQL Server on Azure Virtual Machine (VM)
  • 2019
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008
  • 2005
  • 2000
  • 7
  • 6.5
S  MYes
Microsoft Visual FoxPro
  • 5
  • 3
  • 2
A
MongoDB
  • 4.x
  • 3.6
  • 3.4
  • 3.2
  • 3.0
  • 2.6
S M
MySQL
  • 8.0
  • 5.x
  • 4.x
  • 3.x
M
Oracle Database
  • 19c
  • 18c
  • 12c
  • 11g
  • 10g
  • 9i
  • 8.x
  • 7.x
S  MYes
PostgreSQL
  • 10.x to 12.x
S  MYes
  • 9.x
  • 8.x
M
SAP Adaptive Server Anywhere (ASA)
  • 10
  • 9
  • 8
  • 7
  • 6
  • 5
M
SAP Adaptive Server Enterprise (ASE)
  • 15.0
  • 12.x
  • 11.9.2
S  MYes
SAP IQ
  • 16.x
  • 15.x
  • 12.x
M
Snowflaken/aS  MYes
Teradata
  • 15.10
  • 14.x
  • 13.0
  • 12
  • V2R6
  • V2R5
  • V2R4
S  MYes
Generic DBMSn/aA

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

  • 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


IDERA |  Products | Purchase | Support |  Resources |  About Us  | Legal