Invoke ODI Scenario using Web Service
Invoke ODI Scenario using Web Service:
Here is the post with brief description on invoking ODIscenario using web service in JDeveloper. Now you can easily invoke scenarios, loadplans as well as get the status from it. Below are the options that we can handle in JDeveloper.
Ok, so you need to have weblogic 10.3.6 and jdeveloper 18.104.22.168 installed on your machine. 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. Again before proceeding to next step please ensure that you have configured Java EE Agent successfully and that is up right now. If you have not configured then follow this link. Now if your Java EE Agent is up then login to the weblogic admin console and click the deployments as given in below screenshots
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.
This is how the WSDL page looks in chrome browser.
Here is the sceenshot of the WSDL page in chrome browser.
Now create one webservice in the new project where we will be using the WSDL we got from admin console.
Wow !! Did you notice anything new here ? Actually we have got all the necessary .java files to invoke ODI Objects. If you love java programmings you must see the code written there.
make sure the import is marked with green tick mark. If we would have got any warnings there then you have to fix the issues manually.
Okay. Does everything looks perfect to you at this point ????
Hmmm, the WSDL seems to be incorrect. Right ? Its not exactly like we saw in the browser. So we have to rectify it before we go to to next step. Just open and modify it to the original one. Details on this change is given below.
Select odiInvokeScen from Operation drop down ( to start the scenario ). Provide the correct parameters and hit the send request button.
Amazing Man !!! 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.