Data Modeling for Multi-Platform Environments

ER/Studio Data Architect

Data Architect

Minimum hardware:

  • 4GB RAM
  • 2.5GB disk space

Operating Systems Supported:

  • Windows 7, 8.1, 10 (64-bit)

Supported Platforms:

Native support: ER/Studio Data Architect has database-specific support for several platforms, using the native connection protocol for the platform to access a broader set of the database features.

  • Hadoop Hive 0.12, 0.13
  • IBM® Db2® for z/OS 5.x - 11.x
  • IBM Db2 for LUW 5.x - 10.x
  • Microsoft Azure SQL Database
  • Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014, 2016, 2017
  • Microsoft SQL Server on Azure and AWS VMs
  • MongoDB 3.4, 3.6
  • Oracle® 7.3, 8.x, 9i, 10g, 11g, 12c
  • SAP Adaptive Server® Enterprise (ASE) 11.9.2, 12.x, 12.5, 15.0

ODBC connections: ER/Studio Data Architect accesses these databases through platform-specific or generic ODBC connections with user-provided drivers.

  • Platform-specific
    • Amazon Redshift
    • Firebird® 1.5, 2.x
    • Greenplum 4.2
    • Hitachi HiRDB
    • IBM Db2 for iSeries V4R5 and V5R2
    • IBM Informix® OnLine and SE
    • IBM Informix 9.x dynamic server
    • IBM Netezza 4.6, 5.0, 6.0, 7.0
    • Embarcadero InterBase® 4, 2007, 2009
    • Embarcadero InterBase XE, XE3
    • Microsoft® Access 2.0, 95, 97, 2000
    • Microsoft Visual FoxPro® 2, 3, 5
    • MySQL® 3.x, 4.x, 5.x
    • PostgreSQL 8.x, 9.x
    • SAP Adaptive Server Anywhere (ASA) 5, 6, 7, 8, 9, 10
    • SAP IQ 12.x, 15.x, 16.x
    • SAP Watcom SQL
    • Teradata® V2R4, V2R5, V2R6, 12, 13.0, 14.x, 15.10
    • Generic DBMS

Single-Platform Options: These platforms include forward-engineering support for DDL and ALTER code, and can be selected for a single-platform license purchase.

  • Amazon Redshift
  • IBM DB2 for LUW
  • IBM DB2 for z/OS
  • Microsoft Azure SQL DB
  • Microsoft SQL Server
  • Oracle
  • PostgreSQL (add now in anticipation of 18.3)
  • SAP Adaptive Server® Enterprise (ASE)
  • Teradata

ER/Studio Data Architect also includes a subset of MetaWizard import bridges to access files from common modeling tools.

Data Architect Professional - Repository Requirements

NOTE: The DA-Pro Repository must be installed on a separate server.

Supported Operating Systems

  • Windows Server 2012 R2 - 2016

Supported Database Platforms

  • Microsoft SQL Server 2012 - 2017
  • Oracle 11g, 12cR2
No credit card required! Fully functional for 14 days ER-StudioDataArchitect

Buy Now

Includes first year of maintenance.

Add to Cart

Request a Quote

Live Product Demo

See ER/Studio Data Architect in action with a seasoned pro.

Request a Demo