Skip to Content
0
Dec 13, 2022 at 09:55 AM

SAP CPI - Data Lock Management - Options ?

207 Views

Hello SAP Community,

We have the following requirement on our BTP project. We have several iFlows (lets say iFlow 1, iFlow 2 and iFlow 3) which will receive data, in our case clients to be invoiced, that will be integrated afterwards in a S/4 system.

These iFlows can receive in some cases the same client (for example at one moment in time iFlow 1 and 2 receive data for client 1, iFlow 1 and 3 receive data for client 2, ...). The requirement is that two iFlows cannot treat information on the same client at the same time : if iFlow1 and iFlow2 receive information about client 1, the first iFlow to have received that information must say somewhere that this client is being used and no other iFlow can treat it.

Being used to this kind of problems in Public Cloud Providers, the first thing that came to my mind is used a DynamoDB table (our BTP account is hosted on AWS) or at least a No-SQL Key-Value DB, where the different iFlows will check if the received client is being used or not. My exact question would be :

- I see that we can "link" a DDB table from our AWS subscription to our BTP environement. However, I am a bit concerned with the performance in this case so I would prefer not go for this option.

- The HANA Cloud option seems a little expensive for this kind of use case.

- Is there some BTP native No-SQL solution ? From my reading I think not. i read about Data Store in Cloud Integration but I am not sure to fully understand it and the technology behind.

- Do you have any recommandation for the implementation of this use case ?

Thank you very much for your help.

Regards,

Thomas