Page History
Table of Contents | ||||
---|---|---|---|---|
|
What's New in ER/Studio Data Architect
...
20.1.
...
x
For the new features and fixed issues in the latest version (18.5) 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)
...
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 | |||
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) | 10
| 5
| S M | Yes | ||
IBM Db2 for z/OS | 11
| 5
| S M | Yes | ||
IBM | Db2 CommonInformix Dynamic Server | n/a
| M | |||
IBM Informix OnLine and SE | n/a | M | IBM Informix Dynamic Server | 9.xM | ||
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 SQL Server on Azure Virtual Machine (VM)S M | Yes | |
Microsoft Visual FoxPro |
| A | ||||
MongoDB |
| S M | ||||
MySQL |
| M | ||||
Oracle Database |
| 3
| S M | Yes | ||
PostgreSQL | 12 to 10
| S M | Yes | |||
| 0
| M | ||||
SAP Adaptive Server Anywhere (ASA) |
| M | ||||
SAP Adaptive Server Enterprise (ASE) |
| 12.5
| 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.Please also refer to the product documentation ER/Studio Data Architect Import Bridges and ER/Studio MetaWizard Import/Export Bridges.
Version History
Table of Contents | ||||
---|---|---|---|---|
|
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
- 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
...
.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