Being able to consume Odoo in SAP Analytics Cloud
One of our customers recently asked us to be able to report in SAP Analytics Cloud over its two ERPs. The first is an SAP ECC6 ERP that contains its financial data. The other is the Odoo ERP containing its operational data. I do not wish to address the reasons for this situation in this article. We often intervene with clients with decisions inherited from the past. On the other hand, it is up to us to build a user experience around the needs of BI-Planning that is a success. Our goal in this case is that the end user does not notice any difficulty.
Thus, to recover the financial data of the ECC6 ERP this posed no problem to SAP Analytics Cloud and its native connectors. On the other hand, it was more complex to recover the operational data of the 2nd ERP Odoo (mainly logistics). In the end, the customer asked us to have a screen to analyze the availability of his stocks. Having real-time visibility of its stock should allow it to make faster decision-making at the logistics level.
But what is Odoo?
What is the recommended SAP architecture?
- a solution with minimal impact on its current infrastructure (so we preferred the cloud)
- data recovery without technical action (we have proposed CPS and SAP Datavisualization tools that connect to it)
- Reminder: For the record, the SAP Cloud Platform is a SaaS offer from SAP that provides a database and a variety of services. It allows you to build applications adapted to the customer’s business. and able to interact with other SAP software (the SAP HANA database, the ERP, or as in our example the platform of BI – Planning SAP Analytics Cloud)