• Document and enhance data and metadata from multiple database platforms
  • Implement naming standards and a data dictionary to improve consistency
  • Share and collaborate on global business glossary terms and definitions
  • Effectively communicate models and metadata across the enterprise
  • Build a foundation for data governance and compliance programs

Document Data and Metadata
Modeling and metadata management can help to measure, control, and improve the quality of the data. With ER/Studio, you can document critical data elements, business data objects, and regulatory data elements and show their sources, interactions, and dependencies, in logical and physical models.
Implement Naming Standards
Assign a naming standards template to your model, submodel, entities, and attributes, and ER/Studio Enterprise Team Edition will automatically apply those naming standards between the logical and physical models, ensuring consistency between models. You can also integrate model elements into reusable constructs via a built-in enterprise data dictionary.
Collaborate on Global Glossary Terms
ER/Studio Enterprise Team Edition lets users define business-area specific glossaries with rollups to higher level glossaries to reflect the corporate structure. Business and technical team members can view and update the business terms to share corporate knowledge in one centralized location.
Share Models and Metadata Across the Enterprise
The models and associated metadata are the only means by which complex data environments can truly be understood and managed. IT users can publish models in Team Server for others to access via the interactive viewer, and set permissions for visibility of objects. Identify and track recent changes with audit trails.
Establish a Foundation for Data Governance
Establish a data strategy based on a centralized model and metadata hub. Comply with industry regulations and business standards regarding security and privacy by alerting users who view or modify sensitive data. Easily set permissions for access controls. Consolidate information in easy-to-understand reports for business analysts.

Data Modeling

Universal Mappings
Map between and within conceptual, logical and physical model objects to view upstream or downstream.
“Where Used” Analysis
Display mapping between conceptual and logical models and their implementations across physical designs.
Visual Data Lineage
Visually document source/target mapping and sourcing rules for data movement across systems.
Business Data Objects
Represent master data and transactional concepts with multiple entities and relationships, such as products, customers, and vendors.
Advanced Compare and Merge
Enable advanced, bidirectional comparisons and merges of model and database structures.
Naming Standards
Automatically apply a naming standards template across logical and physical models by binding it to models, submodels, entities and attributes.

Process Modeling

Conceptual Model Creation
Supports high-level conceptual modeling using elements such as subject areas, business entities, interactions, and relationships.
Process Model Creation
Support for straightforward process modeling that uses standard elements such as sequences, tasks, swim lanes, start events, and gateways.

UML Modeling

Model Driven Architecture and Standards
Supports Unified Modeling Language™, XML Metadata Interchange (XMI®), Query / Views / Transformations (QVT) and Object Constraint Language (OCL).
Model Patterns
Powerful re-use facilities to jumpstart projects through predefined patterns.

Data Sources and Platforms

Round-Trip Database Support
Native forward and reverse engineering for multiple RDBMS and big data platforms.
Import Bridges
Import model information from BI, ETL, other modeling tools, and industry-standard metadata interchange formats.
Export Bridges
Easily export your models to BI, ETL, other modeling tools, and industry-standard exchange formats such as XMI, XML, and XSD.
Data Lineage Visibility
Visualize source-target mapping and sourcing rules designed in an external Extract-Transform-Load (ETL) tool or Data Integration (DI) tool.
ETL/DI Tool Integration
Import mapping requirements information to the lineage model from most of the leading ETL and DI tools.

Model and Metadata Repository

Concurrent Model and Object Access
Allows real-time collaboration between modelers working on data models down to the model object level.
Reviewing Changes and Resolving User Conflict
Resolve conflicts through simple and intelligent interfaces to walk users through the discovery of differences.
Agile Change Management
Assign and track tasks associated with data models to align changes to user stories and development workflows.
Version Management
Manages the individual histories of models and model objects to ensure incremental comparison between, and rollback to, desired diagrams.
Component Sharing and Reuse
Predefined Enterprise Data Dictionary eliminates data redundancy and enforces data element standards.
Interactive Model Image Navigator
View the data model image interactively within the Team Server web interface, including zoom, search, and re-positioning functions.
Team Collaboration
Apply enterprise collaboration features such as activity and discussion streams, to capture and share corporate knowledge and reduce time identifying and correcting data quality issues.
Enterprise Glossary
View, classify, relate and centrally store authoritative business definitions in an extensible enterprise glossary of business terms, and track changes with an audit trail.
Glossary Hierarchy
Create child glossaries that inherit a subset of terms from one or more glossaries to define a tiered structure that can correlate to organizational configurations.
Semantic Mapping
Relate business terms to critical data elements including tables, columns, entities and attributes.
Data Source Registry
Create and view a single searchable registry of all available created or imported data sources.
Data Source Mappings
Track and analyze the impact of data model changes back to affected data sources.
Centralized Reporting
More than 20 out-of-the-box reports and a reporting wizard for ad hoc reports that can be exported to several formats and shared.
Advanced Search
Easily search and filter results for data objects, data sources, glossaries, and terms.
Security Center Groups
Streamline security administration with local or LDAP groups.