Make your data available dynamically in SAP Datasphere

Make your data available dynamically in SAP Datasphere

SAP® and SuccessFactors customers have many options for reporting and analytics. In addition, SAP has the SAP Datasphere (formerly known as Data Warehouse Cloud). This is a data and analytics solution providing the data warehouse as a service layer for SAP Business Technology Platform.

Many customers use the SAP Datasphere Cloud as a staging, clean-up or modeling system before they eventually publish their data into an analytics solution like SAP Analytics Cloud, Tableau or Microsoft PowerBI. Regardless of your strategy for reporting and analytics, Query Manager™ can serve as the engine to provide data to these disparate systems, including SAP Datasphere.

What is SAP Datasphere?

SAP Datasphere is used as a unified data and analytics solution that provides you with the ability to connect, transform, model, and visualize your data and gain real-time insights, whether it’s for analytics or for the preparation or staging of that data before it is moved to another system like SAP Analytics Cloud or the Digital Boardroom.

SAP Datasphere, available via the SAP Store, is an analytic and persona-driven data warehouse ‘as-a-service’ tailored for business and IT users. It provides instant access to data via pre-built business content and adapters to integrate data from various sources.

Connect SAP to SAP Datasphere with Query Manager

For those customers who would like to share their SAP ECC On-Premise or SAP SuccessFactors hybrid data dynamically with SAP Datasphere, we have a solution. You’re probably already familiar with the SAP certified solution, Query Manager. As the most popular reporting solution for SAP HCM and Payroll customers, Query Manager provides accurate, meaningful and real-time information from all of your SAP HCM and Payroll data whether you are on-premises in SAP ECC, in a hybrid SAP SuccessFactors environment or with SAP SuccessFactors Employee Central Payroll. And the exciting news is that Query Manager also serves as an engine for feeding all this data including configuration, custom tables, time and Payroll, with any external system with OData integration. This includes SAP Datasphere.

It’s easy to set up and use

1. Query Manager extracts the relevant data for you (whether it be Payroll or PA, OM etc) without replicating the data, even for a sizeable volume.

2. You can build the queries, without writing code, without staging the data, in another system.

3. Query Manager generates a web service that exposes that data as an OData service that you can then consume via SAP Datasphere.

You can also combine on-premise data with other data sources including SuccessFactors that come from other parts of your ecosystem.

In the sample below, you can see the Query Manager data source listed in SAP Datasphere (formerly Data Warehouse Cloud).

From the Data Builder, I can work with the various data sources, combining them, making relationships between them etc. to produce the data I am interested in, see below.

I can then expose this data as analytics in a dashboard, see below, or make it available to other systems for consumption including SAP Analytics Cloud. In the sample below, you can see a sample published story in SAP Datasphere populated with dynamic data from an SAP HCM and Payroll system.

What’s ideal is that you can easily refresh the data within SAP Datasphere, on demand, to retrieve the latest available data to you (no more uploading and downloading).

Learn more about the SAP-certified Query Manager including the Query Manager Analytics Connector.