Dremio vs Oracle OBIEE comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,610 views|1,995 comparisons
100% willing to recommend
Oracle Logo
12,030 views|6,137 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and Oracle OBIEE 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).
768,578 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.""Everyone uses Dremio in my company; some use it only for the analytics function.""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.""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.""Dremio gives you the ability to create services which do not require additional resources and sterilization."

More Dremio Pros →

"The most valuable features of Oracle OBIEE are the ease of logging in, the dashboard, and showing the problems in the data. Additionally, the reports are well integrated and it has good technology.""Oracle OBIEE is good for data visualization and analytical reporting.""The most valuable features of Oracle OBIEE are ease of use, the graphical user interface is simple to understand, and the reports can be done without problems. There are many tutorials and training materials available if needed.""The most valuable feature is the ability to run it in Exalytics within memory coupled to a Repository on Exadata is where it flies. So it's not meant for mom and pop shops, but if you are a global 500 fortune 1000 company, this is a tool that can get you what you need on time and even in real time.""The most valuable features of the solution are the various scenarios the product offers and its stability.""The most valuable feature of Oracle OBIEE is its ease of use.""It has a lot workaround in order to do the report. data blending, and getting information from big data sources.""The most valuable feature is the user-friendly set of tools that the customer can use to develop their own business dashboards."

More Oracle OBIEE Pros →

Cons
"It shows errors sometimes.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""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.""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.""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."

More Dremio Cons →

"Essbase integration needs to be worked on.""In our organization, we feel that data visualization for APIs is an area in which the solution lacks.""It takes a lot of maintenance to support the architecture, which is something that should be improved.""Its overall organization as an analytical tool, the layout of OBIEE, is not very good.""It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market.""The performance could be better.""The performance could improve and in a future release, they could provide more virtualization options.""An area for improvement is that Oracle pushes more users to Oracle BI Publisher rather than emphasizing Oracle OBIEE for reporting. The pricing for Oracle OBIEE could be improved."

More Oracle OBIEE 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 →

  • "It is high."
  • "It's expensive."
  • "I think to spread this across an enterprise will be a significant investment."
  • "Be prepared to spend a lot of time and money."
  • "The pricing we negotiated with Oracle. But, I do not have details."
  • "Oracle products are extremely expensive."
  • "This was not an expensive product for us, although the price varies depending on conditions for each company."
  • "The cost of this solution is a little bit high compared with other products like Zoho, so reducing it would make OBIEE more competitive."
  • More Oracle OBIEE Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    768,578 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    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:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Top Answer:Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to assist customers. These are two attributes that make this system quite valuable. OBIEE… more »
    Top Answer:The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand.
    Ranking
    10th
    Views
    2,610
    Comparisons
    1,995
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Views
    12,030
    Comparisons
    6,137
    Reviews
    25
    Average Words per Review
    481
    Rating
    8.0
    Comparisons
    Also Known As
    OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
    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.

    Oracle OBIEE (Oracle Business Information Enterprise Edition) is a business intelligence (BI) tool developed by Oracle. OBIEE will gather, store and analyze an organization's network data and compile the information to create reports, dashboard graphs, and performance analysis. OBIEE’s unique platform allows clients to discover new awareness and improve the speed of completing important business decisions by providing robust visual tools and intuitive realization coupled with the latest unmatched enterprise analytics available. OBIEE helps IT enterprise organizations to experience an intelligent view of all enterprise data from across all sources and empowers trusted users with increased levels of reliable, dependable access, interaction, and the ability to utilize the data to increase the overall effectiveness and productivity of the organization.

    OBIEE provides unique immediate mobile access, intuitive dashboards, robust reporting, real-time alerts, metadata search, procedure management, direct access to Big Data resources, enlightened in-memory computing, and seamless systems management processes. These features seamlessly combine to make Oracle OBIEE a complete, top-of-the-line broad solution that is cost-effective, minimizes TCO, and provides a competitive, quick ROI for the entire organization.

    Oracle OBIEE Top Features 

    • Complete comprehension: Oracle OBIEE offers a full range of BI strategies, including intuitive smart dashboards, dynamic alerts and detection, efficient workflows, enterprise reporting, MS Office integration, real-time predictive analysis, and more. OBIEE also includes many next-generation options, including mission critical scalability and performance, diverse data access and integration, and a modern, robust, service-oriented architecture.
    • Hot-pluggable: OBIEE will take advantage of existing IT relationships, both Oracle and non-Oracle databases, solutions, and applications. Organizations that partner with OBIEE have access to an entire library of analytic tools that are immediately deployable and provide an improved TCO and a super-fast ROI. Additionally, in an outstanding collaboration with Hyperion, OBIEE incorporates BI tools that integrate well with the current suite to supply the grandest selection of BI tools available on the market today.
    • Extensive: OBIEE is very user-friendly and extremely intuitive, and the 100% Web UI brings robust and dynamic BI from diverse sources to any audience, distributing awareness when and where users require it to manage activities, decisions, and processes. 

    Reviews from Real Users

    Sandeep V., Process System Engineer at a comms service provider, tells us, “This solution is very easy for people who are building ad-hoc things. It's an enterprise solution so it can be deployed for a lot of users. There are some great new features that come with the 12c like data visualization, desktop BI Publisher, automation, and interactive dashboards. The product has good features. “ 

    A user who is a CEO at a consultancy relates, “The most valuable feature is the visualization. The data warehousing, data storage, and data wrangling are all features that are in there, and it's one of the better products out there. A good thing is that for large datasets, it's very stable, especially when you have an Oracle database.”

    A user who is a Principal Business Intelligence Architect at a computer software company suggests, "It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market."



    Sample Customers
    UBS, TransUnion, Quantium, Daimler, OVH
    Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company12%
    Manufacturing Company10%
    Government7%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Government12%
    Computer Software Company11%
    Manufacturing Company7%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business22%
    Midsize Enterprise20%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    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.
    768,578 professionals have used our research since 2012.

    Dremio is ranked 10th in Data Science Platforms with 6 reviews while Oracle OBIEE is ranked 3rd in BI (Business Intelligence) Tools with 154 reviews. Dremio is rated 8.6, while Oracle OBIEE 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 Oracle OBIEE writes "A solution that is easily accessible, scalable and requires a straightforward initial setup process to get started". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas Oracle OBIEE is most compared with Microsoft Power BI, SAP BusinessObjects Business Intelligence Platform, IBM Cognos, Tableau and Oracle Analytics Cloud.

    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.