Part 4 - Uniting SAP Datasphere with SAP Analytics Cloud for Data Harmony - Revolutionize Your Data Strategy

Introduction

Welcome to the fourth segment of this three-part series.

In Part 1, Part 2 & Part 3 of this blog series we discussed

Understanding SAP Analytics Cloud (SAC)
Exploring the advantages of SAC compared to other reporting tools.
Elevating your data connection experience - guidance on setting up the data connection for optimal functionality.
Embrace the future with Optimized Design Experience (ODE)
Creating a live connection between Datasphere and SAC

There are 2 possible ways to integrate Datasphere with SAC for Planning Purposes:

Sending data from Datasphere to SAC via OData Service
Sending data from SAC to Datasphere via CDI Connection (Cloud Data Integration)

In this blog, I want to highlight the steps to create an OData Service Connection to send data from Datasphere to SAC. By integrating Datasphere Actuals into SAC, we lay the foundation for strategic decision-making, driving business growth and agility.

Sending Data from Datasphere to SAC via OData Service

Our goal for this task is to consume actuals from Datasphere into SAC for reporting and planning purposes. We will combine the actuals from Datasphere with planning data in SAC.

The following is a list of steps to import Datasphere actual data into SAC:

1. Identify the OData Source (Data Service URL) in Datasphere

Firstly, we need to identify the Data Service URL. We went to the following link below. Within this URL, you can see all the assets available within the spaces available in your Datasphere tenant.

Within this URL, we copied the assetRelationDataURL for the dataset we required. This is your Data Service URL. We then looked up our chosen assetRelationDataURL using the URL below. This will get us the meta data from the OData Service.

To view the data from your chosen asset, add the dataset name again at the end of the URL.

2. Lookup your redirect URI in SAC

The redirect URI in SAC is the specific endpoint URL. The URI is the destination to which the authentication server redirects the user's browser after authentication has been successfully completed.

We added an OData Services connection in our SAC tenant. We then change the Authentication Type to OAuth 2.0 Authorization Code. At the bottom of this window, we can see the Redirect URI.

3. Create the OAuth Client in Datasphere

We now want to create an OAuth client in Datasphere. We need the Redirect URI from the above step to create the OAuth client. We do this by going to System >> Administration >> App Integration and click on the ‘Add a New OAuth Client’. Once you paste the Redirect URI and click Add, you’ll get a list of the following information which you will need to take a note of.

OAuth Client ID
Secret
Authorization URL
Token URL

4. Create OData Connection in SAC

Within SAC, we go to Connections >> Add a Connection and chose OData Service. You need to now add the following connection parameters:

Data Service URL = assetRelationalDataUrl
OAuth Client ID
Secret
Token URL
Authorisation URL

Import from OData Connection

We now need to create a model in SAC. We chose OData Services as the data source and click the new connection we just made. We then create a new query and select which dimensions and measures you want when building that query.

You can see that we have now consumed actuals data from datasphere into SAC! At this stage you can clean data and fix any issues. You have successfully imported the actuals data from OData Connection!!

5. Create Story and Test

As you can see here, we created a story. We added a table to our story. We chose the query we created above as the data source for the table. We added ‘Category’ as a column and using the version management functionality we can choose both the Actual and Plan category. This shows Actual data from Datasphere and Plan data within SAC.

To recap, we have successfully sent Actual data from Datasphere to SAC via OData Service. To do this we identified the data service URL in Datasphere. Using this and other information we created an OAuth Client. We then completed the cycle by creating the OData Connection in SAC. Once we have successfully created the OData connection, we created a story and tested to see the Actual data from Datasphere in SAC.

If you or your colleagues have further questions or queries and would like to understand more about Datasphere and SAP Analytics Cloud, please feel free to contact us at gemma.regan@seaparkconsultancy.com.

Want to witness the magic firsthand? Live Demo Appointments can be arranged upon request allowing you to explore the incredible capabilities of SAP Datasphere and SAP Analytics Cloud.