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

Pentaho Business Analytics vs SSIS comparison

The compared Hitachi Vantara and Microsoft solutions aren't in the same category. Hitachi Vantara is ranked #20 in BIT , with an average rating of 8.7, and holds a 0.5% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 7.8, and holds a 7.9% mindshare. Additionally, 90% of Hitachi Vantara users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.
Pentaho Business Analytics
Read 44 Pentaho Business Analytics reviews
  • 584 Views
  • 421 Comparison Views
90% willing to recommend
SSIS
Read 73 SSIS reviews
  • 12,026 Views
  • 8,992 Comparison Views
79% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive Summary
We performed a comparison between Pentaho Business Analytics and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: March 2025).
Buyer's Guide
BI (Business Intelligence) Tools
March 2025
Download the complete report
Helped 849,686 peers since 2012

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.
No quotes available
For more quotes and insights, download the Pentaho Business Analytics report
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
For more quotes and insights, download the SSIS report
 

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.
For more quotes and insights, download the Pentaho Business Analytics report
It processes large volumes of data quickly.
For more quotes and insights, download the SSIS report
 

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.
For more quotes and insights, download the Pentaho Business Analytics report
SSIS has a difficult learning curve when dealing with complex transformations.
For more quotes and insights, download the SSIS report
 

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.
For more quotes and insights, download the Pentaho Business Analytics report
Utilizing SSIS involves no extra charges beyond the SQL Server license.
For more quotes and insights, download the SSIS report
 

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.
For more quotes and insights, download the Pentaho Business Analytics report
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
For more quotes and insights, download the SSIS report
 

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, up 7.9% since last year.
BI (Business Intelligence) Tools
Data Integration
 

Q&A Highlights

PS
Apr 10, 2020
What is the biggest difference between SSIS and Pentaho?
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.
See all answers
 

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.
Read full review
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.
Read full review
report
See which vendors are best for you
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
See recommendations
849,686 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…
Read full review
 

Answers from the Community

PS
Apr 10, 2020
Apr 10, 2020
What is the biggest difference between SSIS and Pentaho?
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.
Read full answer
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
Read full answer
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Computer Software Company
14%
Educational Organization
7%
Real Estate/Law Firm
7%
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...
See all answers
What is your experience regarding pricing and costs for Pentaho Business Analytics?
Pentaho Business Analytics is priced similarly to other competitors such as QlikView ( /products/qlikview-reviews ) and Tableau ( /products/tableau-reviews ). I usually use the community edition.
See all answers
What needs improvement with Pentaho Business Analytics?
Pentaho Business Analytics ( /categories/bi-business-intelligence-tools ) is hard to learn and not suited for initial users as it requires knowledge of operating systems, Java, and other technical ...
See all answers
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...
See all answers
What do you like most about SSIS?
The product's deployment phase is easy.
See all answers
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.
See all answers
 

Comparisons

KNIME vs Pentaho Business Analytics Logo
KNIME vs Pentaho Business Analytics
Compared 36% of the time
Databricks vs Pentaho Business Analytics Logo
Databricks vs Pentaho Business Analytics
Compared 18% of the time
Microsoft Power BI vs Pentaho Business Analytics Logo
Microsoft Power BI vs Pentaho Business Analytics
Compared 14% of the time
Tableau vs Pentaho Business Analytics Logo
Tableau vs Pentaho Business Analytics
Compared 10% of the time
Apache Spark vs Pentaho Business Analytics Logo
Apache Spark vs Pentaho Business Analytics
Compared 9% of the time
More Pentaho Business Analytics Competitors
Informatica PowerCenter vs SSIS Logo
Informatica PowerCenter vs SSIS
Compared 19% of the time
Talend Open Studio vs SSIS Logo
Talend Open Studio vs SSIS
Compared 12% of the time
IBM InfoSphere DataStage vs SSIS Logo
IBM InfoSphere DataStage vs SSIS
Compared 8% of the time
Oracle Data Integrator (ODI) vs SSIS Logo
Oracle Data Integrator (ODI) vs SSIS
Compared 7% of the time
dbt vs SSIS Logo
dbt vs SSIS
Compared 6% of the time
More SSIS Competitors
 

Product Reports

Buyer's Guide
Pentaho Business Analytics
April 2025
Pentaho Business Analytics reportDownload Pentaho Business Analytics product report
Buyer's Guide
SSIS
April 2025
SSIS reportDownload SSIS product report
 

Also Known As

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

Overview

Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

Hitachi Vantara

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft
 

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
Buyer's Guide
BI (Business Intelligence) Tools
March 2025
Download Free Report
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: March 2025.
DOWNLOAD NOW
849,686 professionals have used our research since 2012.

We monitor all BI (Business Intelligence) Tools 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.