Load or Update Members in Master Data Services by Using the Staging Process

SQL Server 2012

In Master Data Services, you can use the staging process to create, update, and delete members in bulk. You can also use the staging process to set and update attribute values.

To perform this procedure:

  • You must have permission to insert data into the stg.name_Leaf (for leaf members) or the stg.name_Consolidated (for consolidated members) table in the Master Data Services database.

  • You must have permissions to execute either the stg.udp_name_Leaf (for leaf members) or stg.udp_name_Consolidated (for consolidated members) stored procedure in the Master Data Services database.

  • The model must not have a status of Committed.

To load members into the MDS database

  1. Prepare the members for import into the appropriate staging table in the Master Data Services database.

  2. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.

  3. Import the data into the Master Data Services database. For information about importing data into a database by using SQL Server Integration Services, see Run the SQL Server Import and Export Wizard.

  4. After you successfully import the data, run the stored procedure to load the staged data into the appropriate tables in the MDS database. For more information on the stored procedure, see Staging Stored Procedure (Master Data Services).

Community Additions