SAP Analytics Cloud: Expand Live Data Connectivity to Heterogenous Data Sources via SAP HANA
This blog post introduces a solution to expand SAP Analytics Cloud live analytics across 11 new data sources with SAP HANA Smart Data Access and SAP HANA Smart Data Integration.
To expand the SAP Analytics Cloud real-time analytics across heterogeneous sources, we leverage SAP HANA 2.0 on-premise to connect to on-premise and cloud systems. SAP Analytics Cloud provides live data connection to SAP HANA, and SAP HANA accesses remote sources using SAP HANA Smart Data Access and SAP HANA Smart Data Integration.
The above figure illustrates the proposed solution that utilizes SAP HANA as a data gateway to remote sources. Among the heterogenous sources, SAP Analytics Cloud live connectivity can be expanded to 11 new data sources: Microsoft SQL Server, Oracle, IBM DB2, Google BigQuery, and several other databases with SAP HANA Smart Data Access; SAP ERP and MySQL with SAP HANA Smart Data Integration.
The Advantages of this solution
When using SAP HANA as a single gateway access to data in remote sources, it offers the following advantages:
- Support your business decisions with real-time analytics
- No replication of authorization models and authorization model always up to date
- Adding hierarchical analysis to originally flat data
How to implement this solution
I have created a How-To Guide to comprehensively show the configuration steps with 2 examples. One example is to connect to Microsoft SQL Server using HANA Smart Data Access; the other is to connect to SAP ERP using HANA Smart Data Integration. It would be very similar to connect to the rest data sources.
Thus, if you want SAP Analytics Cloud live connect to any of these 11 data sources, and you have HANA 2.0 on-premise, this solution will be one of the best choices for you and your business to build real-time reporting.