Tech Specs: ER/Studio Data Architect

Technical Specifications

What Is New

Expand

Version 18.4

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

Please refer also to the product documentation What's New in ER/Studio Data Architect and Read Me.


System Requirements

Expand

Desktop Console

  • Random-access memory (RAM): 4 GB +
  • Storage disk space: 2.5 GB +
  • Microsoft Windows: 10, 8.1, 7; 64-bit

Please also refer to the product documentation Installing IDERA ER/Studio Data Architect on page 7.


Platform Support

Expand

Database Platforms

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.

Platform Core Platform

Amazon Redshift

S M

Yes

Embarcadero InterBase: XE3, XE

M

Embarcadero InterBase: 2009, 2007, 4

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 UDB for Linux, UNIX and Windows (LUW): 10.x to 5.x

S M

Yes

IBM Db2 UDB Server for OS/390 and z/OS: 11.x to 5.x

S M

Yes

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 Azure SQL Database

S M

Yes

Microsoft SQL Server: 2017, 2016, 2014, 2012, 2008, 2005, 2000, 7, 6.5, 4.x

S M

Yes

Microsoft SQL Server on Azure VM

S M

Yes

Microsoft Visual FoxPro: 5, 3, 2

A

Microsoft Access: 2013, 2000, 97, 95, 2.0

A

MongoDB: 3.6, 3.4, 3.2, 3.0, 2.6

M

MySQL: 5.x, 4.x, 3.x

M

Oracle Database: 12c, 11g, 10g, 9i, 8.x, 7.3

S M

Yes

PostgreSQL: 9.x, 8.0

M

PostgreSQL: 12 to 9.4

S M

Yes

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 M

Yes

SAP IQ: 16.x, 15.x, 12.x

M

Snowflake

S M

Yes

Teradata: 15.10, 14.x, 13.0, 12, V2R6, V2R5, V2R4

S M

Yes

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

Expand

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 in this product version release.

Version 18.1

There are no new features in 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

Please refer also to the product documentation Version 18.3 - What's New in ER/Studio Data Architect and Version 18.3 - Read Me.

Try ER/Studio Data Architect FREE for 14 days

Improve data quality, enhance data lineage, and create effective data models to build business-driven data architecture with ER/Studio Data Architect.

Start for Free


Share This
Contact IDERA:
+1 (713) 523-4433