We performed a comparison between Microsoft SQL Server Reporting Services 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."It is a stable solution."
"The initial setup is easy."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"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."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"I am impressed with the product's seamless integration. It can work with different databases like Oracle."
"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."
"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."
"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."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"The initial setup is pretty straightforward."
"The product should improve its performance."
"We encounter some barriers while trying to build a report."
"It is not easy to integrate the product with other tools in the market."
"In this solution, the cost should be reduced for the enterprise edition."
"The setup is difficult because you have to install different servers."
"It would be really nice to have better integration between the solution and Power BI."
"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."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"The repository should be improved."
"Version control would be a good addition."
"Another concern is that Pentaho is not customizable or interactive."
"Logging capability is needed."
"Pentaho Business Analytics' user interface is outdated."
"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."
More Microsoft SQL Server Reporting Services Pricing and Cost Advice →
Microsoft SQL Server Reporting Services is ranked 8th in Reporting with 16 reviews while Pentaho Business Analytics is ranked 17th in Reporting with 42 reviews. Microsoft SQL Server Reporting Services is rated 7.8, while Pentaho Business Analytics is rated 8.0. The top reviewer of Microsoft SQL Server Reporting Services writes "Offers useful templates but needs to improve the connectivity offered". On the other hand, the top reviewer of Pentaho Business Analytics writes "Flexible, easy to understand, and simple to set up". Microsoft SQL Server Reporting Services is most compared with TIBCO Jaspersoft, Microsoft Power BI, Tableau, SAP Crystal Reports and Oracle Business Intelligence Discoverer, whereas Pentaho Business Analytics is most compared with Microsoft Power BI, Databricks, SAP Crystal Reports, KNIME and Tableau. See our Microsoft SQL Server Reporting Services vs. Pentaho Business Analytics report.
See our list of best Reporting 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.