A common task that is performed by using ODI is to create an ODI scenario and schedule its execution. You already developed the ODI procedure that creates a relational table and populates the relational table with data.
In this practice, you learn how to create and schedule an ODI scenario to run the procedure you created in Practice 12-1.
First, in the Designer Navigator’s Projects tab, you generate a scenario for the PRD-createpopulate-table procedure.
Then, in Topology Navigator, you verify connection to ODI Agent.
Next, in Designer Navigator, you schedule the scenario with ODI Agent.
You switch back to Topology Navigator to review the scheduling of the agent.
Finally, in Operator Navigator, after the scheduled scenario execution time, you verify that the scenario has executed.
Your Tasks:
1. Create a new scenario with Oracle Data Integrator.
a. If not connected, connect to the Work repository WORKREP. Select DEV_ODI_REPO from the Login Name drop-down list. Enter SUPERVISOR in the User field and SUNOPSIS in the Password field. Click OK to log in.
b. In ODI Designer, click the Projects tab. On the Projects tab, expand the project:Procedure-CRT-TBL > First Folder > Procedures. Right-click the PRD-createpopulate-table procedure and select Generate Scenario.
c. Name the scenario PRD_CREATE_POPULATE_TABLE. Set the Version to 001. Click OK.
d. Expand the PRD-create-populate_table procedure and expand Scenarios. Right-click the PRD_CREATE_POPULATE_TABLE scenario to view the possible options, as shown in the following screen.
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
2. Now you need to schedule an ODI scenario with ODI Agent. To schedule the scenario,perform the following steps:
a. In Topology Navigator, verify connection to ODI agent, as shown in the following screen.
Note: If ODI Agent is not set up and running, you must perform the steps specified in Practice 3-1 before continuing.
b. 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 Practice 3-1, “Setting Up and Installing an ODI Agent.”
c. On the screen that follows, select the agent where the scheduled scenario will run:
localagent. Set Context as Development and log level to 5. Set Execution to Simple and click the
button. Set the execution time to approximately five minutes from the current system time, as shown in the following screen. Click the Save button.
d. Expand Scheduling and verify that the DEVELOPMENT / localagent entry is now inserted under Scheduling.
e. Start Topology Manager to review the scheduling of the Agent. In the Physical architecture, expand the Agents node and double-click localagent. On the localagent screen, click Update Schedule. On the screen that follows, click OK. Click OK again.
f. Click the View Schedule button. The screen that appears shows you the scheduling information. Click OK to close schedule. Close the tabs: Localagent tab and Scenario Scheduling.
3. To verify the execution of the scheduled scenario, perform the following steps:
a. Click the ODI Operator tab to open ODI Operator. In ODI Operator, click the Session List tab. Wait until the scheduled execution time to view the execution results, and then
click the Refresh icon.
b. 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.
In this practice, you learn how to create and schedule an ODI scenario to run the procedure you created in Practice 12-1.
First, in the Designer Navigator’s Projects tab, you generate a scenario for the PRD-createpopulate-table procedure.
Then, in Topology Navigator, you verify connection to ODI Agent.
Next, in Designer Navigator, you schedule the scenario with ODI Agent.
You switch back to Topology Navigator to review the scheduling of the agent.
Finally, in Operator Navigator, after the scheduled scenario execution time, you verify that the scenario has executed.
Your Tasks:
1. Create a new scenario with Oracle Data Integrator.
a. If not connected, connect to the Work repository WORKREP. Select DEV_ODI_REPO from the Login Name drop-down list. Enter SUPERVISOR in the User field and SUNOPSIS in the Password field. Click OK to log in.
b. In ODI Designer, click the Projects tab. On the Projects tab, expand the project:Procedure-CRT-TBL > First Folder > Procedures. Right-click the PRD-createpopulate-table procedure and select Generate Scenario.
c. Name the scenario PRD_CREATE_POPULATE_TABLE. Set the Version to 001. Click OK.
d. Expand the PRD-create-populate_table procedure and expand Scenarios. Right-click the PRD_CREATE_POPULATE_TABLE scenario to view the possible options, as shown in the following screen.
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
2. Now you need to schedule an ODI scenario with ODI Agent. To schedule the scenario,perform the following steps:
a. In Topology Navigator, verify connection to ODI agent, as shown in the following screen.
Note: If ODI Agent is not set up and running, you must perform the steps specified in Practice 3-1 before continuing.
b. 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 Practice 3-1, “Setting Up and Installing an ODI Agent.”
c. On the screen that follows, select the agent where the scheduled scenario will run:
localagent. Set Context as Development and log level to 5. Set Execution to Simple and click the
button. Set the execution time to approximately five minutes from the current system time, as shown in the following screen. Click the Save button.d. Expand Scheduling and verify that the DEVELOPMENT / localagent entry is now inserted under Scheduling.
e. Start Topology Manager to review the scheduling of the Agent. In the Physical architecture, expand the Agents node and double-click localagent. On the localagent screen, click Update Schedule. On the screen that follows, click OK. Click OK again.
f. Click the View Schedule button. The screen that appears shows you the scheduling information. Click OK to close schedule. Close the tabs: Localagent tab and Scenario Scheduling.
3. To verify the execution of the scheduled scenario, perform the following steps:
a. Click the ODI Operator tab to open ODI Operator. In ODI Operator, click the Session List tab. Wait until the scheduled execution time to view the execution results, and then
click the Refresh icon.
b. 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.
No comments:
Post a Comment