In Chapter 4, Creating and Using Models, we looked at the different objects that make up the Master Data system as well as how to add, edit, and delete single members using the web-based user interface. In this chapter, we will look at how to populate the MDS repository using the SQL Server Staging tables and how to automate this process using SQL Server Integration Services (SSIS).
We will extend the example carried out in previous chapters to include a walk-through of loading, updating, and deleting members.
In this chapter, we will cover the following topics:
The staging load process
Populating the staging tables
Creating new members
Creating new collections
Adding members to collections
Updating member attributes
Deleting members
Invoking the staging process
Invoking the validation process
Clearing the staging tables
Errors in the staging process
Automating the MDS load process with SSIS