Design consideration

[Former Member]

A .Net appl needs to send data async to Database and then Database needs to do some computation on it , a process already exists and then the Databse needs to update the SAP using proxy or IDOC real time. In this case ,2 spearate interfaces are needed.?

secondly is there any advantage of using stored procedure in this case on sender side ?

[Former Member · Accepted solution]

Hi,

In this case ,2 spearate interfaces are needed.?

Yes.

1. SOAP -> PI -> JDBC

2. JDBC -> PI -> Proxy / IDoc

You can even make it like this:-

SOAP (async) -> PI -> JDBC (sync) -> PI -> Proxy / IDoc ... use IP in this case.

secondly is there any advantage of using stored procedure in this case on sender side ?

Completely depends on your requirements.

Regards,

Neetesh

[Former Member · Accepted solution]

what advantage will a stored procedure have over direct reads , i understand it depends on req. but is there any direct advantage ? in this case sender side stored procedure will be required

Edited by: xi project on Jun 24, 2010 11:23 PM

[Former Member · Accepted solution]

what advantage will a stored procedure have over direct reads?

Check this out -

http://wiki.sdn.sap.com/wiki/display/XI/Advantages-DisadvantagesofStoredProcedureinJDBCScenario

in this case sender side stored procedure will be required

Receiver in case # 1, sender for case # 2.

[Former Member · Accepted solution]

What do you mean by computation process? Are you going to do with the data you are sending into the datbase or once when you send the data some process is there at the databse level. If it is with the data you send then how will you handle those things etc should be taken care.

Else some process on database once data inserted then if you use BPM and if that computation fails how do you handle etc should be analysed properly. Here the computational process is important because it is not at xi level and it is at datbase level. So the control from xi would be less. You need to analyse this properly.

Regards,

---Satish

[Former Member]

Hi,

It depends upon the database process. You can use one interface with the help of BPM. The design would be like this:

Source --> Synchronous send step (send to the database using a stored proc and wait for the response) ---> send the response directly to proxy or idoc. If you need some changes then use a transform step and then the send step to proxy/idoc.

Else

first create an interface and send data to database and let the second interface picks the data from datbase and update the proxy. So it all depends upon how much processing is there in the computation process. If less then first design else this design.

Regards,

---Satish