Executing an ODI Scenario Through the ODI Public Web Service 1

This practice has two aims: 1) To teach you how to execute a scenario through the ODI public Web service and 2) To become familiar with the use of the OdiInvokeWebService tool. Therefore, the OdiInvokeWebService tool will be used to invoke the ODI public Web service that commands an agent to connect to a given Work repository, and to start a specific scenario. In this practice, you use the interface created in Practice 10-1.
1. Create and execute a new scenario, INT_EXP_FF_RT.
2. Create a new package, OdiInvokeWebService.
3. Select the OdiInvokeWebService tool from the toolbox and create the corresponding
step in the package.
4. Define parameters of the Web service by using the Advanced dialog box and SOAP Editor.
5. Invoke your Web service from the SOAP Editor to execute the scenario INT_EXP_FF_RT.
6. View the response and verify the execution results.


Your Tasks:
1. If not connected, connect the Work repository, WORKREP. To connect, click Connect to Repository. 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.



a. In the ODI Designer tab, expand the project Export-FF-RT > First Folder >Interfaces. Right-click the interface INT_EXP_FF_RT, and then select Generate Scenario. Name the new scenario: INT_EXP_FF_RT. Set the version to 001.



b. In the Topology Navigator, verify connection to your standalone agent localagent.Note: Ensure that your standalone agent is created and successfully started. To create and start an ODI agent, refer to Practice 3-1.



c. Expand the interface and execute a newly created scenario, as shown below. For Agent, select localagent. Click OK to confirm the execution.




d. To view the results of the execution in Operator, click the Operator icon on the Designer toolbar. Click Refresh. Expand the All Executions node. The INT_EXP_FF_RT session should appear as complete.

2. Create a new package by using the OdiInvokeWebService tool.
a. On the Projects tab, expand the project Procedure-CRT-TBL > First Folder >Packages. Right-click Packages and select New Package. Enter OdiInvokeWebService in the Name field, and then click the Diagram tab.



b. Scroll down and select the OdiInvokeWebService tool from the toolbox. Click the diagram workbench. An OdiInvokeWebService tool step appears in the package.




c. In the Properties panel, retain the default name OdiInvokeWebService 1 for the Step name field. Scroll down, and define the parameters in the Properties panel as follows:
















d. Click the Advanced button. A new window opens. Enter http://localhost:20910/oraclediagent/OdiInvoke?wsdl for the Web
Service Description File (WSDL) URL field. Click the Connect to WSDL button .The appropriate port OdiInvokePortType is automatically detected and the available operations are displayed at the left.




e. Select the invokeStartScen operation in the left panel and then enter the parameters in the request parameter fields as provided in the following table. Your SOAP Editor panel should appear as follows.
Note: Press Enter each time to confirm your entries.


Parameter                                             Value
<OdiUser>                                          SUPERVISOR
Practices for Lesson                                       20
Chapter 19 - Page                                        10
<OdiPassword>                                      SUNOPSIS
<WorkRepository>                                 WORKREP
<ScenName>                                           INT_EXP_FF_RT
<ScenVersion>                                                  001
<Context>                                                   DEVELOPMENT
<LogLevel>                                                              5
<SyncMode>                                                             True


No comments:

Post a Comment