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 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) |
|
...
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) |
| S M | Yes | |||
IBM Db2 for z/OS |
| S M | Yes | |||
IBM | Db2 CommonInformix Dynamic Server | n/a
| M | |||
IBM Informix OnLine and SE | n/a | M | ||||
IBM | Informix Dynamic Server
| M | IBMNetezza |
| 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.
...
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
...