One important parallel technological and current advancement in times of digitization is the continuous emergence of so called of “low-code, no-code” (LCNC) platforms. Currently, the Power Platform provided by Microsoft is considered to be one of the most stable, comprehensive and easy-to-use LCNC platforms on the market. The Power Platform enables the acceleration of analyzing data (Power BI), developing business apps (Power Apps), automating business processes (Power Automate) and utilizing digital agents (Power Virtual Agents). Hence, the ongoing growth of LCNC platforms like the widely used Microsoft Power Platform also lead to the implementation of more and more Business Apps. And at the end these ever increasing amount of Business Apps lead to a growing number of integration needs with SAP ERP systems.
Surprisingly, there are still few easily configurable connectors between the Power Platform and SAP solutions. There is an “SAP ERP” connector from Microsoft to connect Power Platform and SAP, but it is limited in its capabilities, and it also does not provide the benefits of a comprehensive middleware product for integration purposes.
For this reason, we at Campana & Schott have already extended our longstanding middleware called “CS Connect” by a Power Platform adaptor in addition to the pre-existing and plentiful options to integrate various SAP modules like PS, CO, CATS, HCM and others. This innovation now enables companies to connect various Business Apps based on the Power Platform with complex SAP solutions for a series of different use cases. Simultaneously it is easy to adapt these interfaces through custom configuration. CS Connect is a product for simple connection between systems and automates bidirectional data exchange, in which the Power Platform can also be individually connected. CS Connect functionalities include an extract, transform and load (ETL) tool, where data from one system are transferred to another one plus further functionality for e. g. monitoring, logging, notifications and interface orchestration. Furthermore, CS Connect also offers the capability to realize cloud-based, on-premises or hybrid scenarios for integration use cases. Finally, CS Connect also supports the integration not only with SAP ERP, but also with S/4HANA, which is becoming more important as according to the 2020 IDC study, 48% of companies are currently planning to migrate from SAP legacy system to S/4HANA. Hence, many customers want to understand if their current integration concepts not only work for their SAP ERP legacy systems, but also for their future S/4 HANA platforms.
But how do we integrate CS Connect with Power Platform? At Campana & Schott we have built a comprehensive solution for Project-, Program und Portfolio Management (PPM) based on the Power Platform called “CS PPM Power Suite”. For a PPM solution like this a whole set of different integration use cases to interface with SAP do exist. The following figure gives an insight into a typical set up of an integration between Power Platform and SAP in the context of integrated PPM processes.