Page tree

What's New in ER/Studio Data Architect 19.0.x

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

System Requirements

Type

PlatformVersion
Processor
Dual core or higher
Random Access Memory (RAM)
  • 4+ GB
Storage Disk Space
  • 2.5+ GB
Operating System

Microsoft Windows (64-bit)

  • 10
  • 8.1
  • 7
Software

To use an Open Data Base Connectivity (ODBC) database as a data source, install the ODBC driver on your client computer.

To connect to the DBMS using native connectivity, install the native client libraries available from the DBMS vendor.

Privileges

Local administrator privileges (required for installation only).

Appropriate permissions are required to reverse or forward engineer directly from or to a database.

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 Common Servern/a

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 Informix Dynamic Server

  • 9.x
M
IBM Informix OnLine and SE

n/a

M
IBM Netezza
  • 7.0
  • 6.0
  • 5.0
  • 4.6
M
Microsoft Access
  • 2013
  • 2000
  • 97
  • 95
  • 2.0
A
Microsoft Azure SQL Databasen/aS  MYes
Microsoft Azure Synapse Analyticsn/aS  MYes
Microsoft SQL Server and 
Microsoft SQL Server on Azure Virtual Machine (VM)
  • 2019
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008
  • 2005
  • 2000
  • 7
  • 6.5
S  MYes
Microsoft Visual FoxPro
  • 5
  • 3
  • 2
A
MongoDB
  • 3.6
  • 3.4
  • 3.2
  • 3.0
  • 2.6
M
MySQL
  • 8.x
  • 5.x
  • 4.x
  • 3.x
M
Oracle Database
  • 19c
  • 18c
  • 12c
  • 11g
  • 10g
  • 9i
  • 8.x
  • 7.x
S  MYes
ODBC / ANSI SQLn/a

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

Version History

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

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