We performed a comparison between Oracle OBIEE and Pentaho Business Analytics based on real PeerSpot user reviews.
Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable features are the lexical parameters and distribution."
"The centralized metadata model component is most valuable."
"The solution is user-friendly."
"The most valuable feature of Oracle OBIEE is it's designed for Oracle. It works well in the Oracle environment and can sit on top of any application."
"I have not personally used any such products related to this service, however based on the popular opinion, Microsoft Power BI is more popular. We have never switched from this software due to infrastructure and license related costs. However, my team acknowledges that the Power BI is much more enhanced and includes features that are easier to use, including its drag and drop features. I am not sure, if OBIEE has these features, due to lack of updated versions."
"The scalability of the product is good."
"The solution is easy to use and very flexible."
"I think the most valuable features are the ability to drill down, the graphs, and the scheduling for the reports to be received in Excel on a daily basis. Users like Excel, so it's good for them that they receive the reports by email, that they don't have to specify the schedule."
"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."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"We were able to install it without any assistance from tech support."
"Easy to use components to create the job."
"The initial setup is pretty straightforward."
"The most valuable feature of Pentaho is the Tableau report."
"Even though we have a feature to enable the physical query to be seen in the log, in case of any issues, it is challenging to debug and see or identify where is the issue. For example, we designed the OBIEE repository and deployed it into the server, and we are now accessing and creating a report. For some reason, if the report is not working as expected, it is very difficult to identify the issue. We have a feature to see the physical query that is being generated in the central OBIEE server. I feel that this feature should have been available at the repository level so that while designing the repository, we can select the presentation columns and the query it is going to create. This will avoid the additional task of deploying a feature into the server and then testing the report. It will also make the implementation process friendly if, while designing the repository, we can see: How is a feature working? Are any of the presentation columns selected? How is the query being generated? Which query is being generated? Are any joints used? What kind of joints are used? Having this kind of information will make Oracle OBIEE more powerful and developer-friendly."
"While it is a user-friendly, data-driven tool, the data modeling should be easier to use."
"It would be better if it had a wide range of visualization options. For example, Microsoft Power BI has an extensive range of visualization options, but it's not available in OBIEE. There are also some conflicts because it's complicated, but the cloud application is easier. They added some features for ETL with the on-premises application, but we need a different or a separate application for ETL in the cloud. In the next release, I would like to have more AI features."
"I would like to see the data wrangling features enhanced."
"BI Server"
"Supply chain and finance."
"Oracle OBIEE could improve the visualizations, such as diagrams, charts, and graphical user interface. Other tools on the market have better graphical visualizations this Oracle OBIEE."
"The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand. I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy. We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months. We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization. Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business. In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Logging capability is needed."
"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."
"The repository should be improved."
"Another concern is that Pentaho is not customizable or interactive."
"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."
"Pentaho Business Analytics' user interface is outdated."
Oracle OBIEE is ranked 3rd in Reporting with 154 reviews while Pentaho Business Analytics is ranked 16th in Reporting with 42 reviews. Oracle OBIEE is rated 7.8, while Pentaho Business Analytics is rated 8.0. The top reviewer of Oracle OBIEE writes "A solution that is easily accessible, scalable and requires a straightforward initial setup process to get started". On the other hand, the top reviewer of Pentaho Business Analytics writes "Flexible, easy to understand, and simple to set up". Oracle OBIEE is most compared with Microsoft Power BI, SAP BusinessObjects Business Intelligence Platform, IBM Cognos, Tableau and Oracle Analytics Cloud, whereas Pentaho Business Analytics is most compared with Microsoft Power BI, Databricks, Microsoft SQL Server Reporting Services, SAP Crystal Reports and Qlik Sense. See our Oracle OBIEE vs. Pentaho Business Analytics report.
See our list of best Reporting vendors and best BI (Business Intelligence) Tools vendors.
We monitor all Reporting 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.