Siebel Enterprise Integration Manager Rel 15.5

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. It is appropriate for Siebel 15.x and 8.x customers. 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

Audience

• Application Developers
• Database Administrators
• Developer
• Support Engineer
• Technical Consultant

Related Training

Suggested Prerequisites

• Siebel Technical Foundations 15.5

Course Objectives

• Import data
• Export data
• Delete data

Course 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

Minimum Participants: 4 Person or More

Job Interview Preparation  (Soft Skills Questions & Answers)

• Tough Open-Ended Job Interview Questions
• What to Wear for Best Job Interview Attire
• Job Interview Question- What are You Passionate About?
• How to Prepare for a Job Promotion Interview

Flexible Class Options

• Week End Classes For Professionals  SAT | SUN
• Corporate Group Trainings Available
• Online Classes – Live Virtual Class (L.V.C), Online Training

Related Siebel Course

Siebel 8.1.x Core Consultant Course

Siebel Open UI Foundation

Siebel Business Foundation 15.5 Course

Siebel Customer Order management Course

[/vc_column_text]