Viewing Screenshots

Place
the cursor over this icon to load and view all the screenshots for this tutorial.
(Caution: Because this action loads all screenshots simultaneously, the response
time may be more depending on your Internet connection.)

Note: Alternatively, you can place the cursor
over each individual icon in the following steps to load and view only the screenshot
associated with that step.

The screenshots will not reflect the specific environment
that you are using. They are provided to give you an idea of where to locate specific
functionality in Oracle Data Integrator.

Overview

When a set of objects is complete and tested, a good practice is to create an ODI scenario for each object. After a scenario is created, it cannot be edited and the code for the object is regenerated and stored in the scenario. The created scenarios can also be scheduled for running virtually on any time interval within ODI. In this OBE, you create and schedule a scenario for the ODI procedure that was created in the OBE titled Creating an ODI Project and Procedure to Create and Populate a Relational Table.

Scenario

Linda works as a database administrator for Global Enterprise.
In Global Enterprise, Linda is responsible for performing database management and integration
tasks on various resources within the organization. In particular, Linda is responsible for data loading, transformation, and validation. To begin working on her projects, she created the new Master repository and Work repository. Linda also created the project and the procedure to create a relational table and populate it with data. She set up and installed an ODI Agent as a service. Now Linda needs to create and schedule an ODI scenario to run the procedure at the appropriate time.

Open the Services window (select All Programs > Administrative Tools > Services) and stop the Oracle DI Agent service if started. Close the Services window.

2.

Open (if not opened ) the Oracle XE DatabaseHome page: Start > All Programs > Oracle Database 10g Express Edition > Go To Database Home Page. The Login screen appears. Log in to the database as user ODI_STAGE3. The password for this user is password.

3.

On the Oracle Database 10g Express Edition Home screen, select SQL Commands > Enter Command from the SQL drop-down list. Enter and run the statement that is provided below. If the SRC_SALES_PERSON table exists, it is dropped. Otherwise, the message "table or view does not exist" is displayed.

drop table ODI_STAGE3.SRC_SALES_PERSON

4.

Open the Command window and change the directory to the ODI_HOME\bin directory (for example, I:\ODI\oracledi\bin). To start ODI Agent as a scheduler, execute the agentservice.bat file by using the following command:

agentscheduler.bat –NAME=localagent

Note: To perform this step, an ODI Agent must be set up. To set up an ODI Agent, see the OBE titled Setting Up and Installing an ODI Agent as a Background. To access this OBE, click HERE.

Note: If an ODI Agent is not set up within the ODI Topology Manager, the following error message appears: "To use the scheduling, please set an agent in your repository." To schedule a scenario, an Agent must be set up. To set up an ODI Agent, see the OBE titled Setting Up and Installing an ODI Agent as a Background. To access this OBE, click HERE.

6.

On the screen that follows, select the agent where the scheduled scenario will run: localagent. Set Context as Global and log level to 5. Set Execution to Simple and click the button. Set the execution time to approximately 5 minutes from the current system time as shown in the following screenshot. Click OK. Click OK again.

7.

Expand Scheduling and verify that the localagent entry is now inserted under Scheduling.

8.

Click the icon to start Topology Manager to review the scheduling of the Agent. Expand the Agents node, right-click localagent, and select Edit. On the Agent: localagent screen, click Update Scheduling. On the screen that follows, click OK.

9.

Click the Scheduling information button. The screen that appears shows you the scheduling information.

Verifying the Execution of the Scheduled Scenario with Oracle Data Integrator

To verify the execution of the scheduled scenario, perform the
following steps:

1.

To verify that your scheduled scenario was executed successfully, you need to open ODI Operator. Click the ODI Operator icon on the menu bar to start ODI Operator. In ODI Operator, click the Session List tab . Expand Date > Today > CREATE_AND_POP_SALES_PERSON, and view the execution results for the PRG_create-populate_table procedure.

2.

Expand Physical Agent > localagent > CREATE_AND_POP_SALES_PERSON, and view the execution results for the PRG_create-populate_table procedure. Note the execution time of this scenario, that is, the time that you scheduled with ODI Agent. You have now successfully scheduled a scenario with an agent scheduler. The scenario was executed by the agent successfully.

Note: If you want to execute the procedure again, you must first drop the SRC_SALES_PERSON table as described in step 2 of the "Scheduling a New Scenario with Oracle Data Integrator" section.