Try our new research platform with insights from 80,000+ expert users

Pentaho Business Analytics vs SAP Crystal Reports comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Pentaho Business Analytics
Ranking in Reporting
16th
Average Rating
8.0
Reviews Sentiment
5.8
Number of Reviews
43
Ranking in other categories
BI (Business Intelligence) Tools (20th), Cloud Operations Analytics (4th)
SAP Crystal Reports
Ranking in Reporting
9th
Average Rating
8.4
Number of Reviews
49
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Reporting category, the mindshare of IBM Cognos is 4.6%, down from 6.1% compared to the previous year. The mindshare of Pentaho Business Analytics is 1.2%, down from 1.6% compared to the previous year. The mindshare of SAP Crystal Reports is 2.8%, down from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Sayan König - PeerSpot reviewer
Flexible, easy to understand, and simple to set up
The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history. The solution could really be improved. There are too many bugs in our version.
MVD Prasad - PeerSpot reviewer
Helps analyze your data by creating richly formatted, pixel-perfect, and multiple reports from virtually any data source, delivered in over a dozen formats
It has significantly enhanced security features, especially when compared to the standard security features of the earlier PeerSpot version I purchased. I've observed improvements in security, and overall, it's quite commendable. Regarding potential enhancements for the next release of this solution, I haven't closely examined SAP Crystal Reports 53. I've only encountered it briefly, perhaps once or twice. However, I anticipate that it likely offers advanced features distinct from its predecessor. I believe there may be notable improvements and additions in the latest version, and I look forward to exploring them further.

Quotes from Members

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

Pros

"The Report Studio that is aimed at professional report writers."
"We are able to generate quality reports easily which allows us to decrease response time."
"Even while a user is using a cube for reporting, there will not be a situation as ' Cube file locked; unable to build or deploy'."
"Stability-wise, I rate the solution a ten out of ten."
"It is a stable product."
"Self-service is possible through the use of dashboards, which are also very intuitive. Stories can be used to pin snapshots, tell the story for meetings, etc."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"The comprehensiveness or broadness of the software functions or business intelligence functions that it provides is valuable. It is also quite easy to use and user-friendly."
"The most valuable feature of Pentaho is the Tableau report."
"Easy to use components to create the job."
"The initial setup is pretty straightforward."
"We were able to install it without any assistance from tech support."
"It is robust, offers market intelligence, and utilizes modules effectively."
"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."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"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."
"The initial setup of the solution is pretty easy."
"I find Crystal Reports very easy to use, even for a non-technical person."
"It is an user-friendly solution."
"SAP Crystal Reports offers a plethora of features, many of which were available much earlier than in the Crystal Reports we previously used. We extensively use its capabilities for generating general reports, working with Kaspersky data, and even incorporating images into our reports. The range of functions available in SAP Crystal Reports is diverse, and we leverage them across various systems for our needs."
"We use SAP Crystal Reports for operational reporting."
"The most valuable feature is that from a user's point of view, it is easy to use and requires just a simple click to generate a report."
"The overall environment is the best. Data management, graphs, and layout – everything is the best, in my opinion."
"The most valuable feature of the solution is that it is a fantastic way of generating reports."
 

Cons

"One thing that we really want is the ability to have data portrayed on an image. Cognos is not able to do it at the moment, and that's becoming a requirement from the business side: having an image and then plotting your dataset on top of the image as a map."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"Tableau and Power BI are faster than Cognos."
"There are many problems with the product's stability part, making it an area where improvements are required."
"Compared to Tableau and PowerBI, the IBM interface is easier to use. However, the drag-and-drop functionality isn't as straightforward. Formatting is also more challenging in the cloud than in other applications, like Power BI. Also, if you encounter an issue, it takes more time to resolve it on the formatting side."
"There are a lot of limitations with the out-of-the-box tool."
"Extending dynamic cubes aggregate awareness with calculated measures."
"Pentaho Business Analytics' user interface is outdated."
"Logging capability is needed."
"Another concern is that Pentaho is not customizable or interactive."
"The tool is very good, and yet it has some problems as it relies heavily on Java."
"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."
"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."
"Version control would be a good addition."
"The financing part needs improvement."
"There could be improvements made to the analytics capabilities."
"SAP Crystal Reports has some compatibility issues with third-party products."
"A real improvement would be a simpler system that allows users to play with the visualization without needing specialized skills and code."
"It has significantly enhanced security features, especially when compared to the standard security features of the earlier PeerSpot version I purchased. I've observed improvements in security, and overall, it's quite commendable. Regarding potential enhancements for the next release of this solution, I haven't closely examined SAP Crystal Reports 53. I've only encountered it briefly, perhaps once or twice. However, I anticipate that it likely offers advanced features distinct from its predecessor. I believe there may be notable improvements and additions in the latest version, and I look forward to exploring them further."
"Maybe some Power BI-related features could be added, like dashboards or direct editing in reports."
"SAP Crystal Reports should provide better support for dynamic connectors."
"If at all possible, a little bit of improvement on the analytical side is needed."
 

Pricing and Cost Advice

"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"It is my understanding that the cost is very low. It's not very expensive."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"It is averagely priced."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"Pentaho is expensive ."
"Free and commercial versions are available."
"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."
"SAP Crystal Reports is a very expensive solution."
"We pay fifteen hundred dollars as licensing fee."
"The cost of licensing can be a significant factor to consider when upgrading or transitioning to a new version of SAP Crystal Reports. It's important to evaluate the benefits and features offered by the new version against the associated costs to ensure it aligns with your organization's needs and budget."
"I feel that SAP Crystal Reports is a reasonably priced product."
"This product costs a lot of money."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
824,129 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Top Industries

By visitors reading reviews
Educational Organization
55%
Financial Services Firm
7%
Computer Software Company
4%
Manufacturing Company
4%
Financial Services Firm
25%
Computer Software Company
13%
Government
8%
Educational Organization
7%
Financial Services Firm
11%
Computer Software Company
10%
Government
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I wou...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
For those starting to use this tool, there is a free version available which is beneficial. The company also finds th...
What needs improvement with Pentaho Business Analytics?
The tool is very good, and yet it has some problems as it relies heavily on Java. The platform works with Java, and i...
What needs improvement with SAP Crystal Reports?
Maybe some Power BI-related features could be added, like dashboards or direct editing in reports. We use query langu...
What is your primary use case for SAP Crystal Reports?
We use SAP Crystal Reports for reporting. We use it for financial reports like statements of accounts, trial balances...
What do you like most about SAP Crystal Reports?
We use SAP Crystal Reports for operational reporting.
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
Pentaho, Kettle, Hitachi Pentaho Business Analytics
No data available
 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), LivePerson, Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY WEiJL, El Machetazo, Young Heroes, Mozzart, Mitsui Knowledge Industry (MKI) , Surgutneftegas Open Joint Stock Company, The VELUX Group, AOK Bundesverband, AL-KO KOBER GROUP
Find out what your peers are saying about Pentaho Business Analytics vs. SAP Crystal Reports and other solutions. Updated: December 2024.
824,129 professionals have used our research since 2012.