Support merging in SCV interface services

Interface Service with Data Entity = SCV Table, and Direction = Import now supports an Update Mode field in the Import Behavior tab. The Update Mode field is available where the type is Database, CSV, Excel or API.

These options are now supported when loading data into an SCV table with the addition of Update Mode:

  • Add: Implemented as no delete + insert
  • Replace: Implemented as delete + insert
  • Merge: Implemented as insert + update

The Merge mode is already supported in Data Service APIs, in SCV programs, and now in Scripts from this release. This enhancement extends this functionality to SCV import interface services.

These are the possible values for the Update Mode field:

  • Merge: The imported rows are merged into the destination SCV table, using the Primary Key constraint defined on the destination SCV table to match the records.
  • Insert: The imported rows are inserted into the destination SCV table.
    Note: By default the value is set to Insert, maintaining the existing behavior.

This is a platform enhancement allowing enrichment of the standard content delivered to customers as well customer extensions when importing data in to SCV. The standard content is not updated to utilize this feature in this release, thus maintaining existing behavior. However, administrators can begin to use this feature for new SCV import interface services.

Note: By default, this feature is enabled. A new role or privilege is not required to access this feature.