Salesforce to SAP CPI(Rojo) Integration

[former_member770619]

Hello Everyone,

I am currently working on a CPI and Salesforce Scenario, where CPI needs to get get details of Repair Service Order Creation from Salesforce System(SMAX) involving multiple s0bject. and sent it to S4(On-premise) through a Standard API.

So, I have gone through few blogs available on SAP SCN, but my query is- as it involves getting data from multiple s-objects, so should I do a individual query for each s-objects(like Work Order, asset, return order) and then merge them using gather function and then map it with S4 edmx file and sent it to S4 through API.

Is this a correct approach, or do we have any other better approach.

Please do let me know your thoughts, as It is my first scenario involving Salesforce Integration. with S4 via CPI

[Dorian_Sabitov]

Hi there! Your approach seems solid, especially for working with multiple s-objects. Running individual queries for each s-object, such as Work Order, Asset, and Return Order, and merging them using the gather function is a practical method. This allows precise mapping to the S4 EDMX file before sending the data via API to S4. For SAP Salesforce integration, you might also consider composite queries if relationships exist among the Salesforce data. This can help reduce the number of API calls and make the integration more efficient. Let me know if you'd like further insights—I’m happy to assist!

[SinhaSouvik]

Hi shayakmukherjee,

From my view, if you are getting the multiple SObjects data in single salesforce call then why would you do multiple salesforce calls.

There are couple of options available in adapter configuration to get multiple SObjects data in single call. Please follow the adapter document below sections:

• Salesforce Objects – Composite
• Salesforce Objects – sObject Collection

Regards,

Souvik

[former_member770619]

Hi Souvik,

Thanks a lot for your response. I was trying to take the composite route, but the composit xsd is so huge, that CPI tennant is getting timed out. Will see if i can get a fix regarding that, and will update you after that.

Best Regards

Shayak