ER/Studio

Uses your system voice; voice and rate in settings.

Snapshot

≈ 2 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

ER/Studio is data architecture and data modeling software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero 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.

ER/Studio is data architecture and data modeling software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero 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.

Features

Logical and physical design support Support for wide range of relational database platforms Support for NoSQL platforms such as MongoDB Support for JSON and JSON schema 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 Built-in Business Glossary XML Schema generation from either the logical or physical models Native integration with Data Governance tool Collibra Native integration with Data Governance tool Microsoft Purview ERbert AI Modeling Assistant converts natural language to data models

Support

IDEF1X Star schema Snowflake Schema Data warehouse Data mesh Data Lakehouse Data Vault Medallion Architecture

See also

Relational Model Denormalization Data modeling Data architecture Model-driven architecture RDBMS XML XML Schema Data warehouse Entity-Relationship model

External links

Official website Infoworld.com article Bitpipe.com article SQL Server magazine article ER Studio Tutorial

Text derived from https://en.wikipedia.org/w/index.php?oldid=1371817988 under CC BY-SA 4.0; modifications have been made.

Sources cited in this revision

15 named source(s) extracted from the cited revision. A source with no author is shown by its publication; nothing is invented.