What's New

For the new features and fixed issues in the latest version of ER/Studio Data Architect, see What's New.

System Requirements

Type

PlatformVersion
Random Access Memory (RAM)
  • 4+ GB
Storage Disk Space
  • 2.5+ GB
Operating System

Microsoft Windows (64-bit)

  • 10
  • 8.1
  • 7

Repository (ER/Studio Data Architect Professional only)

The Repository for ER/Studio Data Architect Professional must be installed on a separate server.

TypePlatformVersion
Operating SystemMicrosoft Windows Server
  • 2016
  • 2012 R2
DatabaseMicrosoft SQL Server (Express*, Standard, Enterprise)
  • 2019
  • 2017
  • 2016
  • 2014
  • 2012
Oracle
  • 12cR2
  • 11g

* Microsoft SQL Server Express available only for product trials and proof-of-concepts.

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

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.

PlatformVersionPlatformCore Platform
Amazon Redshift
S  MYes
Embarcadero InterBase
  • XE3
  • XE
  • 2009
  • 2007
M
Firebird
  • 2.x
  • 1.5
M
Greenplum (Pivotal)
  • 4.2
M
Hadoop Hive
  • 0.13
  • 0.12
M
Hitachi HiRDB
M
IBM Db2 for iSeries
  • V5R2
  • V4R5
M
IBM Db2 for Linux, UNIX, and Windows (LUW)
  • 10.x to 5.x
S  MYes
IBM Db2 for z/OS
  • 11.x to 5.x
S  MYes
IBM Db2 Common Server
M
IBM Informix OnLine and SE
M
IBM Informix Dynamic Server
  • 9.x
M
IBM Netezza
  • 7.0
  • 6.0
  • 5.0
  • 4.6
M
Microsoft Access
  • 2013
  • 2000
  • 97
  • 95
  • 2.0
A
Microsoft Azure SQL Database
S  MYes
Microsoft SQL Server
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008
  • 2005
  • 2000
  • 7
  • 6.5
  • 4.x
S  MYes

Microsoft SQL Server on Azure Virtual Machine (VM)


S  MYes
Microsoft Visual FoxPro
  • 5
  • 3
  • 2
A
MongoDB
  • 3.6
  • 3.4
  • 3.2
  • 3.0
  • 2.6
M
MySQL
  • 5.x
  • 4.x
  • 3.x
M
Oracle Database
  • 19c
  • 18c
  • 12c
  • 11g
  • 10g
  • 9i
  • 8.x
  • 7.3
S  MYes
PostgreSQL
  • 12 to 9.4
S  MYes
  • 9.x
  • 8.0
M
SAP Adaptive Server Anywhere (ASA)
  • 10
  • 9
  • 8
  • 7
  • 6
  • 5
M
SAP Adaptive Server Enterprise (ASE)
  • 15.0
  • 12.5
  • 12.x
  • 11.9.2
S  MYes
SAP IQ
  • 16.x
  • 15.x
  • 12.x
M
Snowflake
S  MYes
Teradata
  • 15.10
  • 14.x
  • 13.0
  • 12
  • V2R6
  • V2R5
  • V2R4
S  MYes
Generic DBMS
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

Version 18.4

Version 18.3

Version 18.2

Version 18.1.1

There are no new features for this product version release.

Version 18.1

There are no new features for this product version release.

Version 18.0


 |   |  |  |   |   |    |