An update package is also known as a PUT-enabled package, a putable package, or a merge package. When you create an update package, you enable the PUT API within the package. A data steward can use the update package to add, change, or merge master data.
Create update packages when you want authorized users to be able to perform any of the following actions:
Update data in records from the Data Manager or from an external application
Insert records from the Data Manager or from an external application
Merge records from the Merge Manager or from an external application
For each authorized role, set privileges for the update packages that the role can use. Grant the read privilege and at least one of the create, update, or merge privileges. For more information about secure resources and privileges, see the
Multidomain MDM Security Guide
.
Requirements for Update Packages
Update packages have some requirements at the package level and at the query level.
Package-level requirements
An update package must adhere to the following requirements:
Select a generic query for the update package. Custom queries and other packages are not supported with update packages.
Select the
Enable Put
option.
Access only the tables and relationships defined within the generic query. The update package cannot contain joins to other tables.
Query-level requirements
The generic query must adhere to the following requirements:
Select only a primary table. The generic query cannot contain additional tables.
If you select individual columns, you must add the ROWID_OBJECT column.
The generic query cannot contain system tables, constant columns, aggregate functions, or groupings.