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