Skip to Content
Technical Articles

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.

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.

4 Comments
You must be Logged on to comment or reply to a post.
    • Hi Subash,

      Thank you for you question. There is no data replication between SQL and HANA. The live connection is end-to-end from SAC to SQL. Only result set is sent to HANA.

      Best,

      Kevin

  • Thanks, Kevin, this is great!

    A clarification about the security: SSO is only available for SAP Hana (not an option with a -eg- remote MS SQL/Oracle), correct?
    And the case of  secondary credentials, how would you replicate / inherit this into SAC (origin>HANA>SAC)?

    Thanks