Microsoft SQL Server Reporting Services vs Pentaho Business Analytics comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Microsoft SQL Server Report...
Ranking in Reporting
7th
Average Rating
7.8
Number of Reviews
16
Ranking in other categories
No ranking in other categories
Pentaho Business Analytics
Ranking in Reporting
17th
Average Rating
8.0
Number of Reviews
42
Ranking in other categories
BI (Business Intelligence) Tools (19th), Cloud Operations Analytics (4th)
 

Mindshare comparison

As of June 2024, in the Reporting category, the mindshare of Microsoft SQL Server Reporting Services is 3.3%, down from 5.5% compared to the previous year. The mindshare of Pentaho Business Analytics is 1.6%, down from 1.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
Unique Categories:
No other categories found
BI (Business Intelligence) Tools
0.6%
Cloud Operations Analytics
50.0%
 

Featured Reviews

Mark Jara - PeerSpot reviewer
Jul 5, 2023
Improved functionality within the SQL Server BI toolset
We use it to create reports within our internal systems, specifically our proprietary systems. So it's integrated into our existing applications We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities. It's integrated, making it…
Mir Gulzar Ahmed - PeerSpot reviewer
Nov 6, 2023
Excels in handling unstructured data, helping organizations navigate through different storage systems
Pentaho can help organizations by providing them an insight of their unstructured data using one platform(Pentaho Business Analytics). The features are almost identical to other BIS platforms but to me, customers can benefit as it has a community version with most of its Enterprise features. It also has a free limited-period trial version. The other feature that I would like to share here is, that users have access to a complete spectrum of data from different sources with the system’s adaptive big data layer, which takes the source of the data into account. The software is built on an open architecture and can be integrated with multiple systems. However, Pentaho Data Integration and Analytics has been acquired by HDS which offers an Enterprise edition for organizations that also need to meet product compliance.

Quotes from Members

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

Pros

"The SQL Server Reporting Services makes it very easy to get the data whenever we need it."
"The solution's features are all just wrapped up in one nice easy package. I don't need a lot of toolsets to get everything I need done."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"We get good support from Microsoft."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"In Microsoft SQL Server Reporting Services, the installation and configuration are easy."
"I am impressed with the product's seamless integration. It can work with different databases like Oracle."
"It is scalable."
"Easy to use components to create the job."
"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."
"The initial setup is pretty straightforward."
"The most valuable feature of Pentaho is the Tableau report."
"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."
 

Cons

"It is not easy to integrate the product with other tools in the market."
"The product could be improved by reducing the time it takes to build and deploy reports."
"Technical support is in minor need of improvement so that they can solve problems in a more timely manner."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"In this solution, the cost should be reduced for the enterprise edition."
"Microsoft SQL Server Reporting Services needs to improve performance."
"It doesn't have quite the flexibility of a Tableau or something like that. Many users are more comfortable with Tableau and I'm not quite sure why that is right now, but it seems to be the case."
"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."
"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."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"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."
"Logging capability is needed."
 

Pricing and Cost Advice

"The tool's licensing costs are expensive."
"The solution is free to use for developers."
"Value-wise, the solution's pricing is good for the price that we pay."
"The solution is cheaper than its alternatives."
"The price is pretty good."
"The product pricing is reasonable in terms of suitable features for business."
"The solution 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."
"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.
787,817 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
Financial Services Firm
16%
Government
10%
Computer Software Company
10%
Healthcare Company
7%
Financial Services Firm
23%
Computer Software Company
12%
Government
10%
Educational Organization
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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?
The product pricing is reasonable in terms of suitable features for business.
What needs improvement with Microsoft SQL Server Reporting Services?
The product could be improved by reducing the time it takes to build and deploy reports. We have improved the Server, but it's still in the prototype stage. It takes more time than another.
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 would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
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 with references to an added number of features.
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 reporting module. You will need to search for deployment examples or need to have a ...
 

Also Known As

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

Overview

 

Sample Customers

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: June 2024.
787,817 professionals have used our research since 2012.