Pushing data from SAP into OneStream

Dear tschilling and Krishna,

Thank you for your responses.

I will provide a more detailed description of my case.

We have our reasons for not being able to use data retrieval through OneStream. It is related to the opinion of the risk management team - a token available for a year is not acceptable. The maximum token activity should be 1 hour. We know there are options like Azure AD authorization, but unfortunately, we learned from support that this is only available for on-premises installations. Another reason is that SAP already has a solution in place, so we would only need to add OneStream as an endpoint on their side.

It is also noticeable that there is no direct out-of-the-box solution that could help us achieve this. The most feasible seems to be a solution involving an intermediary who would 'receive' data from SAP and then initiate data retrieval through OneStream.

Currently, we are communicating with SAP through files, but this method is inefficient and heavily dependent on manual input, which is why we want to automate the process and use APIs.

Therefore, I created a post on the forum because perhaps someone already has a solution in production that they could share or would be willing to share.