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 11.1.1.6 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
odiwsdl1

 

 

 

odiwsdl2

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.

Open Jdeveloper Studio and proceed as given in below screenshots.

Now create one webservice in the new project where we will be using the WSDL we got from admin console.



Copy the WSDl and pest it in the URL for all the functionality available in odi webservice.

odiwsdl11

odiwsdl12

Here we will go with OdiInvoke. If you are interested in call back then go for it.

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.

Anyway at this point we have everything setup. Start the service and wait untill HTTP Analyzer comes up.

 

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.

 

Steps to change the URL:

 

Select odiInvokeScen from Operation drop  down ( to start the scenario ). Provide the correct parameters and hit the send request button.

odiwsdl21

Amazing Man !!!  Here is the session id 2356091 of the scenario currently started.

odiwsdl22

Open ODIStudio to verify the session details. There you can see the same session id we got in JDeveloper.

Thats all for the day.  Comments are always welcome. See you in my next post friends.
Cheers 🙂

0

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts

6 comments

With JDEVELOPER, could you make an .exe file that you could share with user to launch this webservice?

I believe you can develop a java program to call the webservice and another option could be to call it from plsql.
In my blog i have already posted how to call from plsql. If i get some time i will try to develop custom java code to call the webservice.

Buffetaud Yann / Reply

Thank you very much. I’m a newbie with webservices and you helped me a lot.

it is super.can you give me personal mail id?

Hello,

My requirement is to read soap request and and based on that request need to capture all response that will get invoked to oracle table.

Now I have implemented this. For webservice calling – took ODIInvokewebservice to read output file that has been stored in directory with xml extention.
2. Able to read xml file and based on the value invoked that to target table.

I am very new to oracle tool ODI. I did all these parts with the help of google.

My question is like, every time my input will get changed with that particular wsdl, how can i get the updated value everytime.
Again is there any approach in ODI where I can define the step which after what will have the flow.

1. Read wsdl –> read data from xml–> then push to target.
Please let me know in detailed. Thank you in advance..!!

In odi12c webservices I can use as a incremental load can we briefly explain

Leave a reply

required*

Are you a human? *