Live Analytics Across All Your Enterprise Data Powered by SAP HANA Cloud
Most organizations today recognize the imperative of leveraging data and analytics to steer their business to success. A few months ago, I wrote a blog on Live Analytics powered by SAP HANA on-premise that introduces a solution for SAP Analytics Cloud to expand live analytics to heterogenous data sources, including non-SAP data sources. In this blog, I would like to share with you how the combination of SAP Analytics Cloud and SAP HANA Cloud can help you make decisions relying on real-time data, empower you to steer your company to success. Specifically, SAP HANA Cloud in this solution acts as a single gateway for all your data. It securely connects SAP and non-SAP data in real-time.
In the world of analytics, real-time reporting has been sought after for years. SAP Analytics Cloud currently supports real-time reporting based on the live data. However, SAP Analytics Cloud can live connect to a few data sources and only SAP systems. This limits the use cases where customers want a live connectivity to other SAP systems or non-SAP data sources. With SAP HANA Cloud as a single gateway, SAP Analytics Cloud performs analytics on live transactional data, structured, in real-time and without data duplication. Moreover, the live data can be stored on premise or in the cloud, and from any SAP or non-SAP systems. Hence, SAP Analytics Cloud becomes a central analytics solution for all your enterprise data.
SAP Analytics Cloud and SAP HANA Cloud are both cloud services. This cloud-native solution benefits from all cloud qualities like low TCO, elasticity, high availability, etc. Furthermore, SAP HANA Cloud is not just a data gateway to heterogenous sources. The live data connection to from SAP Analytics Cloud to SAP HANA Cloud also benefits from drill-down analysis, smart features, etc. Apart from exposing data from various remote sources in the form of virtual tables, data virtualization allows to combine these data with data resides in the SAP HANA physical tables.
This solution leverages SAP HANA Smart Data Access (SDA) and SAP HANA Smart Data Integration (SDI) to virtually access the remote sources as if the data were stored in local tables in SAP HANA Cloud, without copying the data into SAP HANA Cloud.
Especially, BAPI RFC connection is supported including SAP S/4HANA and SAP ECC, BAPI RFC offers a rich interface to interact with SAP ERP system, not limited to CDS views in SAP S/4HANA anymore. The best practice is that BAPIs must be designed in a way that only aggregated result returns from SAP ERP’s underlying database to SAP ERP’s ABAP layer, and in turn to SAP HANA Cloud. In this way, not only the data flow will be minimized across components to ensure the best performance, but the database engine is also leveraged to efficiently process the data aggregation, better than using ABAP engine.
I would also like to share a how-to-guide to show you the step-by-step configurations, and best practices. Two scenarios are covered in the how-to guide: Live Analytics to Relational Databases and Live Analytics to SAP ERP. While the examples within the how-to guide may not be for the exact data source, the architectural principles and configuration sequences are consistent across other data sources as well.
I hope you found this blog post useful. Let me know in the comments if you have any questions.