Siebel 8.1.x Enterprise Integration Manager
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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 (interface) tables
- Base, target, or destination tables
- EIM to base table mappings
- EIM jobs
- Configuration (.ifb) files
- Parameters
- Processing steps
- .IFB options
- Resolution of foreign keys and list of values
- ROW_ID values
- Primaries
- Populating the EIM table
- Source to base
- Determining the interface table
- Determining required columns and values
- Only base tables/columns
- Insert rows/update rows
- Net change
- Session SQL
- Default/fixed columns
- Filter Query
- Skip BU_ID
- Tracing
- EIM_PARTY_UK
- EIM_ORG_EXT_UK
- Explicit
- Implicit
- MISC SQL
- EIM/Interface Table Mapping Wizard
- Apply, Activate, and Validate
- Clear Interface Table
- Export Matches
- Export All Rows
- Populating BU columns
- Cascade deletes
- Delete Exact
- Delete Matches
- Delete All Rows
- Commit Options
Course Objectives
- Import data
- Export data
- Delete data
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.