[ODI 11g] ODI Scenario

ODI Scenario

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

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:

1 .	Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g
2 .	Have installed Oracle Data Integrator 11gR1
3 .	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

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.

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

1 .	Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g
2 .	Have installed Oracle Data Integrator 11gR1
3 .	Before attempting this you should have successfully completed the following: 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 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.         Scheduling the ODI Scenario 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 underScheduling. 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.  Verify Execution of Scheduled ODI  Scenario 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.