Dremio vs SAP Analytics Cloud comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Dremio
Average Rating
8.6
Number of Reviews
6
Ranking in other categories
Cloud Data Warehouse (11th), Data Science Platforms (10th)
SAP Analytics Cloud
Average Rating
8.0
Number of Reviews
62
Ranking in other categories
BI (Business Intelligence) Tools (3rd), Predictive Analytics (2nd)
 

Mindshare comparison

As of June 2024, in the Data Science Platforms category, the mindshare of Dremio is 5.8%, up from 2.3% compared to the previous year. The mindshare of SAP Analytics Cloud is 0.2%, down from 0.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Science Platforms
Unique Categories:
Cloud Data Warehouse
2.8%
BI (Business Intelligence) Tools
6.8%
Predictive Analytics
11.7%
 

Featured Reviews

AM
Jan 16, 2024
A highly stable solution that works like a data warehouse on top of data lakes
Dremio's interface is good, but it has a few limitations. I cannot do a lot of things with ANSI SQL or basic SQL. I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported. The use case I am working on requires building trees and hierarchical structures. Most of the time, it requires complex nested data structures to be made simpler for end users. It would be good if Dremio could provide a way to create trees just like Oracle does using commands like CONNECT BY and NO CYCLE. You can use a few languages to simplify complicated JSON and XML. It would be very helpful if Dremio could provide a solution to simplify building trees and building meaningful data from complex data.
AnilKumar43 - PeerSpot reviewer
Jun 4, 2024
Offers analytics, planning, and predictive capabilities in a single, cloud-based solution but requires more specialized skills for integration and setup
I'm an SAP consultant. It's primarily used for analytics on top of SAP data sources. It provides live reporting on SAP S/4HANA, the ERP platform. It has real-time connectivity with S/4HANA SAP Analytics Cloud excels in predictive analytics, particularly when dealing with SAP data sources.  For…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Dremio gives you the ability to create services which do not require additional resources and sterilization."
"Dremio allows querying the files I have on my block storage or object storage."
"The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory."
"Everyone uses Dremio in my company; some use it only for the analytics function."
"We primarily use Dremio to create a data framework and a data queue."
"Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it."
"It's easy to connect Analytics Cloud with other SAP solutions, and it's also effortless to deploy. You don't need much technical skill to set it up. It's as easy as setting up a tablet. I said tablet before. It's very easy to actually set up."
"The most valuable feature of SAP Analytics Cloud is its integration with SAP."
"The solution is quite effective for collaborative planning."
"The features that are most valuable in SAP Analytics Cloud are the planning feature and the predictive analytics feature, though the planning feature needs to be more efficient."
"The Smart Predict, Smart Insights, and Smart Discovery predictive analysis features are quite good."
"I would recommend this solution for companies that are SAP dependent with users working in this environment."
"There is a really nice insight feature that I enjoy using."
"The stories have really been helpful in looking at specific scenarios and analyzing trends over periods of time."
 

Cons

"Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement."
"We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily."
"I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."
"It shows errors sometimes."
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake."
"They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people."
"The scope is limited to a few accounts."
"Its integration or connectivity with non-SAP systems, big data, and social media, such as YouTube, LinkedIn, et cetera, can be improved. This is where SAP has limited features as compared to other solutions."
"Sometimes there are speed issues with big deletion data."
"I think it would be easier if there was another module created to retrieve only data."
"The integration with other vendors and solutions could be improved."
"Currently only one data modeler can work at a time."
"They need more support for more languages, Python for example."
"The customizations need to be better."
 

Pricing and Cost Advice

"Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
"Dremio is less costly competitively to Snowflake or any other tool."
"The tool's pricing is medium, and licensing costs are yearly."
"Its licensing is on a monthly basis."
"It is a bit expensive, but really worth it, especially if you are already using other SAP tools."
"It's quite expensive and costs a lot to maintain, especially with licensing."
"The pricing of this product is reasonable."
"This solution is pricey."
"The pricing is based on an annual license and is rated a four out of ten."
"It is not the most expensive one. You have to do the cost-of-ownership analysis and take a lot of things into consideration to come up with the conclusion that it is cheaper or not, but its price is reasonable. It provides value for money."
report
Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
789,135 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
30%
Computer Software Company
11%
Manufacturing Company
8%
Retailer
4%
Educational Organization
20%
Manufacturing Company
12%
Computer Software Company
10%
Financial Services Firm
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Dremio?
Dremio allows querying the files I have on my block storage or object storage.
What is your experience regarding pricing and costs for Dremio?
Every tool has a value based on its visualization, and the pricing is worth its value.
What needs improvement with Dremio?
Dremio's interface is good, but it has a few limitations. I cannot do a lot of things with ANSI SQL or basic SQL. I cannot use the recursive common table expression (CTE) in Dremio because the supp...
Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies ...
What do you like most about SAP Analytics Cloud?
In the data warehouse, you're free to make changes. You can make everything text, meaning it's always a string. Even numbers appear as text, giving you the flexibility to work with all columns.
What is your experience regarding pricing and costs for SAP Analytics Cloud?
SAP pricing tends to be premium, so it is slightly higher. However, in this case, the premium charges are justifiable because it comes with out-of-the-box connectors and adapters and can still comm...
 

Also Known As

No data available
SAP BusinessObjects Cloud
 

Learn More

Video not available
 

Overview

 

Sample Customers

UBS, TransUnion, Quantium, Daimler, OVH
Live Oak Bank
Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: May 2024.
789,135 professionals have used our research since 2012.