ER/Studio

From Wikipedia, the free encyclopedia
Jump to: navigation, search

ER/Studio is data architecture and database design software developed by Embarcadero Technologies. ER/Studio is compatible with multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data assets. In 2015, Embarcaero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.[1]

Features[edit]

  • Logical and physical design support
  • XML Schema generation from either the logical or physical models
  • Automation and scripting support
  • Forward- and reverse- engineering
  • Automated database code generation
  • Integration of models and metadata
  • Collaboration support including sub model management, repository, “where used”
  • Presentation formats include HTML, RTF, XML Schema, PNG, JPEG and DTD Output
  • Integrate model metadata with other platforms such as BI, ETL, and other modeling tools.
  • Data lineage documentation
  • Dimensional modeling
  • Model completion validation
  • Automatic foreign key migration
  • Capacity planning

Supported Platforms[2][edit]

  • Firebird® 1.5, 2.x
  • Greenplum 4.2
  • Hitachi HiRDB
  • Hadoop Hive 0.12, 0.13
  • IBM® DB2® 5.x - 10.x for LUW and z/OS® & iSeries V4R5 and V5R2
  • IBM Informix® OnLine and SE
  • Informix 9.x dynamic server
  • InterBase® 4, 2007, 2009
  • InterBase XE, XE3
  • Microsoft® Access 2.0, 95, 97, 2000
  • Microsoft Azure SQL Database
  • Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014
  • Microsoft SQL Server on Azure
  • Microsoft Visual FoxPro® 2, 3, 5
  • MongoDB 2.4, 2.6, 3.0
  • MySQL® 3.x, 4.x, 5.x
  • Netezza 4.6, 5.0, 6.0, 7.0
  • Oracle® 7.3, 8.x, 9i, 10g, 11g, 12c
  • PostgreSQL 8.x, 9.x
  • Sybase® Adaptive Server® Enterprise (ASE) 11.9.2, 12.x, 12.5, 15.0
  • Sybase Adaptive Server Anywhere (ASA) 5, 6, 7, 8, 9, 10
  • Sybase IQ 12.x, 15.x, 16.x
  • Sybase Watcom SQL
  • Teradata® V2R4, V2R5, V2R6, 12, 13.0, 14.x, 15.10

Support[edit]

See also[edit]

External links[edit]

References[edit]

  1. ^ "IDERA Announces Intent to Acquire Embarcadero, Expands Position in Database Management and Developer Tools Markets". IDERA. 7 October 2015. 
  2. ^ "ER/Studio Data Architect: Tech Specs". IDERA. Retrieved 12 January 2017.