Overview: Exporting Data (Master Data Services)


Applies To: SQL Server 2016

This article introduces the types of subscription view formats and how to determine when views need to be edited due to changes to model objects.

You create a subscription view to export Master Data Services data to a subscribing system such as SQL Server. You use the subscribing system to view the data in the Master Data Services database. For information on how to create the subscription view, see Create a Subscription View to Export Data (Master Data Services)

For more information about views, see Views.

When you create a view in Master Data Manager, you choose from a set of standard view formats that Master Data Services provides. You can use these formats to create views that show:

  • All leaf members and their attributes.

  • All consolidated members and their attributes.

  • All collections and their attributes.

  • The members explicitly added to a collection.

  • The members in a derived hierarchy, in either a parent child or level format.

  • The members in all explicit hierarchies for an entity, in either a parent child or level format.

After you create a subscription view for an entity or hierarchy, changes to the associated model objects are not automatically reflected in the view. You might need to regenerate a subscription view in Master Data Manager to reflect changes to model objects. The Changed column on the Export page is updated to True when model objects change. True indicates that you should edit the subscription view and save it, which regenerates the view.

Task DescriptionTopic
Create a subscription view of your master data.Create a Subscription View to Export Data (Master Data Services)
Delete an existing subscription view.Delete a Subscription View (Master Data Services)

Community Additions