TrustRadius: an HG Insights company

SAP Datasphere

Score8.3 out of 10

237 Reviews and Ratings

What is SAP Datasphere?

SAP Datasphere, the next generation of SAP Data Warehouse Cloud, is a comprehensive data service that enables data professionals to deliver seamless and scalable access to mission-critical business data. It provides a unified experience for data integration, data cataloging, semantic modeling, data warehousing, data federation, and data virtualization. SAP Datasphere enables users to distribute mission-critical business data — with business context and logic preserved — across the data landscape.

Categories & Use Cases

Swap SAP Datasphere good to use

Use Cases and Deployment Scope

We use for sharing data from swap to non SAP

Pros

  • Sharing the data
  • Extraction
  • Modeling

Cons

  • Modeling
  • Semantic
  • Variable and filter

Return on Investment

  • Easy to use
  • Graphical modeling
  • SQL modeling

Alternatives Considered

SAP Analytics Cloud

Enterprise-Wide Reporting and Analysis Platform SAP BW Replacement

Use Cases and Deployment Scope

Strategic replacement for SAP BW, aimed at enabling enterprise-wide reporting and analytical capabilities. The platform supports core functionalities such as data modeling, orchestration of data loads, and centralized governance. Particularly useful when the main source is SAP S/4.

As the solution is still relatively new within SAP’s product portfolio, the central enterprise team is currently focused on building foundational expertise and operational stability. Once the team has gained sufficient familiarity and confidence with the platform, we plan to introduce dedicated line-of-business spaces.

Pros

  • Integration to SAP S/4 CDS views.
  • Modeling towards reporting in SAP Analytics Cloud.
  • Control of agile development via the lineage functionality.

Cons

  • Support for 3rd party front ends like Power BI is lacking, open SQL on HANA cloud is not an ideal workaround because of user maintenance/RLS.
  • Data Flow functionality and UI is neglected but still necessary as the new flow types do not support all source types.

Return on Investment

  • Pricepoint is reasonable and easier to get started with than traditional SAP offerings.
  • However, the change that makes BTP credits unusable in the Business Data Cloud has been detrimental to the trust in the SAP license model.

Usability

Alternatives Considered

Microsoft Fabric and SAP BW/4HANA

Other Software Used

Microsoft Fabric, Azure Data Factory, SAP Business Warehouse, SAP HANA Cloud

Review SAP Datasphere

Use Cases and Deployment Scope

We are using it as data warehouse for business reporting. Building the business logic into SAP Datasphere and provide those models to SAC for building SAC stories. Business problems: Merging several data sources from different systems into one harmonized layer. Blending related data together. Calculating complex metrics and KPIs. And this complex logic to make better performance doing persisting to make Stories run fast.

Pros

  • Graphical Views are easy to work
  • Have SQL View possibilities for complex logic, where Graphical Views cant do
  • Have possibility to connect different sources via connectors

Cons

  • Task chain managing: skipping step, when it is failing, retry functionality, starting task chain from the specific step. Adding pause step to wait several seconds to run
  • Graphical views - can't do joins using condition "between" or ">"

Return on Investment

  • Negative impact, that is cloud solution and if something is not working, we need to wait for SAP support will do something.
  • Also negative impact is upgrade and maintenance, which is causing issues time to time

Usability

Alternatives Considered

Tableau Desktop, MicroStrategy Analytics and Qlik Analytics Platform

Other Software Used

Tableau Desktop, Qlik Analytics Platform, MicroStrategy Analytics

Dataflows can use python scripts in SAP Datasphere

Use Cases and Deployment Scope

A business analytics warehouse tool helping us with blending SAP and non-SAP datasets very seamlessly. In business front when there are lot processes involved with no SAP data earlier, we did have a lot of issues on integrating non-SAP data for business analysis. Now with the space concept we enhance further the dataset as per requirement or analysis needed

Pros

  • integrations
  • sql views
  • data access controls
  • dataflows can use python scripts

Cons

  • BW level transformation capabilities
  • direct API integrations
  • BADIs

Return on Investment

  • time saver
  • better for automations
  • business semantics are useful

Usability

Alternatives Considered

SAP Ariba, SAP Analytics Cloud, SAP HANA Cloud, Snowflake and Azure Databricks

Other Software Used

Snowflake, Azure Databricks, SAP Analytics Cloud, SAP HANA Cloud

SAP Datasphere Review

Use Cases and Deployment Scope

SAP Datasphere is quickly becoming our "one source of truth" data warehouse solution. We're in the process of a full implementation now, so we are bringing in data from both SAP and non-SAP sources, combining them in data flows and then ultimately modelling them into something consumable using SAC or dashboarding software like Tableau.

Pros

  • Replication Flows - getting data from SAP.
  • Modelling - you can choose to do it graphically or using code like SQL
  • Speed of Data Access - we find it very fast compared to other tools we've used, thanks to utilizing CDS views.

Cons

  • There's a bit of a learning curve and I find it hard to trace where all the data is coming from. You can see the lineage, but everything seems to require a lot of "layers" ie. a Data Flow, a Replication Flow, a View, an Analytic Model etc.
  • Using CDS views is less straightforward than the SAP tables, but I think necessary if you want to save on space / increase speed. I look forward to the prepackaged "Data Products" that SAP has said are coming.
  • For end-users of Datasphere, SAP Analytics Cloud is the recommended route but it's not nearly as user-friendly as other tools, so you'll either have to deal with that or do extra work on the Datasphere side to allow your models to be exposed to tools outside of SAP.

Return on Investment

  • Remains to be seen for us but we're excited for all the work that SAP is putting into BDC and having Datasphere as our foundation for AI in the future.
  • It has strengthened our relationship with SAP, and more seems possible to tap into now.
  • Implementing in phases has made the cost more digestible.

Usability

Alternatives Considered

Microsoft Fabric, SAP BW/4HANA, SAP S/4HANA Cloud and SAP HANA Cloud

Other Software Used

Tableau Prep, Tableau Desktop, SAP S/4HANA Cloud, SAP Analytics Cloud, Microsoft Copilot