Create a Data Pipeline for a Functional Area

As a functional administrator, create a data pipeline for a functional area to copy data to the data warehouse. Use these steps to select and schedule runs to update the Oracle Autonomous Data Warehouse instance with the latest data.

Perform this task only after you have set up the pipeline and report parameters.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then 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 Create.
5. Select your application areas to transfer data to the warehouse, and then click Next.
6. Review the parameters and click one of the options:
   • Cancel: To cancel the data pipeline for the functional area.
   • Save: To save the data pipeline for the functional area but not activate it.
   • Activate: To display the page for scheduling when to run the data pipeline for the functional area. Select Scheduled Execution Date 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.

   Note:

   You can schedule an activation of a functional area even if activation of another functional area is in progress. However, you can't update the activation of a functional area that's in progress.

Oracle Fusion Analytics Warehouse extracts data only from the initial extract date that you specify. For example, if the initial extract date is 10th March and you've added data on 9th March in your source, then the data added on 9th won’t be part of this data pipeline activation plan. You can see the data pipeline activation plan listed on the Data Configuration page.