Skip to Content

Create a Live Connection Between SAP HANA Cloud and SAP Analytics Cloud

Set up a live connection between your SAP HANA Cloud database and SAP Analytics Cloud, using two different types of authentication create the connection.
You will learn
  • How to set up a live connection between SAP HANA Cloud, SAP HANA database and SAP Analytics Cloud
  • How to use user credentials method to authenticate users for a live connection
  • How to use single sign-on method to authenticate users for a live connection
Created by
VijayKrishnanSR
August 8, 2021
Contributors
VijayKrishnanSR

Prerequisites

In this tutorial, you will see how to setup a live connection between your SAP HANA Cloud, SAP HANA database and SAP Analytics Cloud. This connection gives SAP Analytics Cloud users access to data within HDI containers inside your SAP HANA Cloud, SAP HANA database. The HDI containers must have a calculation view inside, which determines which subsets of data are made available to SAP Analytics Cloud.

There are two approaches to authenticate users between SAP HANA Cloud, SAP HANA database and SAP Analytics Cloud: user credentials and single sign-on.

You have the option to select the instructions according to the type of authentication you wish to use.

  • Step 1

    Follow these steps:

    1. Go to your SAP Analytics Cloud tenant and login.

    2. On the homepage, click on the burger menu on the top left-hand side of the screen, then click on Connection.

    3. On the Connection page, click the plus icon to add the new data source.

    4. Expand Connect to Live Data. You can also filter your options by clicking on Cloud as your data source type.

      sac - connect to live data
    5. Click on SAP HANA.

    6. Give the connection a name and a description.

    7. Under Connection Type, select SAP HANA Cloud.

      new HANA live connection username password
    8. Go to the SAP BTP cockpit and access the SAP HANA Cloud Central to get the address of your instance’s host. Click on the three dots icon on your instance’s line, then click on Copy, and finally on SQL Endpoint.

    9. Go back to SAP Analytics Cloud and paste the URL on the host. Please make sure to remove the port number (443) and the colon symbol.

    In the next step, you can decide which authentication method to use after reading through each process.

  • Step 2

    For this step, select your preferred connection method by clicking on the options under the step title.

    Options GIF

    This step assumes that you are familiar with SAP Business Technology Platform and have a space that contains an SAP HANA Cloud, SAP HANA database instance. If you would like to become more familiar with SAP HANA Cloud and provisioning instances, check out this tutorial.

    This is the simplest method to create a live connection because you only need to use your credentials to SAP HANA Cloud, SAP HANA database within SAP Analytics Cloud.

    The SAP Analytics Cloud user must have admin privileges to add connections.

    Continue with the following steps to complete setting up SAP Analytics Cloud:

    1. Next, select Username and Password as the Authentication Method.

    2. Insert the database username and password that has access to the calculation views within SAP HANA Cloud, SAP HANA database. Please keep in mind that the database user needs to have the authentication method of password, which can be setup in SAP HANA cockpit or when the user is created.

    3. Click on OK. Your connection will be created.

  • Step 3

    Using user credentials as authentication method means that you do not have to change the setup of your SAP HANA Cloud for establishing a connection with SAC.

    You can now use SAP Analytics Cloud to create data models and stories based on the data coming from the new connection. If you are interested to know more about SAP Analytics Cloud, click here.

    If you are interested in more details of SAP HANA Cloud, you can explore other tutorials here.

    You have completed the first tutorial of this tutorial group. In the next tutorial, you will learn how to connect a Jupyter Notebook with SAP HANA Cloud and use it for data visualization.

  • Step 4

    Which of the following are pre-requisites for creating a live connection between SAP HANA Cloud and SAP Analytics Cloud?

Back to top