Forum Discussion

Chandu509's avatar
Chandu509
New Contributor III
2 months ago

Establishing integration between OneStream and S/4HANA Public Cloud

Hello,

Could you please let me know the available options to pull trial balance data from S/4HANA Public Cloud into OneStream?

Thanks,

 

4 Replies

  • tschilling's avatar
    tschilling
    New Contributor III

    Check out the documentation for the SAP Connector for OneStream. https://documentation.onestream.com/1375907/Content/PDFs/SPC_PV8.0.0_SV211_Instructions.pdf

  • mireles's avatar
    mireles
    New Contributor III

    We are currently facing the same situation at my company. We've considered using the newly released SAP Connector but our SAP experts are not convinced; they're unsure that it's possible to expose the oData v2 WebAPI endpoints via the SAP Integration Suite. They consider it a Security Concern to expose the endpoints directly from the ERP itself. Even if it is possible to expose the endpoints through the Integration Suite I'm not sure that the OneStream Connector would be able to connect in this case. Other things we're considering exploring:

    • Having our Business Units extract ledger info to middleware (Fabric, OneLake, ...). In this case we would look for a way for OneStream to consume APIs from this middleware, perhaps using an Azure Function, Azure API Mgmt, or something else.
    • Developing APIs for our OneStream environment that SAP can then consume: I'm pretty sure this is not possible, but since this is the approach we're going with for other applications our Data Architecture team is pretty keen on us making it work.

    If you find a way please let me know!

    • tschilling's avatar
      tschilling
      New Contributor III

      Are you trying to push data back to SAP or pull it in from SAP?  The 2nd bullet point sounds like you want SAP to consume an API from OneStream?  Or, do you mean like creating a Bulk Load API so to speak for SAP to push data into OneStream?

      Have seen multiple clients run into the same security concerns with their I/T groups, so it is not uncommon for I/T to create an abstraction layer using Azure API, or any API service, that just simply calls the underlying SAP API services (WEBApi, BAPI, etc...) in it's own REST API endpoint.  Sometimes this can be useful as often the I/T team can create the EXACT data structure you're looking to pull in.  

      DM me if interested in talking in more detail, have had multiple clients accomplish this several different ways!

      • mireles's avatar
        mireles
        New Contributor III

        Are you trying to push data back to SAP or pull it in from SAP?

        We're trying to pull data from SAP. 

        The 2nd bullet point sounds like you want SAP to consume an API from OneStream?  Or, do you mean like creating a Bulk Load API so to speak for SAP to push data into OneStream?

        Exactly, the idea in this case would be for SAP to consume an API so that it pushes data in bulk to OneStream!

        DM me if interested in talking in more detail, have had multiple clients accomplish this several different ways!

        Message sent! Thank you so much.