Home » SAP Analytics Cloud » SAP Analytics Cloud Live connection

SAP Analytics Cloud Live connection

Introduction:

In SAP analytics cloud live connection, you can easily connect your analytics cloud with live system like SAP HANA, SAP BW, Salesforce, Microsoft SQL etc. In SAP analytics cloud you will see below two option to import you data, However in this article we will see the steps and important points about SAP analytics cloud live connection only.

Data is “live”, meaning that when a user opens a story in SAP Analytics Cloud, changes made to the data in the source system are reflected immediately.

From CSV or Excel file

In this option is to import excel data from excel/flat file without live connection to the data source, in this case every month you need to update data in excel file.

From a Data source

This option is only use if you would like to have live connection with your dataset, like SAP HANA, SAP BW, Salesforce, Microsoft SQL etc. so you don’t need to update backend data every month and end user will see updated data in stories and visualization direct from data source.

SAP analytics cloud Live Connection Steps

Step 1:

  • Click on Menu option then more option and then Dataset

import data

  • You will see the two option like below

import data option

Step 2:

  • Select “From s Data Source” option
  • Select the data source you would like to connect
  • In this example we are connecting with SAP HANA as shown below image

SAP analytics cloud live connection

Steps 3:

  • Below window will appear as show in image
  • In the dialog, enter a name and description for your connection.
  • The connection name cannot be changed later.

SAP analytics cloud live connection

Step 4:

  • Then after connection you need to select the location/folder where you want to save the data set, You can also create your own folder. (with option as marked with green box)

SAP analytics cloud import excel

Step 5:

  • And finally you will see imported dataset as shown below image
  • you will also se the dataset overview tab on right side and save option on file menu, click on save option to double check it is saved

SAP analytics cloud import excel

See your saved dataset 

If you want to see SAP analytics cloud saved data then You need to go Menu again of left side of your analytics cloud  home page

click on Files > My Files and you will se dataset as marked in red box in below image. all your uploaded and saved dataset can see in this path and location.