What's New
For the new features and fixed issues in the latest version of ER/Studio Data Architect (version 18.5), see What's New.
System Requirements
Type | Platform | Version |
|---|---|---|
| Random Access Memory (RAM) |
| |
| Storage Disk Space |
| |
| Operating System | Microsoft Windows (64-bit) |
|
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.
| Platform | Version | Platform | Core Platform |
|---|---|---|---|
| Amazon Redshift | S M | Yes | |
| Embarcadero InterBase |
| M | |
| Firebird |
| M | |
| Greenplum (Pivotal) |
| M | |
| Hadoop Hive |
| M | |
| Hitachi HiRDB | M | ||
| IBM Db2 for iSeries |
| M | |
| IBM Db2 for Linux, UNIX, and Windows (LUW) |
| S M | Yes |
| IBM Db2 for z/OS |
| S M | Yes |
| IBM Db2 Common Server | M | ||
| IBM Informix OnLine and SE | M | ||
| IBM Informix Dynamic Server |
| M | |
| IBM Netezza |
| M | |
| Microsoft Access |
| A | |
| Microsoft Azure SQL Database | S M | Yes | |
| Microsoft SQL Server |
| S M | Yes |
Microsoft SQL Server on Azure Virtual Machine (VM) | S M | Yes | |
| Microsoft Visual FoxPro |
| A | |
| MongoDB |
| M | |
| MySQL |
| M | |
| Oracle Database |
| S M | Yes |
| PostgreSQL |
| S M | Yes |
| M | ||
| SAP Adaptive Server Anywhere (ASA) |
| M | |
| SAP Adaptive Server Enterprise (ASE) |
| S M | Yes |
| SAP IQ |
| M | |
| Snowflake | S M | Yes | |
| Teradata |
| S M | Yes |
| Generic DBMS | n/a | 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
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