Add, update, and delete data in Master Data Services database in bulk (Leaf only)

You can add data and make data changes to a model in Master Data Services, in bulk.

Prerequisites:

• You must have permission to insert data into the stg._Leaf table in the Master Data Services database
• You must have permission to execute stg.udp_<name>_Leaf stored procedure in the Master Data Services database.
• The model must not have a status of Committed.

0. MDS Objects

Leaf Member Staging Table
Use the leaf members staging table (stg.name_Leaf) in the Master Data Services database to create, update, deactivate, and delete leaf members. You can also use it to update attribute values for leaf members.

Table Columns
The following table explains what each of the fields in the Leaf staging table are used for.

Column Name	Description
ID	An automatically assigned identifier
ImportType (required)	Determines what to do when staged data matches data that already exists in the Master Data Services database.
ImportStatus_ID (Required)	The status of the import process
Batch_ID (Required by web service only)	An automatically assigned identifier that groups records for staging. All members in the batch are assigned this identifier, which is displayed in the Master Data Manager use interface in the ID columns
BatchTag (Required, except by web service)	A unique name for the batch, up to 50 characters.
ErrorCode	Displays an error code. For all records with a ImportStatus_ID of 2.
Code (Required, except when codes are generated utomatcially for ImportType1 or 2)	A unique code for the member
Name (Optional)	A name for the member
NewCode	Use only if you are changing the member code
<Attribute name>	A column exists for each attribute in the entity. Use this with an ImportType of 0 or 2. For free-form attributes, specify the new text or string values for the attribute. For domain-based attributes, specify the code for the member that will be the attribute. For link attributes, the URL must start with https://.

Some Attributes
ImportType
Determines what to do when staged data matches data that already exists in the Master Data Services database.

Import Type	Values
0	Create new members. Replace existing MDS data with staged data, but only if the staged data is not NULL. NULL values are ignored. To change a string attribute value to NULL, set it NULL. To change a number attribute value to NULL, set it to -98765432101234567890. To chnge a datetime attribute value to NULL, set it to 5555-11-22T12:34:56.
1	Create