Siebel Enterprise Integration Manager Administration Guide > EIM Performance Tuning > IBM DB2 Loading Process for EIM >

Recommended Import Order


  1. The recommended order for importing data (actual entities vary for each implementation) is as follows: Reference Data, for example, Lists of values
  2. Employees and Positions, start dates must match
  3. Accounts, including addresses
  4. Contacts, including addresses
  5. Products
  6. Opportunities
  7. Personal accounts
  8. Quotes
  9. Documents
  10. Forecasts
  11. Fulfilment
  12. Marketing Campaigns
  13. CPG Promotion Management
  14. CPG Product Movement
  15. Service Request
  16. Product Defects
  17. Activities and Appointments
  18. Notes
  19. File Attachments

NOTE:  Some tables cannot be used to import all data necessary for the imported data to be visible in the GUI. For example, the interface table EIM_FCSTOPTYPRD can be used to export forecast data but it cannot be used for importing. The import runs successfully, but the imported data cannot be seen in the GUI because EIM does not populate the table that would make the data visible.


 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004