Complete a One-Time Data Augmentation

Running a data augmentation job is a pre-requisite for deploying the Oracle Energy and Water 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 Energy and Water Data Intelligence instance.

  1. Sign in to your service.
  2. In the Oracle Energy and Water 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 Energy and Water Customer Data INIT_DA_JOB_CUST Initial data augmentation job for Customer Data connector INIT_DA_CI_INSTALL_PROD
    Oracle Energy and Water Device Data INIT_DA_JOB_DVC Initial data augmentation job for Device Data connector (same as above)
    Oracle Energy and Water Work and Asset Data INIT_DA_JOB_WACS Initial data augmentation job for Work and Asset Data connector (same as above)
    Oracle Energy and Water Digital Asset Data INIT_DA_JOB_DACS Initial data augmentation job for Digital Asset Data connector (same as above)
    Oracle Energy and Water Grid Insights Data INIT_DA_JOB_GRID Initial data augmentation job for Grid Insights Data connector (same as above)
    Oracle Energy and Water AMI Data INIT_DA_JOB_AMI Initial data augmentation job for AMI Data connector (same as above)
  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.