Oracle/Siebel Enterprise Integration Manager Rel 15.5

Siebel Enterprise Integration Manager Rel 15.5 Certification Training Course Overview

Enroll for the 2-day Siebel Enterprise Integration Manager certification training course from Koenig Solutions accredited by Oracle.

Students get hands-on practice: mapping external data to Siebel tables and columns; using EIM table reports to determine how to populate EIM tables and columns to load base tables; running EIM import, export, and delete jobs; and dealing with party data, user keys, primaries, and extensions. This course is built on Siebel IP15.5, but applies to Siebel 8.x, Siebel IP16.x, Siebel IP17.x, Siebel 2018 and Siebel 2019. See the release notes for the minor changes. Practices are performed using Open UI.

Target Audience:

  • Administrator
  • Database Administrator
  • Developer
  • Implementer

Learning Objectives

Upon completion of this course, you will learn to:

  • Import legacy data into the Siebel database
  • Export Siebel data to an external system
  • Mass delete Siebel data

Siebel Enterprise Integration Manager Rel 15.5 (16 Hours) Download Course Contents

Live Virtual Classroom Fee On Request
Group Training
01 - 02 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Siebel table relationships and referential integrity
  • User, primary, and foreign keys
  • Party and denormalized data
  • ROW_IDs
  • Temporary, required, and extension columns
Module 2: EIM Architecture
  • EIM (interface) tables
  • Base, target, or destination tables
  • EIM to base table mappings
  • EIM jobs
  • Configuration (.ifb) files
  • Parameters
Module 3: EIM imports and updates
  • Processing steps
  • .IFB options
  • Resolution of foreign keys and list of values
  • ROW_ID values
  • Primaries
  • Populating the EIM table
Module 4: Data mappings
  • Source to base
  • Determining the interface table
  • Determining required columns and values
Module 5: 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
Module 6: Updating User Keys
  • EIM_PARTY_UK
  • EIM_ORG_EXT_UK
Module 7: Setting Primaries
  • Explicit
  • Implicit
  • MISC SQL
Module 8: Populating Extension Columns
  • EIM/Interface Table Mapping Wizard
  • Apply, Activate, and Validate
Module 9: Exporting Data
  • Clear Interface Table
  • Export Matches
  • Export All Rows
  • Populating BU columns
Module 10: Deleting Data
  • Cascade deletes
  • Delete Exact
  • Delete Matches
  • Delete All Rows
  • Commit Options
Download Course Contents

Request More Information

Course Prerequisites

Suggested Prerequisite

  • Siebel Technical Foundations Rel 15.5 Ed 1
  • Siebel Tools Rel 15.5 Ed 2