Page History
...
The Repository for ER/Studio Data Architect Professional must be installed on a separate server.
Type | Platform | Version |
---|---|---|
Operating System | Microsoft Windows Server |
|
Database | Microsoft SQL Server (Express*, Standard, Enterprise) |
|
Oracle |
|
* Microsoft SQL Server Express available only for product trials and proof-of-concepts.
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.
...