1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integration Tasks
  3. Loading Data
  4. Using the Data Load Workbench
  5. Processing Data
  6. Step 1: Importing Source Data

Step 1: Importing Source Data

The Import from Source feature enables the Oracle Data Integrator to import the data from the source system, performs the necessary transformation, such as import, map and validate the data. The Import from Source features also enables you to import the source online (immediate processing) or offline (runs in background).

Select this feature only when:

  • Running a data load rule for the first time.

  • Data in the source system has changed. For example, if you reviewed the data in the staging table after the export, and it was necessary to modify data in the source system.

In many cases, source system data may not change after you import the data from the source the first time. You don't need to keep importing unchanged data.

To import source data:

  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.

    To import another source file, you must change the POV. For information on changing the POV, see Using the POV Bar.

  3. At the top of the screen, click Import.
  4. In Execution Mode, select the mode of importing the source.

    • online—ODI processes the data in sync mode (immediate processing).

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

      ClickImage shows Process Details button to navigate to the Process Detail page to monitor the ODI job progress.

  5. Click OK.

    The Import fish changes to orange.