Shlomi Lavi /
May 11, 2022
We publish unbiased reviews. Our opinions are our own and are not influenced by payments from advertisers. This content is reader-supported, which means if you leave your details with us we may earn a commission. Learn why ITQlick is free .
Bottom Line: Which is Better - Microsoft SQL Server - BI or Pentaho Data Integration?
Microsoft SQL Server - BI is more expensive to implement (TCO) than Pentaho Data Integration, and Pentaho Data Integration is rated with the same score (70/100) as Microsoft SQL Server - BI (70/100). Pentaho Data Integration offers users more features (12) than Microsoft SQL Server - BI (5). There is a clear winner in this case and it is Pentaho Data Integration!
Looking for the right Business Intelligence solution for your business? Buyers are primarily concerned about the real total cost of implementation (TCO), the full list of features, vendor reliability, user reviews, and the pros and cons. In this article we compare between the two software products:
Microsoft Vs. Pentaho
Microsoft:
Microsoft Corporation is an American corporation that develops, manufactures, licenses and supports a wide range of products and services related to computing. The company was founded by Bill Gates and Paul Allen on April 4, 1975. Microsoft is the world's largest software maker measured by revenues.
Pentaho: Pentaho offers a suite of open source Business Intelligence (BI) products called Pentaho Business Analytics providing data integration, OLAP services, reporting, dashboarding, data mining and ETL capabilities.
Who is more expensive? Microsoft SQL Server - BI or Pentaho Data Integration?
The real total cost of ownership (TCO) of Business Intelligence software includes the software license, subscription fees, software training, customizations, hardware (if needed), maintenance and support and other related services. When calculating the TCO, it's important to add all of these ”hidden costs” as well. We prepared a TCO (Total Cost) calculator for Microsoft SQL Server - BI and Pentaho Data Integration.
Microsoft SQL Server - BI price starts at $931 per provider , On a scale between 1 to 10 Microsoft SQL Server - BI Edition is rated 8, which is higher than the average cost of Business Intelligence software. Pentaho Data Integration price starts at $100 per user/month , When comparing Pentaho Data Integration to its competitors, the software is rated 6 - similar to the average Business Intelligence software cost.
Bottom line: Microsoft SQL Server - BI is more expensive than Pentaho Data Integration.
Which software includes more/better features?
We've compared Microsoft SQL Server - BI Vs. Pentaho Data Integration based on some of the most important and required Business Intelligence features.
Microsoft SQL Server - BI: Business performance management, Database Management, Full Backup, Backup, Data recovery.
Pentaho Data Integration: Data Import/Export, Basic Reports, Online Customer Support, Basic Reports, Dashboard.
Target customer size
Microsoft SQL Server - BI's typical customers include: Small, medium and large size businesses, Pentaho Business Analytics is perfect for companies of various shapes and sizes.