Data Asset Documentation and Discovery
Leverage data model documentation tools to
improve collaboration and accessibility enterprise-wide With Idera ER/Studio
Reverse Engineering for Readability
Reverse engineer data assets from an array of products to improve readability.
Automatic Logical Model Generation
Convert physical names to business names to easily share insights across business teams.
Built-in Business Glossary
Document against data governance standards with the built-in Business Glossary.
Collaborative Team Server
Publish documented models to the Team Server to facilitate collaboration among stakeholders.
Reverse engineer data assets from an array of products to improve readability.
Reverse engineering data assets allows DBAs to create entity-relationship (ER) models, a form of data representation that can be easily understood and compared to other models and databases. ER models allow DBAs, data architects and other data professionals to develop a deeper understanding of the relationships that exist in a given data asset. ER/Studio enables DBAs to easily reverse engineer data assets from numerous popular products, including Oracle, NoSQL, MySQL, and more, facilitating greater readability and usability.
Convert physical names to business names to easily share insights across business teams.
ER/Studio allows DBAs to seamlessly, automatically convert between logical and physical models, thanks in large part to Data Dictionaries. Data Dictionaries allow organizations to establish a single governing standard for the relationships between physical data assets and their logical business definition, enabling ER/Studio to auto-generate logical models from physical models and vice versa. This ensures that all key stakeholders are on the same page about an organization’s data assets, and that everyone has access to critical business insights.
Document against data governance standards with the built-in Business Glossary.
ER/Studio’s built-in Business Glossary allows DBAs and other stakeholders to easily proof their work against data governance standards, ensuring any data modeling projects comply with necessary standards. DBAs can seamlessly integrate Business Glossaries with their data architecture models to ensure they’re working alongside, not against, any organizational data governance initiatives. What’s more, ER/Studio enables DBAs to create models of data assets mapped to business terms, contributing to organizational data cataloging projects and further laying the foundation for strong data governance.
Publish documented models to the Team Server to facilitate collaboration among stakeholders.
The ER/Studio Team Server is critical for facilitating collaboration among key stakeholders during any data modeling project. A web-based tool to access, edit, search, and manage enterprise metadata, Team Server provides shared access to metadata from ER/Studio Repository. In addition, it allows users to manage additional metadata, including glossaries and terms or data sources. Team Server takes the guesswork out of data documentation, allowing stakeholders to keep track of metadata and easily generate reports from the shared data.
Frequently-Asked Questions
Data documentation, or data model documentation, is the process of cataloging and describing to make it easier to find, use, and manage. Data documentation ensures that data can be retrieved and used by any stakeholder, as it involves explaining what data means, how it’s structured, and what the contents contain. Data documentation is therefore also critical to establishing a data governance foundation.
A business glossary is a tool used to define the meanings of unique business terms, which means that business glossaries vary widely from industry to industry and from organization to organization. A data catalog is also a means of organizing data, but rather than a glossary of terms, it’s a single reference source for the location of various data assets. Data catalogs help users find the data they’re looking for, while business glossaries help users understand the data.
Creating a business glossary is often a key component of a data governance program. The business glossary is used to demonstrate that an organization has a central understanding of key business concepts and terms and the relationships between them. What’s more, a business glossary can be used to demonstrate adherence to industry and government regulations.
A data dictionary is an organized collection of names, definitions, and attributes that are being captured in a data asset. A data dictionary describes the meaning and purpose of various data elements, providing a single source of truth for a project’s accepted meanings and representation, helping an organization adhere to set data standards.
Easily discover and document existing data assets to
align with data governance initiatives and facilitate seamless collaboration.
Idera ER/Studio
- Automate Data Asset Design
- Collaborate Across the Model Repository
- Establish a Data Governance Foundation
