Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Siebel Enterprise Integration Manager

( Duration: 2 Days )

In Siebel Enterprise Integration Manager training course, you will 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.

By attending Siebel Enterprise Integration Manager workshop, delegates will learn to:

  • Import data
  • Export data
  • Delete data

This Siebel Enterprise Integration Manager class is intented for:

  • Database Administrators
  • Developers
  • Implementers
  • Administrators

COURSE AGENDA

1

Siebel table relationships and referential integrity

  • User, primary, and foreign keys
  • Party and denormalized data
  • ROW_IDs
  • Temporary, required, and extension columns
2

EIM Architecture

  • EIM (interface) tables
  • Base, target, or destination tables
  • EIM to base table mappings
  • EIM jobs
  • Configuration (.ifb) files
  • Parameters
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
4

Data mappings

  • Source to base
  • Determining the interface table
  • Determining required columns and values
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
6

Updating User Keys

  • EIM_PARTY_UK
  • EIM_ORG_EXT_UK
7

Setting Primaries

  • Explicit
  • Implicit
  • MISC SQL
8

Populating Extension Columns

  • EIM/Interface Table Mapping Wizard
  • Apply, Activate, and Validate
9

Exporting Data

  • Clear Interface Table
  • Export Matches
  • Export All Rows
  • Populating BU columns
10

Deleting Data

  • Cascade deletes
  • Delete Exact
  • Delete Matches
  • Delete All Rows
  • Commit Options

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X