Create a Subscription View to Export Data (Master Data Services)


Applies To: SQL Server 2016

Create a subscription view to export Master Data Services data to subscribing systems. You're creating a view of your data in the Master Data Services database.

To perform this procedure:

To create and edit a subscription view

  1. In Master Data Manager, click Integration Management.

  2. From the menu bar, click Create Views.

  3. On the Subscription Views page, click Add to create a view or click Edit to edit a view. A panel displays on the right side.

  4. In the Create Subscription View pane, in the Name box, type a name for the view.

    In the Edit Subscription View pane, in the Name box, type the updated name for the view.

  5. From the Model list, select a model.

  6. Select Include soft-deleted members, to include soft-deleted members in the view.

  7. Select either Version or Version Flag in Version Options, and then select from the corresponding list.

    System_CAPS_ICON_tip.jpg Tip

    Create a subscription view based on a version flag. When you lock a version, you can reassign the flag to an open version without updating the subscription view.

  8. Select either Entity or Derived hierarchy in the Data Sources option, and then select from the corresponding list.

  9. From the Format list, select a subscription view format.

  10. If you chose Explicit levels or Derived levels from the Format list, type the number of levels in the hierarchy to include in the view.

  11. Click Save.

For each created view, a row with ten columns is added to the grid. The following table describes the columns.

StatusThe view status.

When you click Save, the Icon for updating status image displays, indicating that the view is updating.

If there are errors when creating or editing a view, the Icon for error status image displays.

Otherwise, the status is OK and the Icon for OK status image displays.
NameThe subscription view name.
ModelThe model name.
VersionThe version name.
Version FlagThe version flag name.
Derived HierarchyThe derived hierarchy name.
EntityThe entity name.
FormatSpecifies the type of the data in the view.
LevelSpecifies the number of levels in the view, which is only used for Explicit level or Derived level view formats
Include delete membersIndicates whether soft-deleted members are included in the view.

When you click a view, the following information displays.

  • Created By: The name of the user who created the view.

  • On: The date and time when the view was created.

  • Updated By: The name of the user who last updated the view.

  • On: The date and time when the view was last updated.

Overview: Exporting Data (Master Data Services)
Delete a Subscription View (Master Data Services)
Create a Version Flag (Master Data Services)

Community Additions