Oracle Essbase vs Oracle OBIEE vs Pentaho Business Analytics comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
185 views|131 comparisons
100% willing to recommend
Oracle Logo
12,030 views|6,137 comparisons
87% willing to recommend
Hitachi Vantara Logo
1,175 views|854 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Essbase, Oracle OBIEE, and Pentaho Business Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management.
To learn more, read our detailed Database Development and Management Report (Updated: April 2024).
768,415 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
"The solution is scalable.""The solution can handle a large volume of data.""The solution is stable and reliable.""Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data.""It is highly efficient and easily scalable, particularly for handling large databases.""I have found the most valuable aspect is the user-friendly environment and current features.""Essbase is extremely stable and low-maintenance.""It helps us fetch specific data sets per users' requirements."

More Oracle Essbase Pros →

"We have scheduled reports delivered automatically to our business users using enterprise features.""In terms of features, everything is good. It is also stable and scalable.""Ability to create our own reports.""There are some great new features in the latest version.""It doesn't have many frills and is definitely older technology, but it is undeniably a workhorse.""The most valuable feature is the ability to set up the automated delivery of reports.""The most valuable features are the lexical parameters and distribution.""Its robustness is most valuable. It can handle massive amounts of data quickly. If it's properly configured and tuned, it can handle massive amounts of data very quickly to produce results. That to me is the number one feature."

More Oracle OBIEE Pros →

"We were able to install it without any assistance from tech support.""I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced.""Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud.""Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it.""Easy to use components to create the job.""The initial setup is pretty straightforward.""The most valuable feature of Pentaho is the Tableau report."

More Pentaho Business Analytics Pros →

Cons
"It's an expensive product to use.""The initial setup could be simplified.""The ability to drive external reporting out for development could be improved.""They should improve the solution's performance.""The initial setup is pretty complex.""Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good.""There is room for improvement in terms of cost-effectiveness.""I would like to see an integration with application performance management and a version control management tool."

More Oracle Essbase Cons →

"Oracle OBIEE only displays KPIs, but it does not include strategic objectives or display risk in a strategic map.""It's not so flexible to do BI reporting directly from the data source without models. It is not that agile.""Its functionality is lacking.""I would like to see enhancements in tracking, debugging, and flexibility.""The performance could improve and in a future release, they could provide more virtualization options.""Particularly on the Cloud, a lot of functionality has yet to be ported.""It could be more user-friendly. For example, the RPD layer could be more straightforward. From a user's point of view, the visualization, especially the graphs, are not as attractive when compared to other tools like QlikView and Qlik Sense.""The functionality to customize and modify reports has been removed, and it would be beneficial to reinstall it, as it allows greater customization and flexibility in creating reports."

More Oracle OBIEE Cons →

"Another concern is that Pentaho is not customizable or interactive.""Pentaho Business Analytics' user interface is outdated.""The repository should be improved.""Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process.""Version control would be a good addition.""We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost.""Logging capability is needed.""Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."

More Pentaho Business Analytics Cons →

Pricing and Cost Advice
  • "Essbase is competitively priced."
  • "I believe the licensing is on a monthly base."
  • "It is a costly solution."
  • "The solution is expensive."
  • More Oracle Essbase 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 →

  • "Free and commercial versions are available."
  • "Pentaho is expensive ."
  • "We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
  • More Pentaho Business Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
    768,415 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:It is a costly solution. This is because we require high-performance servers with substantial CPU and RAM capacities to… more »
    Top Answer:There is room for improvement in terms of cost-effectiveness.
    Top Answer:We are a telecommunications company operating in Iran, and we manage a vast amount of data related to our network… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are… 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… more »
    Top Answer:The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI… more »
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would… more »
    Top Answer:The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with… more »
    Top Answer:The product to me is not as user-friendly as other players in the market. It also still needs improvement in the… more »
    Ranking
    Views
    185
    Comparisons
    131
    Reviews
    8
    Average Words per Review
    381
    Rating
    8.4
    Views
    12,030
    Comparisons
    6,137
    Reviews
    25
    Average Words per Review
    481
    Rating
    8.0
    Views
    1,175
    Comparisons
    854
    Reviews
    4
    Average Words per Review
    526
    Rating
    7.0
    Comparisons
    Also Known As
    Essbase
    OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
    Pentaho, Kettle, Hitachi Pentaho Business Analytics
    Learn More
    Overview

    Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.

    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."



    Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

    Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

    The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

    Sample Customers
    CHU de Rennes, Bellco Credit Union, Akindo Sushiro Co. Ltd, Deutsche Telekom AG, Samarco MineraÊo S.A., PCCW Ltd., QDQ media S.A.U., Boiron Italia, Specialized Bicycle Components Inc., Akindo Sushiro Co. Ltd., Air Canada, Daelim Industrial Co. Ltd.
    Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
    Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
    Top Industries
    REVIEWERS
    Financial Services Firm50%
    Retailer25%
    Computer Software Company13%
    Comms Service Provider13%
    VISITORS READING REVIEWS
    Financial Services Firm23%
    Computer Software Company9%
    Manufacturing Company9%
    Retailer7%
    REVIEWERS
    Computer Software Company12%
    Financial Services Firm12%
    Manufacturing Company10%
    Government7%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Government12%
    Computer Software Company11%
    Manufacturing Company7%
    REVIEWERS
    Computer Software Company19%
    University13%
    Financial Services Firm13%
    Government6%
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Government12%
    Computer Software Company11%
    Educational Organization9%
    Company Size
    REVIEWERS
    Small Business27%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise76%
    REVIEWERS
    Small Business22%
    Midsize Enterprise20%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    REVIEWERS
    Small Business50%
    Midsize Enterprise17%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise13%
    Large Enterprise60%
    Buyer's Guide
    Database Development and Management
    April 2024
    Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management. Updated: April 2024.
    768,415 professionals have used our research since 2012.