Export Data with the Data Export Service Open API

The Data Export Service is an open API that allows you to retrieve data from SAP Analytics Cloud.

The service offers a PULL based API data extraction API that helps with data integration from SAP Analytics Cloud to SAP Data Warehouse Cloud, SAP BW, SAP HANA, and other third-party tools. The API doesn't have a dedicated user-interface, and simply extracts data and information about providers. A provider corresponds to a planning model within a particular SAP Analytics Cloud system.

The API is comprised of two services: the Administration service and the Provider service.The first extracts list of models on your SAP Analytics Cloud system, and the second one retrieves information about a specific planning model. The API supports all standard OData parameters, as well as custom parameters.

Both services offer multiple endpoints to extract both metadata and underlying data.

The Data Export Service supports two OAuth authentication flows:
  • Two-Legged OAuth that allows administrators to access and export all data from any given models in machine-to-machine scenarios for example.
  • Three-Legged OAuth that allows business users to export smaller subsets of data while leveraging roles and data access privileges to ensure that they can only access data they have privileges for, at a model level.
Restriction
The Data Export Service is only available for SAP Analytics Cloud systems hosted on non-SAP data centers.
If you're unsure about your system, check the URL of your SAP Analytics Cloud tenant:
  • A single-digit number, for example us1 or jp1, indicates an SAP data center.
  • A two-digit number, for example eu10 or us30, indicates a non-SAP data center.

Make sure to visit the SAP API Business HubInformation published on SAP site to access the API specification and try out the functionality.