Skip to Content
0

Sending data from PI to BW and getting back a response synchronously

Mar 20, 2017 at 03:48 PM

239

avatar image

Hello. We are working on a solution where PI receives a payload via a SOAP sender and sends it to BW through an RFC call. We are able to send data from PI to BW but the response that we get back is the following:

<rfc:_-BIC_-CQLICATXM00001000.Response xmlns:rfc="urn:sap-com:document:sap:rfc:functions"></rfc:_-BIC_-CQLICATXM00001000.Response>

I know very little about BW and ABAP. All i know is that when data is loaded into PSA, the above response is sent back immediately to PI. Then there is a daemon that runs hourly to load the data from PSA to DSO. What we need to capture in PI is the status of how the data was loaded into DSO (whether there were any errors or whether it was successful).

My question is, what is the correct approach to achieve this? And more specifically, does DSO capture the status of the data loads from PSA? Where is it being captured (are there logs)? Can DSO send this data back to PI through an asynchronous call via RFC or SOAP? Is there an alternative method of triggering the DSO load without having to use the daemon, so ideally, when the data is successfully loaded into PSA the DSO load is triggered, waited on and the response is synchronously sent back to PI ?

Thank you very much for your feedback!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Iñaki Vila Mar 20, 2017 at 04:20 PM
0

Hi Leo,

One way is not to use the PI, if your ECC and BW are in the DMZ, the BW can connect directly to a ECC module function (with RFC supported).

However, depending about you need the data loaded you can opt with PI or not.

https://blogs.sap.com/2006/12/08/business-case-integration-need-of-bi-and-sap-xi-episode1/

About your question:

Can DSO send this data back to PI through an asynchronous call via RFC or SOAP?

Yes, you can configure an async scenario in PI.

Regards

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Mar 20, 2017 at 09:43 PM
0

Hi Leo!

I'm not much experienced in integration with SAP BW, but I had one integration scenario SOAP-BW and as I remember I used push data source in BW to receive data from third-party system via SOAP.

Regards, Evgeniy.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Evgeniy,

We do have a similar scenario, where a Sharepoint site is sending data as a SOAP message through PI to BW. This message is being sent synchronously, so the Sharepoint is expecting a response. Would you be able to describe how was the BW layer implemented in your solution? Was there a custom BAPI developed to handle the requests and produce a response? Was your solution even synchronous?

Thanks!

0

Hi Leo!

It was a long ago, but as I can remember I just closed synchronous connection with sender using technical answer and sent the data to BW asynchronously putting it to push data source. Further BW started data extraction by schedule and opened new data source for the following data.

Regards, Evgeniy.

0