Integration management
MDS, as a master data management system, provides the functionality to import data into MDS from external applications or export information from MDS to external applications. In MDS, this functionality is called integration management. In this section, which is the last of this chapter, you will learn how to import data into MDS and export data from it.
SSIS plays an important role for integration management in MDS. SSIS, as you've seen in Chapter 4, ETL with Integration Services, is a Microsoft integration tool and is very powerful. We are able to create subscription views from entities and hierarchies to export data from MDS. We can even use the user subscription views in SSIS as a source of data.
The procedure for importing ...
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.
