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

Applies to: SQL Server - Windows only Azure SQL Managed Instance

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.


    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.

View Information

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

Column Description
Status The 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.
Name The subscription view name.
Model The model name.
Version The version name.
Version Flag The version flag name.
Derived Hierarchy The derived hierarchy name.
Entity The entity name.
Format Specifies the type of the data in the view.
Level Specifies the number of levels in the view, which is only used for Explicit level or Derived level view formats
Include delete members Indicates 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.

See Also

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