Using the SAC Data Export API with Data Warehouse Cloud and Data Intelligence

In this blog post I will show how we can configure the SAP Analytics Cloud (SAC) Data Export API to access SAC planning data and integrate it with Data Warehouse Cloud (DWC) and SAP Data Intelligence (DI).

The API provides OData and Cloud Data Integration (CDI) access for great integration with DWC and DI. CDI is a superset of OData, therefore when available it is better to use CDI.

At the time of writing the SAC Data Export API is in controlled release, see the SAC Roadmap Explorer for the latest updates. The Export API is planned to be made generally available during Q2 2022.

Details of the SAC Data Export API are covered in the SAC help documentation.

The steps to be covered in this blog post are the technical setup of the integration.

  1. SAP Analytics Cloud Configuration
  2. Postman
  3. Data Warehouse Cloud
  4. Data Intelligence

1. SAP Analytics Cloud Configuration

To use the SAC Data Export API you require 3 parameters, I refer to these numbers further in the blog post.

  1. Token URL
  2. OAuth Client ID
  3. Secret

In SAC navigate to System -> Administration -> App Integration

Here you will see your OAuth Clients and Token URL.

Add a New OAuth Client, when the Data Export API is enabled/released you will see the Data Export Service as an Access Type as below.

Figure%201%3A%20Access%20-%20Data%20Export%20Service

Figure 1.1: Access – Data Export Service

Create a New OAuth Client, similar to that below.

Figure%201%3A

Figure 1.2: New OAuth Client

With these 3 parameters we can access the Data Export API with either Postman, Data Warehouse Cloud, SAP Data Intelligence.

2. Postman

We can test the API with postman to verify it’s working as expected.

First we need to Authenticate using the OAuth Client details created above.

Figure%202.1%3A%20Postman%20Authentication

Figure 2.1: Postman Authentication

All being well we can click “Get New Access Token”, which will let us use the API.

Figure%202.2%3A%20Postman%20Sucess

Figure 2.2: Postman Authentication Success

Figure%202.3%3A%20Use%20Token

Figure 2.3: Use Token

Click Use Token and we can use that token to call the actual API

https://my-sac-tenanant.eu10.hcs.cloud.sap/api/v1/dataexport/administration/Namespaces(NamespaceID='sac')

Figure%202.4%3A%20Postman%20API%20Call%20-%20NameSpaces

Figure 2.4: Postman API Call – NameSpaces

Above, we can see the API is working and returning metadata as requested

3. SAP Data Warehouse Cloud

Switching to DWC we can add a new connection of type Cloud Data Integration (CDI).

Figure%203.1%3A%20Cloud%20Data%20Integration

Figure 3.1: Cloud Data Integration

In Data Warehouse Cloud the URL format would be the following.

https://my-sac-tenant.eu10.sapanalytics.cloud/api/v1/dataexport/administration

Figure%203.2%3A%20CDI%20Connection%20Details

Figure 3.2: CDI Connection Details

To use remote tables with the CDI Connection a Data Provisioning Agent is required.

Figure%203.3%3A%20CDI%20Connection%20Details%20Continued

Figure 3.3: CDI Connection Details Continued

Figure%203.3%3A%20Validate%20Connection

Figure 3.3: Validate Connection

Figure%203.4%3A%20Data%20Builder%20-%20Import%20Tables

Figure 3.4: Data Builder – Import Tables

Figure%203.5%3A%20Import%20Tables%20-%20Select%20Connection

Figure 3.5: Import Tables – Select Connection

We can now see namespace (sac) and the planning models, some of which have a GUID others have a description.

Figure%203.6%3A%20Select%20Required%20model%20and%20Tables

Figure 3.6: Select Required Planning Model and Tables

We are now able to use the remote tables for modeling with either remote access (federation) or replicate as a snapshot into DWC.

4. SAP Data Intelligence

In SAP Data Intelligence we can create a new connection of type CLOUD_DATA_INTEGRATION. Use the three configuration parameters as below and paste in your details from SAC, obtained in step 1.

The Service Path should be

/api/v1/dataexport/administration

Figure%204.1%3A%20SAP%20Data%20Intelligence%20-%20Cloud%20Data%20Integration%20Connection

Figure 4.1: SAP Data Intelligence – Cloud Data Integration Connection

Switching to the Data Intelligence Modeler perspective

Figure%204.2%3A%20Modeler%20-%20Generation%202%20-%20SAP%20Application%20Consumer

Figure 4.2: Modeler – Generation 2 – SAP Application Consumer

We can then browse the SAC Planning Models, via the namespace (sac) and then the provider, some of which have a description others have a GUID.

Figure%204.3%3A%20SAP%20Application%20Consumer

Figure 4.3: SAP Application Consumer – Browse Objects

5. Conclusion

In this blog post you can see that we can access SAC Planning data using the SAP Cloud Data Integration within Data Warehouse Cloud and SAP Data Intelligence.