Page History
...
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
...
The Repository for ER/Studio Data Architect Professional is packaged with ER/Studio Team Server and must be installed on a separate server.
...
- 2016
- 2012 R2
...
- 2019
- 2017
- 2016
- 2014
- 2012
...
- 12cR2
- 11g
* Microsoft SQL Server Express available only for product trials and proof-of-conceptsFor 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 |
...
Table of Contents | ||||
---|---|---|---|---|
|
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
...