Querying Data From Salesforce to SAP BW/4HANA by SAP PI/PO as middleware ?

[Dhanola]

Hi there, I am new to SAP PI/PO. I want to know the steps to fetch the data from Salesforce to SAP BW/4HANA by SAP PI/PO as middleware. My case is that I have to pass a SOQL query to salesforce using rest API and the data that will come will need to be captured in SAP PI/PO, where I have to create a configuration such that the data I have to fetch from the API until I don't get all the records, because salesforce has a limitation of 2000 records to fetch at a time. Then we have to use the nextURL key from the response which gives us the URL for the next chunk of rows. until another field which is coming in response called done does not have its value as true. After The Data is gathered I have to send those data to the SAP BW/4HANA where these data will be stored in tables for which I have to do some ABAP developments.

=> In Short I need the detailed steps on how to perform this anyone who has done this earlier and knows the integration stated above will be helpful.

Thanks

[a_nagelhout]

Hi there,

SAP PI/PO is middleware and what you are looking for is an ETL tool. Fortunately SAP BW contains ETL functionality, so no need to use middleware here, just connect to Salesforce from SAP BW.  

best regards, André

[a_nagelhout]

PS: also see https://community.sap.com/t5/technology-q-a/extract-data-from-salesforce-to-sap-bw/qaq-p/10467094

[Dhanola]

Hi there, I think i had made a bit confusion, actually i want to send the rest api request from sap ecc using abap programmming to salesforce (SFDC) via SAP PI/PO as middleware and the response will be then captured in SAP ECC in the PORXY TABLES, from where using ABAP CODE I will dump those data from proxy table to SAP TABLES ALready created to consume this data.