13 Incremental ETL: ODI Console

This chapter describes the steps required to administer the ETL process using the Oracle Data Integrator Console (ODI Console).

13.1 Scheduling an ETL

The ETL can be scheduled through ODI Studio only.

To schedule an ETL, see Section 12.1, "Scheduling Incremental ETL".

13.2 Monitoring Incremental ETL Process

The process of monitoring the Incremental ETL using the Oracle Database Integrator Console is same as the process of monitoring the Initial ETL.

For step-by-step information related to monitoring the Incremental ETL process using the ODI Console, see Section 7.4, "Monitoring Initial ETL Process: ODI Console."

13.3 Managing Incremental ETL Process

This section describes the steps required to manage the Incremental ETL process using the Database Integrator Console.

13.3.1 Running the Incremental ETL

  1. Open the Oracle Data Integrator Console. This displays the Oracle Data Integrator Console Sign In window.

  2. In the Oracle Data Integrator Sign In window:

    1. Select the ODI Work Repository name from the Repository drop-down list.

    2. Enter the name of the ODI user in the User Id field.

    3. Enter the password for the ODI user in the Password field.

    4. Click Sign In. This displays the Oracle Data Integrator Console Screen, as shown in the following figure:

      Figure 13-1 Oracle Data Integrator Console Screen

      Surrounding text describes Figure 13-1 .

  3. Select the Browse tab in the left pane.

  4. Expand the Runtime folder, and navigate to Runtime > Scenarios/Load Plans > Folder > LP_ARGUSMART811 > LP_INC_AM, as highlighted in the following figure:

    Figure 13-2 Scenarios/Load Plans

    Surrounding text describes Figure 13-2 .

    The LP_INC_AM option in this section represents the load plan for the Incremental ETL process for Argus Mart.

  5. Click Execute, as highlighted in the following figure:

    Figure 13-3 Executing the Incremental ETL

    Surrounding text describes Figure 13-3 .

    This displays the Execute Load Plan window, as shown in the following figure:

    Figure 13-4 Execute Load Plan Window

    Surrounding text describes Figure 13-4 .

  6. In the Execute Load Plan window:

    1. Select LA_AM from the Logical Agent drop-down list.

    2. Select CTX_ARGUSMART from the Context drop-down list.

    3. Select the desired log level from the Log Level drop-down list.

    4. Click Execute. This displays the Information dialog box with the Load Plan Execution submitted successfully confirmation message.

  7. Click OK.

    You can verify the status of the ETL process by expanding the Load Plan Executions folder in the Sessions/Load Plan Executions section. You can view the status of the Load Plan in Green color with tilted s, which signifies that the ETL session is in progress, as highlighted in the following figure:

    Figure 13-5 Status of the Load Plan

    Surrounding text describes Figure 13-5 .

13.3.2 Stopping the Incremental ETL

  1. Select the Load Plan, which you want to stop, by expanding the Load Plan Executions folder of the Sessions/Load Plan Executions section and click Stop, as shown in the following figure:

    Figure 13-6 Stopping the Incremental ETL

    Surrounding text describes Figure 13-6 .

    This displays the Stop Load Plan Execution dialog box.

    Figure 13-7 Stop Load Plan Execution Dialog Box

    Surrounding text describes Figure 13-7 .

  2. Select Normal from the Stop Type drop-down list.

  3. Select OracleDIAgent from the Physical Agent drop-down list.

  4. Click Stop. This displays the Information dialog box with the Load Plan was Stopped Successfully confirmation message.

  5. Click OK.

    You can verify the status of the ETL process by navigating to the Load Plan Executions folder in the Sessions/Load Plan Executions section. You can view the status of the Load Plan in Red color with the X symbol, which signifies that the ETL session is not in progress, as highlighted in the following figure:

    Figure 13-8 Stopped Incremental ETL Session

    Surrounding text describes Figure 13-8 .

    Note:

    You must verify in Argus Mart database if the ETL session has been successfully ended after this step.

13.3.3 Restarting the Incremental ETL

Restarting the Incremental ETL process enables you to start the ETL process from the last execution step where it was stopped or failed.

  1. Select the Load Plan, which you want to restart, in the Load Plan Executions folder of the Sessions/Load Plan Executions section and click Restart, as shown in the following figure:

    Figure 13-9 Restarting the Incremental ETL

    Surrounding text describes Figure 13-9 .

    This displays the Restart Load Plan Execution dialog box.

    Figure 13-10 Restart Load Plan Execution Dialog Box

    Surrounding text describes Figure 13-10 .

  2. Select OracleDIAgent from the Physical Agent drop-down list.

  3. Select the required log level from the Log Level drop-down list.

  4. Click Restart. This displays the Information dialog box with the Load Plan restarted message.

  5. Click OK.

    This adds another Load Plan, with the same name as that of the stopped ETL, in the Load Plan Executions folder of the Sessions/Load Plan Executions section. However, this instance of the Load plan is in Green color, which signifies that the ETL is in progress.

13.3.4 Processing a Stopped or a Failed ETL

The processing of a stopped or a failed ETL in ODI Console is same as the processing of a stopped or a failed ETL in ODI Studio.

For detailed information, see Section 12.3.4, "Processing a Stopped or a Failed ETL".