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
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
- Join Internships and Referral Program (click for details)
- Work as Freelancer or Full-Time Employee (click for details)
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 Business Foundation 15.5 Course
Siebel Customer Order management Course
[/vc_column_text]
