calling webservice in udf for inserting data into webservice

[Former Member]

Dear Experts,

Please give me the drawbacks of using lookup function for inserting data. we are calling a webservice from the udf for inserting the data using a webservice.

It is a file to jdbc usnig a soap lookup . we use this approach because we need to pass the response from webservice along with the error data to the jdbc. is there any other way to do it without using bpm ?

In the udf we are creating the xml structure for webservice and passing the parameters through arguments.

is there a better approach for this ?

Thanks,

Aju

[Former Member]

Hi Aju,

You can do it without BPM.

Write UDF for Soap Lookup. Parse the response message from Webservice. and map the required values to respective fields.

See the weblog

Negative point of this solution is that it will take some time to call Webservice and get response back from it.

Kulwinder