Microsoft SATVs Are Expiring —Take Full Advantage and Act Now!

closeClose

Siebel Enterprise Integration Manager Rel 15.5

  • Tuition USD $2,700
  • Reviews star_rate star_rate star_rate star_rate star_half 2368 Ratings
  • Course Code D95278GC10
  • Duration 2 days
  • Available Formats Classroom, Virtual

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

Skills Gained

  • Import data
  • Export data
  • Delete data

Course Details

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great instructor, clear and concise course. Labs were easy to follow and worked perfectly.

The course was well organized, excellent training materials and lab excercises.

ExitCertified (Kelly & her team) were very responsive to all the pre-enrollment inquiries and sharing the TOCs etc. The course materials arrived on time, the classroom instructions were very clear and concise. And the staff was available always to help and support. Overall, a very good experience.

Very organized. I like how they keep me informed and prepared for training. I would certainly go to ExitCertified (Tech Data) as a training delivery platform/company again.

Classromm confortable and enviroment. Instructir knowlegeable of course matarial but need to align to students working in the Canadian Federal Govt. ve US Federal govt.

2 options available

undo
  • Mar 29, 2021 Mar 30, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:00AM 5:00PM EDT
    Enroll
    Enroll
  • Sep 27, 2021 Sep 28, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    12:00PM 8:00PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward