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
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
