--- title: "Add, Update and Delete Data (Master Data Services) | Microsoft Docs" ms.custom: "" ms.date: "06/13/2017" ms.prod: "sql-server-2014" ms.reviewer: "" ms.technology: "master-data-services" ms.topic: conceptual ms.assetid: b6295ead-bd2f-49dd-8756-35c6afb59648 author: lrtoyou1223 ms.author: lle manager: craigg --- # Add, Update and Delete Data (Master Data Services) You can add data and make data changes to a model in [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)], in bulk. **Prerequisites** - You must have permission to insert data into the stg.\_Leaf, the stg.\_Consolidated, stg.\_Relationship table in the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database. - You must have permissions to execute either the stg.udp_\_Leaf, stg.udp\_\_Consolidated, or the stg.udp\_\_Relationship stored procedure in the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database. - The model must not have a status of **Committed**. **To add, update, and delete data in the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database** 1. Prepare the members for import into the appropriate staging table in the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database, including providing values for the required fields. For an overview of staging tables, see [Data Import (Master Data Services)](overview-importing-data-from-tables-master-data-services.md) - For leaf members the table is stg.\_Leaf, where \ refers to the corresponding entity. For information about the required fields, see [Leaf Member Staging Table (Master Data Services)](../../2014/master-data-services/leaf-member-staging-table-master-data-services.md) - For consolidated members, the table is stg.\_Consolidated. For information about the required fields, see [Consolidated Member Staging Table (Master Data Services)](../../2014/master-data-services/consolidated-member-staging-table-master-data-services.md). - For moving the location of members in explicit hierarchies, the table is stg.\_Relationship. For information about the required fields, see [Relationship Staging Table (Master Data Services)](../../2014/master-data-services/relationship-staging-table-master-data-services.md). For an overview on moving members in explicit hierarchies, see [Data Import (Master Data Services)](overview-importing-data-from-tables-master-data-services.md). - Use the **ImportType** field value to specify that you're creating new members, deactivating members, or deleting members. For more information about the values, see [Leaf Member Staging Table (Master Data Services)](../../2014/master-data-services/leaf-member-staging-table-master-data-services.md) and [Consolidated Member Staging Table (Master Data Services)](../../2014/master-data-services/consolidated-member-staging-table-master-data-services.md). For an overview of deactivating and deleting members, see [Data Import (Master Data Services)](overview-importing-data-from-tables-master-data-services.md). 2. Open [!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)] and connect to the Database Engine instance for your [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database. For more information, see [SQL Server Management Studio](../ssms/sql-server-management-studio-ssms.md). 3. Import data into the staging tables by using the [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] Import and Export wizard. For more information, see [SQL Server Import and Export Wizard](../integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard.md). 4. Load the data from the staging tables to the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] tables, by doing one of the following - Run the staging stored procedure that corresponds to the staging table that you want to move data to. For an overview of staging stored procedures and staging tables, see [Data Import (Master Data Services)](overview-importing-data-from-tables-master-data-services.md). For more information about parameters for staging stored procedures, and a code example, see [Staging Stored Procedure (Master Data Services)](../../2014/master-data-services/staging-stored-procedure-master-data-services.md). - Use the **Integration Management** functional area of Master Data Management. On the **Staging Batches** page, select the model to which you're adding data to, in the drop-down list, and then click **Start Batches**. The status of the batch processing is indicated in the **Status** field. For more information about the statuses, see [Import Statuses (Master Data Services)](../../2014/master-data-services/import-statuses-master-data-services.md). ![Staging Batches Page in Master Data Manager](../../2014/master-data-services/media/mds-staging-batches.png "Staging Batches Page in Master Data Manager") The staging process is started at intervals determined by the **Staging batch interval** setting in [!INCLUDE[ssMDScfgmgr](../includes/ssmdscfgmgr-md.md)]. For more information, see [System Settings (Master Data Services)](../../2014/master-data-services/system-settings-master-data-services.md). 5. View errors that occurred during staging. For more information, see [View Errors that Occur During the Staging Process (Master Data Services)](view-errors-that-occur-during-staging-master-data-services.md) and [Staging Process Errors (Master Data Services)](../../2014/master-data-services/staging-process-errors-master-data-services.md). 6. Validate the data against business rules. In Master Data Manager, navigate to the **Explorer** functional area for your model, and then apply business rules to validate the data. For more information , see [Validate Specific Members against Business Rules (Master Data Services)](../../2014/master-data-services/validate-specific-members-against-business-rules-master-data-services.md). You can also use a stored procedure to validate the data. For more information, see [Validation Stored Procedure (Master Data Services)](../../2014/master-data-services/validation-stored-procedure-master-data-services.md). When you load data by from the staging tables, the data is not automatically validated against business rules. For more information on what validation is and when it occurs, see [Validation (Master Data Services)](../../2014/master-data-services/validation-master-data-services.md). ## See Also [Data Import (Master Data Services)](overview-importing-data-from-tables-master-data-services.md)