Oracle Cloud Infrastructure Documentation

Activate a Data Pipeline for a Functional Area

You must activate the data pipeline for a functional area to run it and load the data into the data warehouse.

Ensure that you don't activate a data pipeline for a functional area in the following situations:
  • Load in progress: If an incremental load is in progress.
  • An impending load: If an incremental load is scheduled to run in the next hour.
  • Exceeded the number of daily refresh requests: The maximum number of ad hoc data refresh requests for the day is four. If you've exceeded this number, then you can submit a request the following day.
  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, click your service. For example, under Applications, click Enterprise Resource Planning.
  4. On the service page, for example, the Data Configuration: Oracle Financial Analytics page, click the Action menu for the saved data pipeline for the functional area that you want to activate, and click Edit.
  5. Review the details of the data pipeline for the functional area and then click Activate.

    Description of fawag_activate_pipeline.png follows

  6. In step 4 of the Data Configuration wizard, select Scheduled Execution Data to specify the date and time on which to run the data pipeline for the functional area. Select Run Immediately to create and run the data pipeline for the functional area immediately. Click Finish.

    Description of fawag_schedule_activation_pipeline.png follows

Oracle Fusion Analytics Warehouse runs the data pipeline for the functional area, loads data into your data warehouse, and displays your data pipeline for the functional area on the Data Configuration page. Once data is successfully loaded, the system updates the status of the data pipeline for the functional area to Activation Completed.