Page tree

What's New in ER/Studio Data Architect 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

  • Platforms marked with S can be selected for a single-platform license purchase.
  • Platforms marked with M are available in our multi-platform license pack.
  • Platforms marked with A are available in all packs.

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 Redshiftn/aS  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 HiRDBn/aM
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 Servern/aM
IBM Informix OnLine and SEn/aM
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 and 
Microsoft SQL Server on Azure Virtual Machine (VM)
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008
  • 2005
  • 2000
  • 7
  • 6.5
  • 4.x
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 10
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
Snowflaken/aS  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

  • Offers new user interface features
  • Supports Oracle 18c and 19c

Version 18.4

  • Support Snowflake as core platform
  • Added logical data types
  • Added features for PostgreSQL

Version 18.3

  • Expanded support for Amazon Redshift
  • Expanded support for PostgreSQL

Version 18.2

  • Supports Amazon Redshift
  • New MITI bridge support

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

  • Improved publishing of models into Team Server
  • Improved repository password encryption
  • New option to to select SQL Server driver
  • Supports Oracle Database 12c R2
  • Discontinued 32-bit edition


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal