Refresh Oracle Utilities Data Intelligence Data

A full data refresh reloads data from your source applications into Oracle Utilities Data Intelligence. You might need a full refresh when the data in Oracle Utilities Data Intelligence must be resynchronized with the source data, such as after a data issue or another condition that requires the existing data to be reloaded.

To perform a full data refresh, you first disable the incremental data pipeline and submit a service request for Oracle to complete the required internal refresh. After Oracle confirms that the internal refresh is complete, you reset and reload the applicable data sources, and then restore the incremental refresh schedule.

Disable the Incremental Data Pipeline

Disable your scheduled incremental refresh before Oracle begins the internal refresh work.

To disable the incremental data pipeline:

  1. Sign in to Oracle Utilities Data Intelligence.
  2. In the Oracle Utilities Data Intelligence Admin Console, under Application Administration, select Data Configuration.
  3. From the Data Source menu, select the applicable connector, such as Oracle Utilities Customer Data.
  4. Open Pipeline Settings for the selected data source.
  5. On the Pipeline Settings page, make a note of the information displayed under Data Refresh Schedule in the Interval menu, as you will re-enable this later.
  6. Set Interval to None.

Request a Full Data Refresh

Request a full data refresh from Oracle Utilities Data Intelligence Support.

To request a full data refresh:

  1. Sign in to My Oracle Support.
  2. Submit a service request to Oracle Utilities Data Intelligence Support and request a full data refresh.
  3. In the service request, state that you have disabled the incremental data pipeline.
  4. Wait until Oracle Utilities Data Intelligence Support confirms in the service request that the internal refresh is complete. Reset and reload the data sources only after you receive this confirmation.

Reset and Reload the Data Source

After Oracle Utilities confirms in the service request that the internal refresh is complete, reset and reload the applicable data sources.

To reset and reload the data source:

  1. Sign in to Oracle Utilities Data Intelligence.
  2. In the Oracle Utilities Data Intelligence Admin Console, under Application Administration, select Data Configuration.
  3. In the upper-right corner of the page, open the actions menu and select Reset & Reload. If Reset & Reload isn’t available, see Reset and Reload the Data Source in the Fusion Data Intelligence documentation.
  4. In the dialog that displays, under the Datasource area, select all data sources that apply to the subscriptions in your instance and that are included in the refresh request. To narrow the list, enter a data source name in the search box and select it from the filtered results. For the available connector names for each subscription, see Create a Connection to Your Source Applications. Use the examples in the following table for guidance.
    Subscription Scenario Data Sources to Select

    Customer Analytics

    Oracle Utilities Base Data, Oracle Utilities Customer Data

    Meter Analytics

    Oracle Utilities Base Data, Oracle Utilities Meter Data

    Customer + Meter

    Oracle Utilities Base Data, Oracle Utilities Customer Data, Oracle Utilities Meter Data
  5. Under Schedule, select Run Immediately.
  6. Under Notes, enter the following information:
    • Authorized By: Specify who authorized the reset and reload.
    • Comment: Describe why the reset and reload is needed.
  7. Select Submit.

Monitor the Reset and Reload Request

Monitor the reset and reload request until it completes.

To monitor the reset and reload request:

  1. In the Oracle Utilities Data Intelligence Admin Console, under Application Administration, select Data Configuration.
  2. On the Data Configuration page, under Activity History, select Request History.
  3. On the Request History page, select the One Time tab.
  4. Locate the request that you submitted to reset and reload the data sources.
  5. Confirm that the request status is Completed.
  6. To review request details, select the icon in the Summary column.

Note:

The reset and reload request can take a long time to complete. Other incremental or full-load requests do not start until it finishes.

Re-enable the Incremental Data Pipeline

After the reset and reload request completes successfully, restore the incremental data pipeline schedule that you recorded before starting this procedure.

After the reset and reload request completes successfully, restore the incremental data pipeline schedule that you recorded before starting this procedure. For detailed instructions, see Schedule Incremental Data Refresh in the Fusion Data Intelligence documentation.