What's New in ER/Studio 18.5

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

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 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.

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 DBMSn/aA

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.5

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


 |   |  |  |   |   |    |