Initial Replication Load

For initial load from source to replication, the Oracle Data Integrator scenario B1_SYNC_CONTEXT should be executed. This job identifies all source application tables configured to be replicated and then synchronizes historical data from source into the replication schema for all those tables if not synchronized before. B1_SYNC_CONTEXT uses the database data pump functionality to synchronize historical data from the source database into the replication schema. The data can be copied to the replication layer using three methods:
  • Export and Import
  • Export and Import Using Shared Network Storage
  • Database Link

Export and Import

Follow below steps to synchronize initial historical source data into the Oracle Utilities Analytics Warehouse replication layer.
  1. Log in to the Oracle Utilities Analytics Warehouse Administration Tool.
  2. Click Global Configuration in the left panel under ETL Configuration.
  3. Click Edit.

  4. Replace DBLINK with DPUMP_EXPORT for the appropriate Product and Instance (that is, the source product and instance for which you want to perform initial replication load) and click Save.

    Global Configuration page displaying a search bar, a filtering section, and a four columns table: product, instance number, description, and value. The user is to update one of the values in the last column.

  5. Open Oracle Data Integrator.
  6. Navigate to the Load Plans and Scenario folder in the Designer tab.
  7. Expand the Framework > Scheduler folder.
  8. Right click B1_SYNC_CONTEXT Version 001 and click Run to start exporting data from the source. A popup windows opens to enter the Context and Logical Agent. In the example provided, choose the appropriate context code and Logical agent as WLS Agent.
  9. Make sure that B1_SYNC_CONTEXT job is completed without any error.
  10. Move the dump files from source B1_DATA_DUMP_DIR to target B1_DATA_DUMP_DIR location manually.

  11. Follow above step 1 - 4 to modify the global configuration from DPUMP_EXPORT to DPUMP_IMPORT.

    Global Configuration page displaying a search bar, a filtering section, and a four columns table: product, instance number, description, and value. The user is to update one of the values in the last column.

  12. Run B1_SYNC_CONTEXT Version 001 again to import data into the replication schema.
  13. Make sure that the job is completed successfully. This can be verified in the Oracle Data Integrator operator log.

Export and Import Using Shared Network Storage

In this method, no movement of files is required. Follow the steps below to load initial data into the replication schema.

  1. Follow step 1-4 mentioned under the Export and Import method above, and set the value to DPUMP_SHARED in the Global Configuration section for the appropriate product and instance.

    Global Configuration page displaying a search bar, a filtering section, and a four columns table: product, instance number, description, and value. The user is to update one of the values in the last column.

  2. Follow step 6-12 mentioned under Export and Import method above to run B1_SYNC_CONTEXT job.
  3. Make sure that the job is completed successfully. This can be verified in the Oracle Data Integrator operator log.

Database Link

This is the default method to replicate initial data from source into their respective replication schema. Make sure that for your respective source product and instance, the value is set to DBLINK. If the global configuration is not set as DBLINK, then set to DBLINK as mentioned below. Follow step 6-12 mentioned under the Export and Import method above to run B1_SYNC_CONTEXT job. Make sure that this job executes successfully without any error.

Global Configuration page displaying a search bar, a filtering section, and a four columns table: product, instance number, description, and value. The user is to update one of the values in the last column.