ODI Online Training: ODI11G:Creating and Scheduling an ODI Scenario

Create a New ODI Scenario with Oracle Data Integrator

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

1 .	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.
2 .	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.

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

1.	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".
2.	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.”
3.	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.
4 .	Expand Scheduling and verify that the DEVELOPMENT / localagent entry is now inserted under Scheduling.
5 .	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.
6 .	.Click the View Schedule button. The screen that appears shows you the scheduling information.

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

1.	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.
2.	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.