Installing ER Studio Repository on SQL Server

ER/Studio Team Server is a model and metadata collaboration platform that provides greater meaning, understanding, and context for enterprise data. Database professionals, developers, and business analysts gain better comprehension and compliance using integrated model, metadata, and collaboration tools. The collaborative enterprise glossary of Team Server brings together the entire organization to foster improved metadata, business definitions, governance, compliance, and security policies. Online models showcase data relationships, while powerful search capabilities help users locate enterprise data with ease.

With Team Server, data consumers can:

Integrate effective data comprehension capabilities into daily workflows, delivering context and meaning to every user.

Enable collaboration around data among teams across business units or business functions.

Support corporate compliance initiatives by driving responsible use of sensitive or private data.

Data modeling professionals can use Team Server to:

Integrate the business definitions of the glossary with internal web assets to give on-the-fly business context with tool-tips and pop-ups.

Create a single registry of all available data sources.

Adhere to industry regulations and business standards for security and privacy, by alerting users who view or change sensitive data within the tools.

And Team Server allows data management professionals and developers to:

Develop applications faster by using business terms to locate data elements.

Check access to and use of business glossaries and associated functions to understand immediate data management requirements.

ER/Studio Repository is a server-side model management system. It solves the day-to-day challenges of modeling in a team environment, where the reuse of model collaboration, versioning, security, and components is vital. The Repository allows multiple users to be productive while collaborating on data and business process modeling projects. It enables real-time concurrent access that allows team members to share and reuse assets across projects. The Repository provides:

Collaborative modeling with concurrent access to models and objects

Model and object version management

Standardized enterprise data dictionary

Real-time objects status notification

This video helps you to install the Repository for Team Server on Microsoft SQL Server.