Versions Compared

Old Version 12

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 13

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
minLevel2

What's New in ER/Studio Data Architect

...

19.

...

1

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

...

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 Azure Synapse Analytics
S MYes
Microsoft SQL Server and 
Microsoft SQL Server on Azure Virtual Machine (VM)
  • 2019
  • 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
  • 8.0
  • 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.012.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

...

Table of Contents
maxLevel3
minLevel3

Version 19.0.1

  • Supports additional features for SQL Server Temporal Tables
  • Supports additional features for SQL Server In-Memory Optimized Tables
  • Allows users to switch between open files
  • Adds the Universal Mappings button to the Repository ribbon
  • Adds the Diagram Properties button to the Model ribbon
  • Adds quotation marks to the Field Names when generating the database JSON

Version 19.0

  • Supports Azure Active Directory Password authentication method
  • Allows users to log in to Team Server when logging into Repository
  • Allows users to relate Business Terms with ER Objects
  • Supports the 'where' clause for SQL Server and Azure SQL DB filtered index
  • Supports the ‘Columnstore’ indexes for SQL Server 2012
  • Supports Spatial Indexes for SQL Server and Azure SQL DB
  • Allows users to define table and index compression for SQL Server
  • Allows users to model temporal tables in SQL Server
  • Supports extended properties for SQL Server Tables and Columns
  • Supports SQL Server 2019
  • Adds tolerance support for MySQL 8.0
  • Allows users to generate MongoDB model output as plain JSON
  • Supports Azure Synapse Analytics
  • Supports Inheritance Relationships for PostgreSQL
  • Allows TLS between Data Architect and Repository
  • Supports WITH CTE for SQL Server 2005+, Azure SQL DB, and Azure Synapse Analytics

Version 18.5

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

...