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
- You will see the two option like below
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
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.
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)
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
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.
