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 | |
Greenplum (Pivotal) |
| M | |
Hadoop Hive |
| M | |
Hitachi HiRDB | 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 Common Server | n/a | M | |
IBM Informix OnLine and SE | n/a | M | |
IBM Informix Dynamic Server |
| M | |
IBM Netezza |
| M | |
Microsoft Access |
| A | |
Microsoft Azure SQL Database | S M | Yes | |
Microsoft Azure Synapse Analytics | S M | Yes | |
Microsoft SQL Server and Microsoft SQL Server on Azure Virtual Machine (VM) |
| S M | Yes |
Microsoft Visual FoxPro |
| A | |
MongoDB |
| 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.
| | | | | | | |