Siebel Enterprise Integration Manager Rel 15.5 Ed 1

Cost $2,700

Course Code
D95278GC10

Duration
2 days

Format
Live Virtual Class

What you will learn

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

Prerequisites

Suggested Prerequisite

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

 

Audience

  • Administrator
  • Database Administrator
  • Developer
  • Implementer

Objectives

  • Import data
  • Export data
  • Delete data

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

Enroll for Siebel Enterprise Integration Manager Rel 15.5 Ed 1

Siebel Enterprise Integration Manager Rel 15.5 Ed 1

$2,700.00

Clear
SKU: D95278GC10 Categories: ,

Additional information

Schedules

Sep 27 2021 – Sep 28 2021 (2 days) 9:00 AM – 5:00 PM US-Pacific, Mar 29 2022 – Mar 30 2022 (2 days) 9:00 AM -5:00 PM US-Eastern

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “Siebel Enterprise Integration Manager Rel 15.5 Ed 1”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0