synchronous soap to jdbc

[Former Member]

hi all,

i am doing soap to jdbc synchronous, after reaching the data to receiver, how to send back the data from receiver to sender.

Regards,

priya

[Former Member]

hi,

You have to do the another source and target structure to get the response from DB to SOAP.

Structure should be like this:

source:

---+MessageType_SYS1(occ 1-1)

-

---

+STATEMENT_response(occ 1-unbou)

-

---

insert_count(0-1)

Target:

---+MessageType_SOAP

-

---

+item_interface

-

---

insert_count

Map all the source fields to respective target.do the ID part.you will get the response from DB,once table insert.

table inserted if insert tag is "1",otherwise it will be a zero.

[Former Member]

Dear Priya,

Apart from the normal configuration for synchronous scenarios, there should be some thing in the JDBC ( Data Base Server) that can send the data to the PI server.

I hope you can do this using Stored Procedures. I think it is just like RFC to any R/3 Server to work out a Synchronous scenario.

So write a stored procedure that takes the input values( Received values) get the output from a stored procedure as input to PI.

Best Regards

Praveen

[former_member182455]

Hi priya,

check this links

http://help.sap.com/saphelp_nw04/helpdata/en/32/a63d40c6d98437e10000000a155106/content.htm

regards

srinivas

[Former Member]

Hi Priya Reddy,

Check this blog it is very useful for ur scenario

Regards,

Sateesh