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."The solution is known for its robust security features."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"I am impressed with the product's seamless integration. It can work with different databases like Oracle."
"It is a stable solution."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"We get good support from Microsoft."
"It is scalable."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"We were able to install it without any assistance from tech support."
"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 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."
"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."
"We encounter some barriers while trying to build a report."
"The solution's interface is old."
"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."
"Microsoft SQL Server Reporting Services needs to improve performance."
"In this solution, the cost should be reduced for the enterprise edition."
"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."
"I would like the solution to add the scheduling feature for reports."
"The product should improve its performance."
"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."
"Version control would be a good addition."
"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."
"The repository should be improved."
"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."
"Another concern is that Pentaho is not customizable or interactive."
More Microsoft SQL Server Reporting Services Pricing and Cost Advice →
Microsoft SQL Server Reporting Services is ranked 8th in Reporting with 15 reviews while Pentaho Business Analytics is ranked 17th in Reporting with 42 reviews. Microsoft SQL Server Reporting Services is rated 7.6, 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.