Invoke ODI Scenario using Web Service:
Here is the post with brief description on invoking ODI scenario from third party applications. This will help to call scenarios, loadplans etc based on custom requirement that can be triggered from a different applications all together.
Ok to start with, you need to have Weblogic 10.3.6 and Jdeveloper 22.214.171.124 installed on your computer. If you do not know where to download, click on this link.
Keep in mind that when you are going to install Jdeveloper, install it in a different directory rather than the existing middleware home. Additionally, you need to ensure that you have configured Java EE Agent and it is up and running at the moment. If you have not configured then go through this link set it up.
Click on OdiInvoke and then go to Testing tab. Right now you can see the WSDL and Test client link. If you click on Test client you can see the page in web browser where we can directly invoke scenarios, loadplans,scenario call back, scenario get status etc. You just have to change the parameter available in soap envelope. Once done, click on the invoke button. This will lunch the scenario in ODIStudio.
If you click on it, it will open with a test client as shown below. Thats quite intuitive as you have the flexibility to execute it right away.
If you want store the file then curl it or check it on a browser.
Now you can use odi studio or any third party application to invoke it. In my case I am creating a generic project in Jdeveloper.
Now create one webservice in the new project where we will be using the WSDL we got from admin console.
Here we will go with OdiInvoke. For call back you must have another application listening on specific port.
Bangon!! Did you notice the auto generated code for wsdl methods. That is definitely going to save some of your time. And yes thats the point of using an IDE.
Make sure the import is marked with green tick mark. If you see any warnings then you need to fix it before moving to next step.
Okay. Does everything looks perfect to you ???? Nope ?
Select odiInvokeScen from Operation drop down ( to start the scenario ). Provide the correct parameters and hit the send request button.
Woohoo !!! Here is the session id 2356091 of the scenario currently started.
Thats all for the day. Comments are always welcome. See you in my next post friends.