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."I mainly use the solution for the ease of reporting and for executive dashboards."
"We can create quality reports in real time."
"We get good support from Microsoft."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"The SQL Server Reporting Services makes it very easy to get the data whenever we need it."
"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."
"The initial setup is easy."
"It is scalable."
"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."
"The initial setup is pretty straightforward."
"We were able to install it without any assistance from tech support."
"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."
"Easy to use components to create the job."
"There is room for improvement in the pricing model."
"The solution's interface is old."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"I would like the solution to add the scheduling feature for reports."
"The product should improve its performance."
"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."
"Microsoft SQL Server Reporting Services needs to improve performance."
"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."
"Pentaho Business Analytics' user interface is outdated."
"The repository should be improved."
"Version control would be a good addition."
"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."
More Microsoft SQL Server Reporting Services Pricing and Cost Advice →
Microsoft SQL Server Reporting Services is ranked 7th 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 Microsoft Power BI, TIBCO Jaspersoft, Tableau, SAP Crystal Reports and Oracle Business Intelligence Discoverer, whereas Pentaho Business Analytics is most compared with Microsoft Power BI, Databricks, KNIME, SAP Crystal Reports 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.