Step 3: Exporting Data to Target Applications

After the source data has passed the validation process, use the Export option to export data to a target application. Select this option after you have reviewed the data in the data grid and are sure you want to export it to the target application.

When exporting data for Planning, you can store, add, subtract and override data.

The export of mapping rules to a CSV or Excel format does not include any scripting.

To submit the data load rule:

  1. On the Workflow tab, under Data Load, select Data Load Workbench.
  2. Optional: When you import a source file, Data Management uses the current POV to determine location, category, and period and conducts the following process: To import another source file, you must change the POV. See Using the POV Bar.
  3. At the top of the screen, click Export.
  4. In Execution Mode drop-down, select the mode for exporting the source data to the target application.
    • online—ODI processes the data in sync mode (immediate processing).

    • offline—ODI processes the data in async mode (runs in background).

      Click Image shows Process Details icon to navigate to the Process Detail page to monitor the ODI job progress.

  5. Click OK.