Try our new research platform with insights from 80,000+ expert users

Pentaho Business Analytics vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
5.9
Pentaho Business Analytics enhanced efficiency and output but faced ROI calculation challenges compared to alternatives like QlikView and Tableau.
Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
6.8
Pentaho receives mixed feedback on support, with strong community engagement but varying customer service and documentation quality.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
 

Scalability Issues

Sentiment score
7.2
Pentaho scales well and fits organizational needs but may require admin expertise for complex environments and large data.
Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
 

Stability Issues

Sentiment score
6.6
Pentaho Business Analytics is generally stable but has occasional Java caching, RAM, and subprocess issues with large databases.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
It can handle large datasets.
It processes large volumes of data quickly.
 

Room For Improvement

Pentaho needs user interface, reporting, and visualization enhancements, along with better debugging, metadata management, and cost-effective licensing.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
Pentaho Business Analytics is hard to learn and not suited for initial users as it requires knowledge of operating systems, Java, and other technical skills.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Pentaho's Community Edition is cost-free, while the Enterprise Edition, offering enhanced features, can cost up to $250,000 annually.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Pentaho Business Analytics is priced similarly to other competitors such as QlikView and Tableau.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

Pentaho Business Analytics offers powerful ETL, user-friendly interface, customizable dashboards, and cost-saving, open-source analytics and reporting features.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
It is a stable product, and it can handle large datasets.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
 

Categories and Ranking

Pentaho Business Analytics
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
44
Ranking in other categories
BI (Business Intelligence) Tools (20th), Cloud Operations Analytics (4th), Reporting (16th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Mindshare comparison

Pentaho Business Analytics and SSIS aren’t in the same category and serve different purposes. Pentaho Business Analytics is designed for BI (Business Intelligence) Tools and holds a mindshare of 0.5%, down 0.6% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 7.9% mindshare, down 8.0% since last year.
BI (Business Intelligence) Tools
Data Integration
 

Q&A Highlights

PS
Apr 10, 2020
 

Featured Reviews

Sayan König - PeerSpot reviewer
Flexible, easy to understand, and simple to set up
The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history. The solution could really be improved. There are too many bugs in our version.
Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
842,767 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Answers from the Community

PS
Apr 10, 2020
Apr 10, 2020
Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection : 1) License cost 2) Type of data to be handled and integration with source database 3) Are we looking for cloud implementation or on-premises 4) Volume of data that we are looking at with possible transfo...
See 2 answers
Rahul Sahay - PeerSpot reviewer
Mar 18, 2020
Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection : 1) License cost 2) Type of data to be handled and integration with source database 3) Are we looking for cloud implementation or on-premises 4) Volume of data that we are looking at with possible transformations 5) Data Quality framework 6) Scalability 7) Customer experience ie support. I am from MS background and have worked both on cloud version and on-premises version. I was able to achieve my solution using MS.
RS
Apr 10, 2020
MS SQL Server Integration Services (SSIS) is a part of the commercial MS SQL Server product. It is not a freeware. Probably Pentaho offers an open source/ freeware edition. Below may be useful: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/13199248-e246-47aa-bab3-b2b73112d991/ssis-as-a-etl-tool-related-query?forum=sqlintegrationservices https://social.msdn.microsoft.com/Forums/sqlserver/en-US/47aeed76-8466-4e9f-bb48-b912c07145df/ssis-tool-evaluation?forum=sqlintegrationservices Nowadays SSDT (SQL server data tools) is also getting popularity: https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/ssdt/release-notes-ssdt?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver15
 

Top Industries

By visitors reading reviews
Financial Services Firm
27%
Computer Software Company
13%
Educational Organization
7%
Government
6%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
For those starting to use this tool, there is a free version available which is beneficial. The company also finds the pricing to be good.
What needs improvement with Pentaho Business Analytics?
The tool is very good, and yet it has some problems as it relies heavily on Java. The platform works with Java, and it has brought some issues to the company.
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

Pentaho, Kettle, Hitachi Pentaho Business Analytics
SQL Server Integration Services
 

Overview

 

Sample Customers

Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: March 2025.
842,767 professionals have used our research since 2012.