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.
Open the MDS WebUI and go to Integration Management.
Go to the Create Views menu item and click on the Add button.
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:Open SSDT and create an SSIS project; name it
Subscription View
.Create a Data Flow task. Inside the Data Flow task, create an OLE DB source.
Create a connection to the MDS database from the OLE DB source.
In the OLE DB source, set the data access mode as Table or View. Choose mdm.VwProduct as the name of the view. Preview the data rows and then click on OK...