Create a Live Connection Between SAP HANA Cloud and SAP Analytics Cloud
- 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
- You have access to a production environment of SAP HANA Cloud, SAP HANA database. Else, register for a trial account of SAP HANA Cloud.
- You have access to a production environment of SAP Analytics Cloud. Else, register for a trial account of SAP Analytics Cloud.
- You have a calculation view deployed to Cloud Foundry in the SAP HANA database in SAP HANA Cloud.
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:
Go to your SAP Analytics Cloud tenant and login.
On the homepage, click on the burger menu on the top left-hand side of the screen, then click on Connection.
On the Connection page, click the plus icon to add the new data source.
Expand Connect to Live Data. You can also filter your options by clicking on Cloud as your data source type.
Click on SAP HANA.
Give the connection a name and a description.
Under Connection Type, select SAP HANA Cloud.
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.
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.
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:
Next, select Username and Password as the Authentication Method.
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.
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?