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

Цели курса:

• Import data
• Export data
• Delete data

Аудитория:

• Configuration Implementer
• Implementation Consultant
• System Administrator
• System Integrator

Программа курса:
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