SAP Home Learn Build Integrate Model Operate Extend with AI ConnectTutorial navigator Knowledge Graph API Devtoberfest Developer Advocates App Space

Manage my Account SAP Devs YouTube ↗ Learnings ↗ Community ↗ Provide Feedback ↗
Logout
โคข Open full site

Create a Live Data Connection in SAP Analytics Cloud

Create a Live Data Connection in SAP Analytics Cloud to consume the calculation view built on SAP HANA Cloud.

Overview

🎓 intermediate 10 min. SAP HANA Cloud, SAP HANA DatabaseIntermediateSAP Business Technology PlatformSAP Business Application StudioSAP Analytics CloudSAP HANA Cloud

You will learn

  • โœ”Understand the setup of SAP HANA Cloud Live Data Connection in SAP Analytics Cloud
Unknown U Unknown November 1, 2022
Created by October 10, 2021
Contributors

Prerequisites

Prerequisites

  • You have Set Up a BTP Account for Tutorials. Follow the instructions to get an account, and then to set up entitlements and service instances for the following BTP services.

    • SAP Business Application Studio
    • SAP Analytics Cloud trial

    You will learn

  • Understand the setup of SAP HANA Cloud Live Data Connection in SAP Analytics Cloud

Steps

Intro

In this tutorial, you will learn about the creation of a Live Data Connection. The Live data Connection in SAP Analytics Cloud enables you to consume the calculation view created on top of SAP HANA Cloud as a data source to create visualizations.


Step 1 Create connection between SAP HANA Cloud and SAP Analytics Cloud
โ€”

  1. Navigate to SAP BTP trial and select the dev space and then choose the instances. Here you will get to see the application instances.

    HANA Con Creation
    HANA Con Creation

  2. Select the application that you have deployed in BAS.

    HANA COn Creation
    HANA COn Creation

  3. Click on the keys, to see the credentials to be used for establishing live connection in SAP Analytics Cloud.

    HANA COn Creation
    HANA COn Creation
    Using the schema details one can create a generic credentials set (like reporting user) which can later be used in SAP Analytics Cloud.

  4. Go to SAP Analytics Cloud trial, click on connections then click on the + icon to create a live data connection setting. Select connect to Live data then choose SAP HANA.

    HANA COn Creation
    HANA COn Creation

  5. Provide a name to HANA Live connection. Select the connection type as SAP HANA Cloud.

    HANA COn Creation
    HANA COn Creation

  6. Provide the hostname, language key, username, password details (The details are obtained from HANA application under deployed instances section of BTP trial) and click OK.

    HANA COn Creation
    HANA COn Creation

  7. This creates the HANA Live data connection setting.

    HANA COn Creation
    HANA COn Creation
    Next step is to create a Live data model based on the calculation view you have created.

Step 2 Test yourself
+

Resources

Discussion

Share feedback on this tutorial or join the conversation in SAP Community.

Submit detailed feedback Discuss in Community
Steps
Step 1 of 2
1. Create connection between SAP HANA Cloud and SAP Analytics Cloud 2. Test yourself

Learn more →