For the new features and fixed issues in the latest version of ER/Studio Data Architect, see What's New.
Type | Platform | Version |
---|---|---|
Random Access Memory (RAM) |
| |
Storage Disk Space |
| |
Operating System | Microsoft Windows (64-bit) |
|
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.
ER/Studio Data Architect can reverse and forward engineer data assets to document and design them. The following database platforms are supported.
Platforms
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 |
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 |
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.
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
Improves connectivity to multiple Microsoft database platforms
| | | | | | |