What's New in ER/Studio Data Architect 20.5.x
For the new features and fixed issues in the latest version of ER/Studio Data Architect, see What's New.
System Requirements
Type | Platform | Version |
|---|---|---|
| Random Access Memory (RAM) |
| |
| Storage Disk Space |
| |
| Operating System | Microsoft Windows (64-bit) |
|
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.
| Platform | Version | Platform | Core Platform |
|---|---|---|---|
| Amazon Redshift | n/a | S M | Yes |
| Databricks | n/a | S M | |
| Embarcadero InterBase |
| M | |
| Firebird |
| M | |
| Google BigQuery | n/a | S M | |
| Greenplum (Pivotal) |
| M | |
| Hadoop Hive |
| M | |
| Hitachi HiRDB | n/a | M | |
| IBM Db2 Common Server | n/a | M | |
| IBM Db2 for iSeries |
| M | |
| IBM Db2 for Linux, UNIX, and Windows (LUW) |
| S M | Yes |
| IBM Db2 for z/OS |
| S M | Yes |
| IBM Informix Dynamic Server |
| M | |
| IBM Informix OnLine and SE | n/a | M | |
| IBM Netezza |
| M | |
| JSON (Instance and Schema Files) | n/a | S M | |
| Microsoft Access |
| A | |
| Microsoft Azure SQL Database | n/a | S M | Yes |
| Microsoft Azure Synapse Analytics | n/a | S M | Yes |
| Microsoft SQL Server and Microsoft SQL Server on Azure Virtual Machine (VM) |
| S M | Yes |
| Microsoft Visual FoxPro |
| A | |
| MongoDB |
| S M | |
| MySQL |
| M | |
| Oracle Database |
| S M | Yes |
| PostgreSQL |
| S M | Yes |
| M | ||
| SAP Adaptive Server Anywhere (ASA) |
| M | |
| SAP Adaptive Server Enterprise (ASE) |
| S M | Yes |
| SAP IQ |
| M | |
| Snowflake | n/a | S M | Yes |
| Teradata |
| S M | Yes |
| Generic DBMS | n/a | A |
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.5
- Adds support for PostgreSQL up to version 16.x
- Improves support for Google BigQuery
- Improves support for Snowflake
- Improves repository security by allowing ERDA to log in via SSO using Microsoft Entra ID
Version 20.3
- Adds support for Git
Version 20.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 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