ER/Studio
{{Multiple issues|
{{more footnotes|date=January 2012}}
{{advert|date=February 2016}}
}}
{{Infobox software
| name = ER/Studio
| developer = IDERA, Inc
| latest_release_version = 20.2
| latest_release_date = {{Start date and age|June 2024}}
| operating_system = Microsoft Windows
| genre = CASE tool
| license = Proprietary EULA
| website = {{URL|https://erstudio.com/}}
}}
ER/Studio is data architecture and database design 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.{{Cite web|url=https://www.idera.com/about/news/pressreleases/2015/idera-announces-intent-to-acquire-embarcadero|title=IDERA Announces Intent to Acquire Embarcadero, Expands Position in Database Management and Developer Tools Markets|last=|first=|date=7 October 2015|website=IDERA|publisher=|access-date=}}
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
- Integration with Data Governance tools like Collibra
Overview
ER/Studio has a computer-aided software engineering tool (or CASE tool).{{Cite book|url=https://books.google.com/books?id=9x2LawVL_UsC|title=Database Modeling and Design: Logical Design|last1=Teorey|first1=Toby J.|last2=Lightstone|first2=Sam S.|last3=Nadeau|first3=Tom|last4=Jagadish|first4=H. V.|date=2011-02-10|publisher=Elsevier|isbn=9780123820211|pages=234|language=en}} Users can utilize ER/Studio as a way to take conceptual data model and create a logical data model that is not dependent on a specific database technology.{{Cite book|url=https://books.google.com/books?id=ufDibgxnCdUC|title=Beginning Oracle Database 11g Administration: From Novice to Professional|last=Fernandez|first=Iggy|date=2009-02-18|publisher=Apress|isbn=9781590599686|pages=131|language=en}} This schematic model can be used to create the physical data model. Users can then forward engineer the data definition language required to instantiate the schema for a range of database-management systems. The software includes features to graphically modify the model, including dialog boxes for specifying the number of entity–relationships, database constraints, indexes, and data uniqueness. ER/Studio supports four data modeling languages: IDEF1X, two variants{{Citation needed|date=February 2023}} of information technology engineering developed by James Martin, and a form of dimensional modeling notation.
Version History
- 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
- 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 inheritance
- Token-based repository check-out and check-in
- Updates for several MetaWizard common model bridges
- Numerous bug fixes
- 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
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
- 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
- Extended Amazon Redshift cloud data support.
- 2 new MetaWizard import bridges including Amazon Web Server (AWS) Aurora Database.
- Updated PostgreSQL support
- Additional Redshift features
- Change Notifications in Team Server
- Support for Snowflake cloud database
- Ui/Ux Facelift
- Aqua Data Studio
- Oracle 18c/19c tolerance support
- Performance Improvements
- Platform Support for Oracle 18c/19c
Platforms
ER/Studio works on the Windows operating system, ranging from Windows 7 to Windows 10 (64-bit).
Support
See also
External links
- [http://www.embarcadero.com/products/er-studio Official website] {{Webarchive|url=https://web.archive.org/web/20131017230120/http://www.embarcadero.com/products/er-studio |date=2013-10-17 }}
- [https://web.archive.org/web/20081209045555/http://www.infoworld.com/articles/ec/xml/00/05/22/000522ecstudio.html Infoworld.com article]
- [http://www.bitpipe.com/detail/PROD/1025205626_676.html Bitpipe.com article]
- [https://web.archive.org/web/20070307111620/http://www.sqlmag.com/Article/ArticleID/9155/sql_server_9155.html SQL Server magazine article]
- [http://www.felix-colibri.com/papers/db/embarcadero_er_studio/embarcadero_er_studio.html ER Studio Tutorial]