Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
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.

Proposed Solution

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.