Importing records from the integration database

The integration database contains a table for each business object. The Table Import step of the import wizard displays the name of the table from which the structure will be imported.

  1. Select a business object.
  2. Click the Import icon.
  3. Select one of these options and click Next:
    Option Description
    Add/Update Add the imported data to the existing data in the model.
    Caution: 
    Existing records are updated with the values from the integration table. You can protect manually edited properties from update in the Manual Adjustments step of the wizard.
    Replace Replace all existing data in the model for the selected business object
  4. If you selected the Add/Update option, and there are manually edited properties that you want to preserve, then select the check boxes of those properties.
  5. Optionally, to ensure that the selected properties are protected during future imports, selectSave settings as default for this business object.
    Your saved settings are written to the Manage Properties dialog box. To view or update the saved settings, click Manage Properties and turn on Import Settings.
  6. Click Next and then click Import.
    The import fails if the source contains invalid data, such as an invalid currency code. The Result page shows the number of invalid records, their row numbers in the source, and the reason for failure.
    Optionally, click Save Log File to save the log to a text file. In addition to the row numbers and reasons, the text file shows the column names and the details of the failed rows.
  7. Click Close.