Building a Model (MDS Add-in for Excel)

 

Applies To: SQL Server 2016

In the Master Data ServicesAdd-in for Excel, administrators can perform a subset of the administrative functions available in the Master Data Manager web application.

The model building tasks administrators can do in the Master Data ServicesAdd-in for Excel are:

As an administrator, you must create the model by using the Master Data Manager web application or the web service. Then you can use the Add-in for Excel to create entities and attributes within the model. For more information about model objects, see Models (Master Data Services).

Most administrative tasks must still be done in the Master Data Manager web application or by using the web service. The following table shows which tools administrators can use to complete tasks in MDS.

Task DescriptionToolTopic
Create models.Master Data Manager web application or web serviceCreate a Model (Master Data Services)
Create an entity.Master Data Manager web application, web service, or the Add-in for ExcelCreate an Entity (MDS Add-in for Excel)
Create a domain-based attribute.Master Data Manager web application, web service, or the Add-in for ExcelCreate a Domain-based Attribute (MDS Add-in for Excel)
Create attribute groups.Master Data Manager web application or web serviceCreate an Attribute Group (Master Data Services)
Create business rules.Master Data Manager web application or web serviceCreate and Publish a Business Rule (Master Data Services)
Create subscription views.Master Data Manager web application or web serviceCreate a Subscription View to Export Data (Master Data Services)
Create hierarchies.Master Data Manager web application or web serviceCreate a Derived Hierarchy (Master Data Services)

 Create an Explicit Hierarchy (Master Data Services)
Create collections.Master Data Manager web application or web serviceCreate a Collection (Master Data Services)
Create versions of data.Master Data Manager web application or web serviceLock a Version (Master Data Services)
Deploy models.Master Data Manager web application, web service, or MDSModelDeploy tool.Create a Model Deployment Package by Using MDSModelDeploy

Community Additions

ADD
Show: