• Article

Importing Data (Master Data Services)

You can populate the Master Data Services database with data from your organization's disparate data sources. For data to be in the appropriate Master Data Services database tables, you must import data into staging tables and then process the staged data as a batch.

You can use the staging process to create members and collections, update attribute values, add members to collections, and designate relationships in explicit hierarchies.

In Master Data Services, the staging process is also used to:

  • Update or add attribute values when business rules are processed.

  • Update data in a model when a model deployment package that contains master data is deployed.

For more information about the staging process workflow, see Staging Process Workflow (Master Data Services).

Staging System Settings

There are settings in Master Data Services Configuration Manager that affect the staging process. You can adjust these settings in Master Data Services Configuration Manager or directly in the Master Data Services database System Settings table. For more information, see System Settings (Master Data Services).

Staging Tables

The Master Data Services database includes three staging tables that you can populate with your organization’s data and one batch table that tracks each batch of staged data.

Table Name

Description

mdm.tblStagingMember

Use to create leaf members, consolidated members, and collections.

mdm.tblStgMemberAttribute

Use to update attribute values of existing members and collections.

You can also use to delete and reactivate members and collections.

mdm.tblStgRelationship

Use to:

  • Add members to a collection.

  • Move members in an explicit hierarchy.

mdm.tblStgBatch

Displays the status of each batch of staged data.