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:
You must have permission to access the Integration Management functional area. For more information, see Functional Area Permissions (Master Data Services).
You must be a model administrator. For more information, see Administrators (Master Data Services).
In Master Data Manager, click Integration Management.
From the menu bar, click Create Views.
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.
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.
From the Model list, select a model.
Select Include soft-deleted members, to include soft-deleted members in the view.
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.
Select either Entity or Derived hierarchy in the Data Sources option, and then select from the corresponding list.
From the Format list, select a subscription view format.
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.
For each created view, a row with ten columns is added to the grid. The following table describes the columns.
|Status||The view status.|
When you click Save, the image displays, indicating that the view is updating.
If there are errors when creating or editing a view, the image displays.
Otherwise, the status is OK and the 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.