ER/Studio
≈ 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.