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 information into MDS is a little different. MDS creates a staging table for each entity. We need to insert new information into these staging tables and then call the stored procedure to run a batch job and transfer those new records from the...