Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 20, 2017 at 04:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 09:43 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.