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 am impressed with the product's seamless integration. It can work with different databases like Oracle."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"We get good support from Microsoft."
"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."
"It is scalable."
"It is a stable solution."
"Easy to use components to create the job."
"We were able to install it without any assistance from tech support."
"The most valuable feature of Pentaho is the Tableau report."
"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."
"The initial setup is pretty straightforward."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"There is room for improvement in the pricing model."
"In this solution, the cost should be reduced for the enterprise edition."
"The product should improve its performance."
"The setup is difficult because you have to install different servers."
"Microsoft SQL Server Reporting Services needs to improve performance."
"It would be really nice to have better integration between the solution and Power BI."
"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."
"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."
"Version control would be a good addition."
"Another concern is that Pentaho is not customizable or interactive."
"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 Business Analytics' user interface is outdated."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Logging capability is needed."
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 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.