Oracle Cloud Infrastructure Documentation

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.

Tutorial icon LiveLabs Sprint

Perform this task only after you have set up the pipeline and report parameters. 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.

  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.
    Description of fawag_data_config.png follows
  4. On the service page, for example, the Data Configuration: Oracle Financial Analytics page, click Create.

    Description of fawag_application_page.png follows

  5. On the Enterprise Resource Planning page, shown as an example, use the wizard to select your application areas to transfer data to the warehouse, and then click Next.

    Description of fawag_create_pipeline.png follows

  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 schedule when to run the data pipeline for the functional area. See Activate a Data Pipeline for a Functional Area.
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.