Siebel Enterprise Integration Manager and Integration of Oracle Customer Hub (UCM)

Siebel Enterprise Integration Manager is an important component of Oracle Customer Hub. It performs bulk imports and exports data residing in other back-office systems into Oracle Customer Hub (UCM) and consolidates and replicates information from these sources. Unlike Siebel Enterprise Application Integration, Siebel Enterprise Integration Manager does not go through an application object manager, but the data moves from the EIM_UCM_ORG interface table directly into the SDH (S_UCM_ORG) tables. Siebel Enterprise Integration Manager also provides a schema abstraction and has high throughput. Some features of Siebel Enterprise Integration Manager include:

  • Denormalized interface tables

  • Declarative mapping defined in Siebel Tools

  • Automated SQL generation

  • Support for parallelized import

For batch integration with external applications, Oracle Customer Hub (UCM) provides the following Customer Hub-specific EIM tables to facilitate the loading of selected primary objects into Oracle Customer Hub's Source Data and History tables. These records can then be processed by Oracle Customer Hub (UCM) data management tasks later:

  • EIM_PTYUCM_DTL

  • EIM_UCM_ADRPER

  • EIM_UCM_ASSET

  • EIM_UCM_ASTCON

  • EIM_UCM_CON

  • EIM_UCM_CONCHLD

  • EIM_UCM_OGPCHD

  • EIM_UCM_ORG

  • EIM_UCM_ORGCHLD

  • EIM_UCM_ORGGRP

  • EIM_UCM_PRIVCY

For more information about Siebel Enterprise Integration Manager, see Siebel Enterprise Integration Manager Administration Guide.

Generation of Party_UID

Siebel Enterprise Integration Manager and Oracle Customer Hub (UCM) workflow processes generate the Party_UID field based on the value in the UCM_EXT_ID field. The process for generating this field occurs by either of the following means:

  • Loading data to UCM SDH table using UCM (Organization, Person, Financial Asset, or Group) Customer Profile Integration SOAP Process. In this scenario, the user must populate the <ID> integration object component field value in the SOAP message, which maps to UCM_EXT_ID field in the UCM SDH table. Additionally, the <PartyUId> field, which maps to PARTY_UID, must be empty or not sent with the SOAP message. The UCM (Organization, Person, Financial Asset, or Group) Customer Profile Integration SOAP Process then generates the PARTY_UID based on UCM_EXT_ID.

  • Loading data to UCM SDH table using Siebel Enterprise Integration Manager. In this scenario, users must populate the UCM_EXT_ID column value in the EIM interface table and the UCM_PARTY_UID field value must remain empty. The EIM interface table value populates the UCM_EXT_ID field in the SDH table. The UCM Batch Process workflow then generates the PARTY_UID based on the UCM_EXT_ID.

For more information on the PARTY_UID, see Siebel Enterprise Integration Manager Administration Guide.