Siebel 8.1.x Enterprise Integration Manager

Total time

Siebel 8.1.x Enterprise Integration Manager

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

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.

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

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

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.

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

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


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

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

Course Objectives
  • Import data
  • Export data
  • Delete data

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.