Dremio vs SAP BusinessObjects Business Intelligence Platform comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,683 views|2,043 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and SAP BusinessObjects Business Intelligence Platform based on real PeerSpot user reviews.

Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms.
To learn more, read our detailed Data Science Platforms Report (Updated: April 2024).
769,662 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Dremio allows querying the files I have on my block storage or object storage.""We primarily use Dremio to create a data framework and a data queue.""Dremio gives you the ability to create services which do not require additional resources and sterilization.""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.""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."

More Dremio Pros →

"We find that we can scale it as needed.""The most valuable feature we have found to be the SAP BW, which is a warehouse tool. Additionally, it is an easy tool to use.""​Provides autonomy for all the business users to develop their own reports.​""Enables us to present data with Smart Objects that can be embedded within presentations and which automatically update when the presentations are run.""The features which the solution has been awesome. The way the data is fetched from the database, and the queries are executed, is unique using the Universe of Business Objects. That makes it unique and we could not find another solution that functions in a similar way. It's has a great way of receiving and executing queries.""It provides flexibility for creating reports. It is very good for creating highly-complex reports. I like this solution because when I buy BusinessObjects, it comes with many components, such as reporting, dashboard, and data visualization tools. Its performance is good. It is running on top of SAP BW and SAP HANA.""Reporting from SAP Business Objects Web Intelligence is amazing, and gives users the ability to quickly access data from existing universes and/or relevant data sources, without the need to involve a functional business analyst or financial analyst.""The reports are most valuable. If it is a single-source universe, based on only one database, the performance, and the reporting tool is user-friendly, and users are very familiar with the tool and are comfortable using it."

More SAP BusinessObjects Business Intelligence Platform Pros →

Cons
"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.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""It shows errors sometimes.""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.""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.""I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."

More Dremio Cons →

"They could reduce the licensing expenses. There is nothing really wrong with the product in terms of what it does. It works well. If you are a part of BI Launch Pad, then you could run ad hoc reporting, but for the integration, you need access to BI Launch Pad, which is quite expensive. We're an organization with 18,000 employees. It is not really practical to give people access to BI Launch Pad. So, from a customer perspective, in terms of saturating our employee base, we don't really have great saturation because of the expense.""I don't like the fact that I have to use two tools. Web Intelligence is good for reporting and all kinds of stuff, but I would rather have one product. All the reporting features of Web Intelligence should be developed within Lumira. A lot of predictive abilities have been brought into the cloud version of SAP Analytics. It would be nice to see a lot of newer technologies and AI. Predictive capabilities are becoming a little more standard. Instead of having to get another model, we are just looking for one solution to deal with analytics including predictive.""The SAP BusinessObjects Business Intelligence Platform has always struggled with dashboarding.""Over the years, the product tends to rename and rebrand itself and change its direction. This is a deficit of the solution.""The calculation engine requires some improvement.""The financial area in the solution has certain shortcomings that need improvement.""The UI could be updated a bit.""The solution could be less expensive. It's a bit pricey now."

More SAP BusinessObjects Business Intelligence Platform Cons →

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."
  • More Dremio Pricing and Cost Advice →

  • "Just work with SAP to make sure you have enough licenses but don't go overboard."
  • "​It is not an expensive platform. The licensing is for a package of users starting at 10 users."
  • "It has an option of a Cloud Platform (SAP Analytics Cloud) which has a lower price than the on-premise platform, and you can buy individual licences per user.​"
  • "Depending on your size, try to stick with SAP BusinessObjects BI Edge. Most people tend to overthink the licensing. Remember that one concurrent user means that one person can be performing a task at a given time. That does not mean that only one user can be on the system at a time, it means that only one person can be refreshing a report or designing a dashboard. There are tons of ways you can access your data or reports without consuming a license. I've seen cases where five concurrent licenses support thousands of users."
  • "There's no additional charge for a Development environment license, so build an additional development server."
  • "Its price is fair."
  • "It is not cost-effective. It is expensive."
  • "I have always found SAP BI to be expensive. It is expensive even when you compare SAP BI Cloud with Microsoft Power BI. Power BI is probably around $9.99 per month, and the cheapest SAP BI is around $20, which is double. In terms of price, Power BI is definitely a lot better. If you have budget issues, you may want to go for Power BI."
  • More SAP BusinessObjects Business Intelligence Platform Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    769,662 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    A quick look at the whole idea on another weblogs gives you a sense that all of them just talked about very brief things like report refresh feature in BO or cube feature in MS Analysis Service. I choose MS BI and I want to share my reasons and opinions on why I choose it and give you another quick but a little deeper compare on these two BI platforms. As we all know both Business Objects and Microsoft are big companies who are working on BI solutions and both have their own advantages. It’s not true to compare them in term of which one is better, we have to check what is our requirements and then depend on requirements take the decision whether MS or BO. A vision like this could help us relief from religious decisions against a software or technology. In a BI architect first of all we have the data store level, I mean the storage of the raw data not the stage or olap cubes or universe data source, I mean the first place of our data. This is important to know that where your raw data is and what is the type of storage used to store them. Whether file system or Access or Fox database or a complex database solution like oracle, sqlserver or a web service can made our place of raw data. We have to check our tools against them; check to see which one gives us a smooth way to transfer them among ETL process to destination. So take a look at what Business Objects gives us. There is a Data Integration platform in Business objects but the problem is that you have to buy that… Read more →
    Questions from the Community
    Top Answer:Dremio allows querying the files I have on my block storage or object storage.
    Top Answer:Every tool has a value based on its visualization, and the pricing is worth its value.
    Top Answer: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… more »
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it… more »
    Top Answer:What I like the most about SAP BusinessObjects BI Platform is that it has significantly improved our decision-making process.
    Ranking
    9th
    Views
    2,683
    Comparisons
    2,043
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Views
    8,659
    Comparisons
    6,737
    Reviews
    15
    Average Words per Review
    562
    Rating
    7.9
    Comparisons
    Also Known As
    SAP BusinessObjects BI Platform, SAP BusinessObjects, Business Objects
    Learn More
    Dremio
    Video Not Available
    Overview

    Dremio is a data lake query engine tool that creates PDSs and VDSs on top of S3 buckets. It is used for managing simple ad-hoc queries and as a greater layer for ad-hoc queries. The most valuable features of Dremio include its ability to sit on top of any data storage, generate refresh reflections and create visuals, manage changes effectively through data lineage and data providence capabilities, use open-source, and address the problem of data transfer when working with large datasets. The use cases are broad, allowing for high-performance queries from a data lake.

    SAP BusinessObjects Business Intelligence Platform is a versatile and flexible solution for reporting and dashboards, focusing on analytics and ad hoc reporting. It can be deployed on-premise or in the cloud. The solution includes tools such as Web Intelligence, Crystal Reports, SAP Lumira, and Analytical Cloud and is primarily used for comprehensive business intelligence reporting.

    The most valuable features include excellent reporting features, good technical support, scalability, and the ability to translate database data into business language. The solution has helped organizations by providing analytics, monitoring KPIs, and making important decisions as a financial business.

    SAP BusinessObjects Business Intelligence Key Features

    • Central management: Access all your BI from a single, central launchpad that can be customized to meet user-specific needs. The launchpad provides business users with access to all their BI tools, reports, notifications, and applications in a single place. This includes the ability to launch SAP Analytics Cloud.

    • Data visualization and analytics: Create powerful visualizations, dashboards, and applications to assess risk, improve efficiency, identify opportunities, and enable users to analyze developments and data. Business insights can be shared with colleagues across enterprises.

    • Integration with Microsoft Office: Integrate with SAP Business Warehouse and SAP HANA to power real-time analytics. For large-scale data analysis, you can integrate with Microsoft Excel to discover in-depth business insights and forecasts. Data analytics information can also be embedded into Microsoft PowerPoint presentations.

    • Cloud support: Extend and expand your BI on the cloud. SAP Analytics Cloud connects your BI to the cloud and offers enterprise planning and advanced analytics from a single online solution.

    Reviews from Real Users

    SAP BusinessObjects BI stands out among its competitors for a number of reasons. Several major ones are its user-friendly dashboard, its impressive reporting and analytic features, and its ability to integrate with multiple solutions.

    A managing partner at a tech services company writes, "One of the most valuable features of SAP BusinessObjects is that it's not a dashboarding solution. It's a real product. You can create operational reports and publish it to anyone. You can create schedules. You can create a Universe, semantic layers. There's also a security configuration. It's a huge product, so if there is a business need, SAP BusinessObjects can cover it."

    An associate manager at a consultancy notes, "It provides flexibility for creating reports. It is very good for creating highly complex reports. I like this solution because when I buy BusinessObjects, it comes with many components, such as reporting, dashboard, and data visualization tools. Its performance is good. It is running on top of SAP BW and SAP HANA."

    A manager of data analytics and interfaces at a healthcare company says, "It has got great flexibility. As a reporting tool, it has a great deal of flexibility for numerous data resources that you can bring into it. It allows you to write your SQL query directly within the product. It has great visualization. 

    Sample Customers
    UBS, TransUnion, Quantium, Daimler, OVH
    SRAM, Kennametal, Fairfax Water, British American Tobacco, Velux, and FedEx.
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm30%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    REVIEWERS
    Manufacturing Company20%
    Healthcare Company11%
    Energy/Utilities Company9%
    Insurance Company7%
    VISITORS READING REVIEWS
    Financial Services Firm14%
    Computer Software Company11%
    Manufacturing Company9%
    Government8%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    REVIEWERS
    Small Business29%
    Midsize Enterprise16%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise10%
    Large Enterprise71%
    Buyer's Guide
    Data Science Platforms
    April 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: April 2024.
    769,662 professionals have used our research since 2012.

    Dremio is ranked 9th in Data Science Platforms with 6 reviews while SAP BusinessObjects Business Intelligence Platform is ranked 6th in BI (Business Intelligence) Tools with 102 reviews. Dremio is rated 8.6, while SAP BusinessObjects Business Intelligence Platform is rated 7.8. The top reviewer of Dremio writes "It enables you to manage changes more effectively than any other platform". On the other hand, the top reviewer of SAP BusinessObjects Business Intelligence Platform writes "Web intelligence will work with any amount of data even if you have 10 million rows". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas SAP BusinessObjects Business Intelligence Platform is most compared with SAP Analytics Cloud, Microsoft Power BI, Oracle OBIEE, IBM Cognos and Looker.

    We monitor all Data Science Platforms reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.