Siebel Enterprise Integration Manager Rel 15.5 (D95278) – Outline

Detailed Course Outline

Siebel table relationships and referential integrity
  • User, primary, and foreign keys
  • Party and denormalized data
  • ROW_IDs
  • Temporary, required, and extension columns
EIM Architecture
  • EIM (interface) tables
  • Base, target, or destination tables
  • EIM to base table mappings
  • EIM jobs
  • Configuration (.ifb) files
  • Parameters
EIM imports and updates
  • Processing steps
  • .IFB options
  • Resolution of foreign keys and list of values
  • ROW_ID values
  • Primaries
  • Populating the EIM table
Data mappings
  • Source to base
  • Determining the interface table
  • Determining required columns and values
Controlling processing and logging
  • Only base tables/columns
  • Insert rows/update rows
  • Net change
  • Session SQL
  • Default/fixed columns
  • Filter Query
  • Skip BU_ID
  • Tracing
Updating User Keys
  • EIM_PARTY_UK
  • EIM_ORG_EXT_UK
Setting Primaries
  • Explicit
  • Implicit
  • MISC SQL
Populating Extension Columns
  • EIM/Interface Table Mapping Wizard
  • Apply, Activate, and Validate
Exporting Data
  • Clear Interface Table
  • Export Matches
  • Export All Rows
  • Populating BU columns
Deleting Data
  • Cascade deletes
  • Delete Exact
  • Delete Matches
  • Delete All Rows
  • Commit Options