Complete a One-Time Data Augmentation

Running a data augmentation job is a pre-requisite for deploying the Oracle Utilities Data Intelligence bundles. These steps need to be performed once for each of the connector(s) which are made available through your SKUs/subscriptions in the Oracle Utilities Data Intelligence instance.

  1. Sign in to your service.
  2. In the Oracle Utilities Data Intelligence Admin Console, under Application Administration, click Data Configuration.
  3. On the Data Configuration page, from the Data Source menu, select the connector you want to create a data augmentation for (for example, “Oracle Energy and Water Customer Data”).
  4. Click the Data Augmentation tile, and then click Create from the menu and choose Data Augmentation.
  5. In the Source Selection screen, do the following:
    • In Augmentation Type, select Create Dataset.
    • In Source Dataset Type, select Supplemental Data.
    • In Source Table type, select System Provided.
    • In Source table: , select any source table that is a low volume table, such as Installation Product (CI_INSTALL_PROD). This way, the job can be completed faster.
  6. Click Next.
  7. In the Attribute Selection screen, a few attributes columns will be selected by default. Click Next.
  8. In the Column Options screen, the settings for the columns will be selected by default. Click Next.
  9. In the Schedule and Save page, provide the necessary details depending on the connector:
    Connector Name Description Table Suffix
    Oracle Utilities Customer Data INIT_DA_JOB_CUST Initial data augmentation job for Customer Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Utilities Customer Insights INIT_DA_JOB_OUCI Initial data augmentation job for Customer Insights connector DIM_UTILITY
    Oracle Utilities Meter Data INIT_DA_JOB_DVC Initial data augmentation job for Meter Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Utilities Work and Asset Data INIT_DA_JOB_WACS Initial data augmentation job for Work and Asset Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Utilities Customer Program Data INIT_DA_JOB_DACS Initial data augmentation job for Customer Program Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Utilities Grid Insights Data INIT_DA_JOB_GRID Initial data augmentation job for Grid Insights Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Utilities AMI Data INIT_DA_JOB_AMI Initial data augmentation job for AMI Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Utilities Base Data INIT_DA_JOB_BASE Initial data augmentation job for Base Data connector INIT_DA_CI_INSTALL_PROD
  10. In Schedule, click Run Immediately and click Finish.
  11. Monitor the status of the data augmentation job by going to the Admin Console and choosing Request History. The status should indicate completed successfully.
  12. Verify that the pipeline status is marked as Activation Complete for the triggered data augmentation job. This can be checked under the Data Augmentation section in which the job was created in previous steps.