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

Microsoft SQL Server Reporting Services vs Pentaho Business Analytics 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)
Microsoft SQL Server Report...
Ranking in Reporting
6th
Average Rating
7.8
Reviews Sentiment
8.0
Number of Reviews
18
Ranking in other categories
No ranking in other categories
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)
 

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 Microsoft SQL Server Reporting Services is 3.7%, down from 4.9% compared to the previous year. The mindshare of Pentaho Business Analytics is 1.2%, down from 1.5% 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.
Gnanavel-Chakkarapani - PeerSpot reviewer
Offers useful templates but needs to improve the connectivity offered
In Microsoft SQL Server Reporting Services, not much of the interface part is used. With Microsoft SQL Server Reporting Services, its users face issues with the interface after they use Excel or create Microsoft SSIS Packages. The tool's interface is an area of concern requiring improvement. There needs to be an improvement in the product's connectivity so that the tool can connect easily with other third-party databases. In the dashboard, drag and drop functionality needs to improve, especially when compared to other tools like IBM Cognos Analytics and Qlik Sense. Microsoft SQL Server Reporting Services is useful only for standard reports. In IBM Cognos Analytics, query studio can be used by users to drag the data and simply download the reports, so the user doesn't need to have any technical knowledge like developers. Microsoft SQL Server Reporting Services is to be improved to offer features like query Studio, which is provided in IBM Cognos Analytics.
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.

Quotes from Members

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

Pros

"The most valuable features of IBM Cognos are governance and enterprise reporting."
"The most valuable feature is developing reports from different data sources, making it a reliable data source."
"Integration with Office can enable the 'download' mode of storytelling.​"
"Dashboarding, reporting, and ad hoc reporting are the valuable features of IBM Cognos."
"The main difference that I like about Cognos compared to other solutions is its data splitting functionality. We have all our company data inside the Cognos environment and so we prefer to split the information Cognos itself. It's more efficient this way."
"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."
"If they want dashboarding, storytelling, and analyzing why KPIs are met or not, then Cognos is a better candidate than Qlik Sense."
"The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools."
"I'm very satisfied with the customer service. And usually, whenever we have any issue or details, we get to the person for the support. I'm really satisfied with the service. Within a few minutes or within a few hours, the support person will be available."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"It is scalable."
"We can create quality reports in real time."
"It is a stable solution."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"The solution is known for its robust security features."
"The initial setup is pretty straightforward."
"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."
"We were able to install it without any assistance from tech support."
"The most valuable feature of Pentaho is the Tableau report."
"Easy to use components to create the job."
 

Cons

"The technical support team’s response time is slow and needs to be improved."
"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"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."
"I need improvements, particularly with the Framework Manager, which has an outdated user interface from older versions like IBM Cognos 10 or 8. Additionally, the Event Studio, which offered great flexibility in previous versions, is no longer available in IBM Cognos Analytics 12. These are areas that could be improved to enhance the product."
"Most of our company's customers want to be able to deploy IBM Cognos on a web application and use it as a desktop application, which is not possible currently."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"The product should improve its performance."
"Sometimes, we need to make sure that the configuration stays consistent across the reporting instances. They all connect to the same database. So, it shares that same backend, but the reporting services itself can also be configured. On the application level, for reporting level. And it is, based on my own experience, it is a manual effort to make sure that the reporting servers are configured the same across the environment."
"It is not easy to integrate the product with other tools in the market."
"We encounter some barriers while trying to build a report."
"It would be really nice to have better integration between the solution and Power BI."
"Microsoft SQL Server Reporting Services needs to improve performance."
"The setup is difficult because you have to install different servers."
"There is room for improvement in the pricing model."
"Pentaho Business Analytics' user interface is outdated."
"Another concern is that Pentaho is not customizable or interactive."
"Version control would be a good addition."
"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."
"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."
"The repository should be improved."
 

Pricing and Cost Advice

"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"It's more expensive than similar solutions like Tableau and Power BI."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"Pricing should be improved."
"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 a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"The solution is free to use for developers."
"The pricing is high."
"The product pricing is reasonable in terms of suitable features for business."
"The tool's licensing costs are expensive."
"Value-wise, the solution's pricing is good for the price that we pay."
"The solution is expensive."
"The solution is cheaper than its alternatives."
"The price is pretty good."
"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."
"Free and commercial versions are available."
"Pentaho is expensive ."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,406 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
14%
Government
12%
Computer Software Company
10%
Manufacturing Company
7%
Financial Services Firm
24%
Computer Software Company
14%
Government
7%
Educational Organization
7%
 

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...
What do you like most about Microsoft SQL Server Reporting Services?
I mainly use the solution for the ease of reporting and for executive dashboards.
What is your experience regarding pricing and costs for Microsoft SQL Server Reporting Services?
Microsoft SQL Server Reporting Services should be okay if you're within the budget. We're just using open-source solu...
What needs improvement with Microsoft SQL Server Reporting Services?
QL Server can support the customer language in the long term, so we can use another language to build some components.
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...
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
Pentaho, Kettle, Hitachi Pentaho Business Analytics
 

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.
CMS Wire, The New York Times
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. Pentaho Business Analytics and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.