Consuming Data Exposed by SAP Datasphere

All users with any of the standard roles can consume data exposed by spaces they are assigned to. If a user does not need to access SAP Datasphere itself, and only wants to consume data exposed by it, they should be granted a consumer role.

This topic contains the following sections:

Expose Data from SAP Datasphere

Data can be exposed as analytic models, perspectives, and views, which are accessible to clients, tools, and apps as follows:

Object	SAP Analytics Cloud	Microsoft Excel	Other Clients, Tools, and Apps
Analytic models (see Creating an Analytic Model) Exposed: Automatically	Live Connection	Live Connection (via an SAP Add-In)	OData
Perspectives (see Define Perspectives) Exposed: Automatically	Live Connection	Live Connection (via an SAP Add-In)	-
Views* (see Exposing Data For Consumption) Exposed: When the Expose for Consumption switch is enabled	OData**	-	OData ODBC/JDBC
For more information, see:	Consume Data in SAP Analytics Cloud via a Live Connection Integrate with SAP Analytics Cloud for Planning	Consume Data in Microsoft Excel via an SAP Add-In	Consume Data in Power BI and Other Clients, Tools, and Apps via an OData Service Consume Data in Power BI and Other Clients, Tools, and Apps via ODBC/JDBC

* The workflow of consuming views with a semantic usage of Analytical Dataset in SAP Analytics Cloud and Microsoft Excel via live connection is now deprecated. We recommend that you migrate your analytical datasets to the new Fact semantic usage and expose your view data via analytic models (see Analytical Datasets (Deprecated)).

** SAP Analytics Cloud primarily uses the consumption of view data via OData for planning (see Integrate with SAP Analytics Cloud for Planning).

Consume Data in SAP Analytics Cloud

You can create a live connection from SAP Analytics Cloud to SAP Datasphere and consume data exposed as analytic models and perspectives to create stories and analytic applications.

For more information, see Consume Data in SAP Analytics Cloud via a Live Connection.

Integrate with SAP Analytics Cloud for Planning

You can use SAP Datasphere as a data source for loading actuals or external data into an SAP Analytics Cloud planning model. You can also load your SAP Analytics Cloud planning data into SAP Datasphere and combine it with live actuals or other data as appropriate.

For more information, see Integrate with SAP Analytics Cloud for Planning.

Consume Data in Microsoft Excel

You can create a live connection from SAP Analytics Cloud to SAP Datasphere and consume data exposed as analytic models and perspectives in Microsoft Excel, via the SAP Analytics Cloud, add-in for Microsoft Excel.

For more information, see Consume Data in Microsoft Excel via an SAP Add-In.

Consume Data via ODBC/JDBC

You can consume data exposed from SAP Datasphere in clients, tools, and apps via a database user/Open SQL schema.

See Consume Data in Power BI and Other Clients, Tools, and Apps via ODBC/JDBC.

Consume Data via an OData Service

You can connect to the OData API and consume data exposed as views or analytic models in SAP Analytics Cloud and other clients, tools, and apps that are capable of accessing an OData service and authenticating via an OAuth client.

For more information, see Consume Data in Power BI and Other Clients, Tools, and Apps via an OData Service and Consuming Data via the OData API.