oracle 200x118 wht
7843  Reviews star_rate star_rate star_rate star_rate star_half

Siebel Enterprise Integration Manager Rel 15.5

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

Read More
$2,700 USD
Course Code D95280GC10
Duration 2 days
Available Formats Classroom

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.

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

Skills Gained

  • Import data
  • Export data
  • Delete data

Who Can Benefit

  • Administrator
  • Database Administrator
  • Developer
  • Implementer

Prerequisites

Suggested Prerequisite

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

Course Details

Topics

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