Siebel Enterprise Integration Manager Administration Guide > Importing Data > Importing Legacy Data >
Recommended Import Order for Importing Legacy Data
The order in which legacy data is imported is critical to make sure that relationships between dependent data elements are established correctly. Siebel EIM tables do not map one-to-one with Siebel target database tables. NOTE: The recommended import order that follows is a general guideline. Your own data import process may require a different order.
To make sure that the necessary data is present to establish relationships between data entities, use the following sequence to import data:
- Administrative
NOTE: An example of administrative data would be a List of Values for Currency or Zip Code.
- Business Unit
- Positions
- Accounts
- Contacts
- Employees
- Products
- Opportunities
- Personal Accounts
- Quotes
- Documents
- Forecasts
- Fulfillment
- Marketing Campaigns
- CPG Promotion Management
- CPG Product Movement
- Service Requests
- Product Defects
- Activities and Appointments
- Notes
- File Attachments
This import order reflects most import processes. In some cases, the import order for your import process may vary slightly depending on your requirements. NOTE: Your Siebel application provides a sample configuration file named default.ifb. You can also use the import sequence in this sample file in your configuration file.
While the import order is most critical when performing the initial import of legacy data, this recommended order should be followed for all subsequent data imports as well. 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.
|