Skip to Content

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

test
0 %
Create a Live Connection Between SAP HANA Cloud and SAP Analytics Cloud
Details

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
QR code

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: Set up live connection in SAP Analytics Cloud

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.

Log on to answer question
Step 2: Select authentication method

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.

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.

Prerequisites

  • SAP HANA Cloud, SAP HANA database admin privileges (DBADMIN user)
  • SAP Business Technology Platform Admin & Security Admin privileges
  • SAP Business Technology Platform Org, Subaccount, Space, & SAP HANA Cloud, SAP HANA database instance running
  • An HDI container with a calculation view deployed to Cloud Foundry
  • SAP Analytics Cloud admin privileges

With the single sign-on authentication method, you have to setup the single sign-on in SAP HANA Cloud, SAP HANA database while you set up the live connection in 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 SAML Single Sign On as the Authentication Method.

    sac - new HANA live connection SAML
  2. Click on the copy icon next to the provider name to copy this address, as you will need it soon.

  3. Now click on Download Signing Certificate. This will download the certificate on your local machine.

  4. Keep SAP Analytics Cloud open and do not click on OK to create the connection yet. Leave it as is for the moment.

Log on to answer question
Step 3: Set up SAP HANA Cloud, SAP HANA database to connect

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.

For now, we will switch to the SAP HANA cockpit, as you need to setup the single sign-on on the SAP HANA Cloud side. Please follow the steps below:

  1. Open the SAP HANA cockpit you use with your SAP HANA Cloud, SAP HANA database instance. Go to the SAP BTP cockpit and, on your instance tile, click on Open in SAP HANA cockpit. Under Security and User Management, click on Certificate Store.

    HANA cockpit - certificate store
  2. Click on Import.

    HANA cockpit - certificate store detail

  3. Browse to the certificate file you downloaded from SAP Analytics Cloud and import it. You will see the certificate appear on this list once the import is completed. Now go to the SAML Identity Providers area.

    HANA cockpit - SAML identity providers
  4. Click on Add Identity Provider.

    HANA cockpit - add identity provider
  5. Enter the Identity Provider Name. Under the Entity ID, please paste the provide name that you copied previously from SAP Analytics Cloud. On the bottom of the pop-up, select the certificate you uploaded previously. Click on Add. Your identity provider will be created.

  6. Now go to the Certificate Collections in SAP HANA cockpit.

    HANA cockpit - certificate collections
  7. Click on Add Collection.

    HANA cockpit - add collection
  8. Add a name and click on OK. Then click on Add certificate. Click on the checkbox next to the correct certificate and click on OK.

  9. Now click on the Edit Purpose on the top right-hand corner of the screen. Under Purpose, select SAML.

    HANA cockpit - add collection edit purpose

  10. Under Providers, select the Identity Provider you recently created. Click on Save. Click on Yes when you are prompted to confirm the change of purpose.

  11. Next you need to create a database user that is mapped to the SAP Analytics Cloud user creating the connection. Go to User Management.

    HANA cockpit - user management
  12. On the left-hand panel, click on the plus icon to create a new user. Then click on Create User. Fill out the user creation form and make sure that you include the user email, which must exactly match the email of the user logged into SAP Analytics Cloud.

  13. Make sure as well to select SAML as the Authentication Mechanism. Click on Add SAML Identity. Select the Identity Provider you previously created and keep the automatic mapping by provider OFF.

  14. Under External Identity, fill out the user’s email.

    HANA cockpit - create user SAML
  15. Click on Save. Now click on Assign Roles. Make sure the user has the correct privileges to access your calculation views on SAP HANA Cloud.

You are done with the changes in SAP HANA cockpit.

Back to SAP Analytics Cloud

Now go back to SAP Analytics Cloud and click OK on screen to create your connection.

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.

Log on to answer question
Step 4: Test yourself
Which of the following are pre-requisites for creating a live connection between SAP HANA Cloud and SAP Analytics Cloud?
×

Next Steps

Back to top