Running Incremental ETL Jobs Manually

To manually run an incremental ETL batch job immediately:

  1. Navigate to the <Op_Report_Home>/install/sample directory.

  2. Open the sample_onetime_batch.bat file (or sample_onetime_batch.sh) file in a text editor, and then replace the parameter placeholders with valid values, as shown in the following table.

    Parameter

    Value

    Reporting DB Schema Name

    Operational Reporting database
    schema name

    Reporting DB TNS Name

    Operational Reporting database
    TNS name

    ETL BATCH JOB NAME

    Any job name

    Example: TM_ETL_DAILY

  3. Run the sample_onetime_batch.bat (or sample_onetime_batch.sh) file.

    Example:

    call sample_onetime_batch.bat REPORTING SCHEMA ORASID TEST_ETL_JOB

  4. When you are prompted, type the password for the Operational Reporting database schema.

  5. To check the job progress, you can query the RPT_EVENT_LOG_DETAIL table, as follows:

    Example: select event_time, lead(event_time,1) over
    (order by event_log_id desc), round((event_time -
    lead(event_time,1) over (order by event_log_id desc))*24*60
    ,2) durations, t1.*
    from rpt_event_log_detail t1
    order by event_log_id desc;

    where the value of event_time must contain both date value and time value.

    If the value of event_time does not contain date value or time value, configure the settings in Oracle client tool. For detailed steps, see If the value of event_time does not contain date value or time value, configure the settings in Oracle client tool as follows: .

To view the status of an incremental ETL job, you can query the job control tables (RPT_ETL_JOB and RPT_EVENT_LOG_DETAIL tables).

Note: If an incremental ETL job fails, it is rerun automatically when the Oracle scheduler starts the job for the next scheduled run, or when you run the job manually, whichever occurs first.