ODI11g: Creating and Scheduling an ODI Scenario

<Do not delete this text because it is a placeholder for the generated list of "main" topics when run in a browser>

Purpose

This tutorial walks you through the steps that are needed to create and schedule an Oracle Data Integrator (ODI) scenario.

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.

Software and Hardware Requirements

The following is a list of software requirements:

The system should include the following installed products:
- Oracle Database 11g
- Oracle Data Integrator 11gR1
If not done before, start the services and components for Oracle Database 11g

Prerequisites

Before you start the tasks, make sure that your system environment meets the following requirements:

.	Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g
.	Have installed Oracle Data Integrator 11gR1
.	Before attempting this OBE, you should have successfully completed the following OBE: ODI11g: Creating and Connecting to ODI Master and Work Repositories. ODI11g: Creating and Connecting to ODI Agent ODI11g: Creating and ODI procdure to Create and Populate RDBMS Table To access these OBEs, click HERE.

Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g

Have installed Oracle Data Integrator 11gR1

Before attempting this OBE, you should have successfully completed the following OBE:

ODI11g: Creating and Connecting to ODI Master and Work Repositories.
ODI11g: Creating and Connecting to ODI Agent
ODI11g: Creating and ODI procdure to Create and Populate RDBMS Table

To access these OBEs, click HERE.

Create a New ODI Scenario with Oracle Data Integrator

To create a new ODI Scenario with ODI, perform the following steps:

.	Start ODI Designer: Start > Programs > Oracle > Oracle Data Integrator > ODI Studio . Select WORKREP1 from the Login Name drop-down list if not already selected. Enter SUPERVISOR in the User field and SUNOPSIS in the Password field. Click OK to login.
.	Expand the PRD-create-populate_table procedure and expand Scenarios. Right-click the PRD_CREATE_POPULATE_TABLE scenario, and then click Generate Scenario as shown in the following screenshot. Note: The scenario has now been successfully created. You can now execute the scenario directly, use the scenario within a package, or schedule the scenario within ODI.

Start ODI Designer: Start > Programs > Oracle > Oracle Data Integrator > ODI Studio . Select WORKREP1 from the Login Name drop-down list if not already selected. Enter SUPERVISOR in the User field and SUNOPSIS in the Password field. Click OK to login.

Expand the PRD-create-populate_table procedure and expand Scenarios. Right-click the PRD_CREATE_POPULATE_TABLE scenario, and then click Generate Scenario as shown in the following screenshot.
Note: The scenario has now been successfully created. You can now execute the scenario directly, use the scenario within a package, or schedule the scenario within ODI.

Scheduling the ODI Scenario

Now you need to schedule an ODI scenario with ODI Agent. To schedule the scenario, perform the following steps:

.	In Topology Navigator, open: Physical Architecture > Agents > localagent. Click Test to verify connection to ODI agent, as shown below. Note: If ODI Agent is not set up and running, you have to perform steps specified in OBE "Setting UP and Installing an ODI Agent".
.	Expand the PRD-create-populate-table procedure. Expand Scenarios > PRD_CREATE_POPULATE_TABLE Version 001. Right-click Scheduling and select New Scheduling. Note: To schedule a scenario, an ODI Agent must be set up. If an ODI Agent is not set up within the ODI Topology Manager, perform OBE: "Setting Up and Installing an ODI Agent.”
.	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 Save button.
.	Expand Scheduling and verify that the DEVELOPMENT / localagent entry is now inserted under Scheduling.
.	Open Topology Navigator to review the scheduling of the Agent. In the Physical architecture, expand the Agents node, double-click localagent. On the localagent screen, click Update Schedule. On the screen that follows, click OK. Click OK again.
.	.Click the View Schedule button. The screen that appears shows you the scheduling information.

Verify Execution of Scheduled ODI Scenario

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

.	Click the ODI Operator tab to open ODI Operator. In ODI Operator, click the Session List tab. Wait until scheduled execution time to view the execution results, and then click the Refresh icon.
.	Expand: Physical Agent > localagent -1> PRD_CREATE_POPULATE_TABLE, and view the execution results for the PRD-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.

Click the ODI Operator tab to open ODI Operator. In ODI Operator, click the Session List tab. Wait until scheduled execution time to view the execution results, and then click the Refresh icon.

Expand: Physical Agent > localagent -1> PRD_CREATE_POPULATE_TABLE, and view the execution results for the PRD-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.