Time for action – a subscription view

In this example, we will export product entity records into the SQL Server database table. We will create a subscription view for the product entity and use SSIS to export data rows.

  1. Open the MDS WebUI and go to Integration Management.
  2. Go to the Create Views menu item and click on the Add button.
  3. Set the subscription view name as VwProduct, then choose PacktPub_BI_Model as the model, and choose Version_1 as the version. Choose the Product entity and set the format as Leaf members. Click on the Save icon to save the changes made in the Create Subscription View window, as shown in the following screenshot:
    Time for action – a subscription view
  4. Open

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial