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
15th
Average Rating
8.0
Reviews Sentiment
5.8
Number of Reviews
42
Ranking in other categories
BI (Business Intelligence) Tools (21st), 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 November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Pentaho Business Analytics is 1.2%, down from 1.5% compared to the previous year. The mindshare of SAP Crystal Reports is 2.8%, down from 4.1% 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

"I have worked on the features like dashboards and stories, and I do like them a lot."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"It is a stable product."
"The tool can join data from different sources, write back to databases, generate alerts, and be customized to our preferences. It's an enterprise BI tool that's more powerful than just visualization tools like Power BI or Tableau."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."
"It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information."
"The initial setup is very straightforward."
"The initial setup is pretty straightforward."
"Easy to use components to create the job."
"The most valuable feature of Pentaho is the Tableau report."
"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."
"We were able to install it without any assistance from tech support."
"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."
"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."
"The initial setup of the solution is pretty easy."
"The overall environment is the best. Data management, graphs, and layout – everything is the best, in my opinion."
"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 most valuable feature of the solution is that it is a fantastic way of generating reports."
"We use SAP Crystal Reports for operational reporting."
"It is an user-friendly solution."
"I find Crystal Reports very easy to use, even for a non-technical person."
 

Cons

"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"I think the GIS pieces maybe not as good as we would like."
"IBM Support can be slow at times, but they can usually deliver in a timely manner."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"The solution seems to slow down the servers."
"There are a lot of limitations with the out-of-the-box tool."
"This product could use improvement in terms of usability for those with less technical know how."
"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."
"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."
"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."
"Pentaho Business Analytics' user interface is outdated."
"The repository should be improved."
"Another concern is that Pentaho is not customizable or interactive."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"The financing part needs improvement."
"A real improvement would be a simpler system that allows users to play with the visualization without needing specialized skills and code."
"If at all possible, a little bit of improvement on the analytical side is needed."
"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."
"There could be improvements made to the analytics capabilities."
"SAP Crystal Reports has some compatibility issues with third-party products."
"SAP Crystal Reports should provide better support for dynamic connectors."
"Maybe some Power BI-related features could be added, like dashboards or direct editing in reports."
 

Pricing and Cost Advice

"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"It is my understanding that the cost is very low. It's not very expensive."
"It is averagely priced."
"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"Pricing should be improved."
"The pricing of this product is meant for medium to large-scale enterprises."
"It's more expensive than similar solutions like Tableau and Power BI."
"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."
"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."
"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."
"We pay fifteen hundred dollars as licensing fee."
"SAP Crystal Reports is a very expensive solution."
"This product costs a lot of money."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,192 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
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
24%
Computer Software Company
14%
Government
7%
Educational Organization
7%
Computer Software Company
11%
Financial Services Firm
10%
Government
10%
Manufacturing Company
9%
 

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?
The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive wi...
What needs improvement with Pentaho Business Analytics?
The product to me is not as user-friendly as other players in the market. It also still needs improvement in the repo...
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: October 2024.
816,192 professionals have used our research since 2012.