Set Up the Pipeline Parameters

Set up the pipeline parameters for your data model file before running your data pipelines for the functional areas. Oracle Energy and Water Data Intelligence provides multiple pipelines by functional area, allowing you to set up and schedule them independently of each other.

  1. Sign in to your service.
  2. In the Oracle Energy and Water Data Intelligence Admin Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, click the Data Source menu. The menu displays a list of pipelines by functional area, such as Customer or Device.
  4. Select the functional area for which you want to set up pipeline parameters.
  5. Click Pipeline Settings.
  6. On the Pipeline Settings page, under Global Parameters, from the Analytics Language list, select the language in which you want to extract the data.
  7. From the Analytics Currency list, select the currency of the transaction data.
  8. From the Exchange Rate Type list, select an exchange rate type that you want to use when converting the transaction amounts to the global currency.
  9. In Initial Extract Date, select the date from which to load the transaction data.
  10. Under Data Refresh Schedule, from the Interval list, select the frequency of the data refresh. Depending on the selected interval, specify the time, day, and month when you want the incremental data load to happen.

Note: The Frequent Data Refresh Schedule and Frequent Refresh Tables actions are not supported in Oracle Energy and Water Data Intelligence.