ER/Studio

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

Version History

Version 16.0:[2]

  • Represent master data and transactional concepts with Business Data Objects
  • Assign naming standards to models and submodels
  • Provide product usage statistics on application use (optional)
  • Additional platform support for Azure and Teradata

Version 16.5:[3]

  • Universal mappings and enhancements to data modeling and lineage
  • Improved relationship diagramming
  • Extended database platform support to include DB2 for z/OS v11 and SQL Server 2016
  • Model change management enhancements
  • Spell check and revisable text format for editable descriptions
  • Relationship color inheritence
  • Token-based repository check-out and check-in

Version 17.0:[4]

  • Updates for several MetaWizard common model bridges
  • Numerous bug fixes

Version 17.1:[5]

  • Add SQL Server 2017 support for modeling and repository platform
  • Extend MongoDB platform support up to version 3.6
  • Support for repository on Windows Server 2016 OS
  • Multiple bug fixes

Version 18.0:[6]

Enhancements and bug fixes including:

  • Selectable SQL Server driver for Forward and Reverse Engineering
  • Oracle 12cR2 has been certified as a deployment platform for the DA Professional repository
  • Corrected behavior to eliminate synchronization error when checking diagrams into the DA Professional repository
  • Improved repository database connection verification is provided within the repository configuration screens
  • Updated repository password encryption
  • It is no longer necessary to uninstall and re-install the Repository when upgrading from 16.1 or later versions. The installer will now detect an existing version and upgrade in place

Version 18.1:[7]

  • Extension to 7 new MetaWizard platforms including AWS Aurora import bridge, Salesforce Database import bridge, and SAS Bridge SAS Code.
  • Data Architect enhancements and bug fixes
  • Multiple Team Server usability enhancements and bug fixes

Version 18.2:[8]

  • Extended Amazon Redshift cloud data support.
  • 2 new MetaWizard import bridges including Amazon Web Server (AWS) Aurora Database.

Platforms

ER/Studio works on the Windows operating system, ranging from Windows 7 to Windows 10 (64-bit).

Support

See also

References
    1. "IDERA Announces Intent to Acquire Embarcadero, Expands Position in Database Management and Developer Tools Markets". IDERA. 7 October 2015.
    2. "Exciting News: Embarcadero Announces ER/Studio 2016 - Blog - Blog - IDERA Community". community.idera.com. Retrieved 2020-03-09.
    3. "New patch releases available for ER/Studio 16.5.0 (2016+) and also ER/Studio Team Server 16.1.x (2016) - Blog - Blog - IDERA Community". community.idera.com. Retrieved 2020-03-09.
    4. "IDERA Enhances Business Architecture Capabilities with Latest ER Studio Release". www.idera.com. Retrieved 2020-03-09.
    5. "Announcing ER/Studio 17.1 General Availability - Blog - Blog - IDERA Community". community.idera.com. Retrieved 2020-03-09.
    6. "ER/Studio 18.0 is now available! - Blog - Blog - IDERA Community". community.idera.com. Retrieved 2020-03-09.
    7. "ER/Studio 18.1 General Availability - Blog - Blog - IDERA Community". community.idera.com. Retrieved 2020-03-09.
    8. "ER/Studio 18.2 General Availability - Blog - Blog - IDERA Community". community.idera.com. Retrieved 2020-03-09.
    This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.