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 #19 in BIT , with an average rating of 8.5, and holds a 0.5% mindshare in the category. Microsoft is ranked #2 in DI , with an average rating of 7.6, and holds a 5.9% mindshare. Additionally, 87% of Hitachi Vantara users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.
Pentaho Business Analytics
Read 45 Pentaho Business Analytics reviews
  • 1,567 Views
  • 595 Comparison Views
87% willing to recommend
SSIS
Read 75 SSIS reviews
  • 13,499 Views
  • 11,069 Comparison Views
80% 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, SAP and others in BI (Business Intelligence) Tools.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: August 2025).
Buyer's Guide
BI (Business Intelligence) Tools
August 2025
Download the complete report
Helped 867,676 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.4
Pentaho Business Analytics mixed ROI perceptions highlight efficiency gains but unclear returns compared to competitors like QlikView and Tableau.
Sentiment score
7.6
SSIS is praised for cost-effective, efficient data management with significant savings, but users may switch with more budget.
No quotes available
For more quotes and insights, download the Pentaho Business Analytics report
The tool has made us tremendously more efficient and saved us a significant amount of money.
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.5
Pentaho Business Analytics receives mixed reviews for customer support, with users relying heavily on forums and community assistance.
Sentiment score
6.0
Users rely on forums for SSIS issues; Microsoft support is mixed, with some finding response times and quality lacking.
No quotes available
For more quotes and insights, download the Pentaho Business Analytics report
The first line of support needs to be more knowledgeable.
For more quotes and insights, download the SSIS report
 

Scalability Issues

Sentiment score
7.0
Pentaho Business Analytics is scalable with good performance but occasionally needs professional help for complex data handling.
Sentiment score
6.7
SSIS is scalable and excels in data integration, but efficiency varies with large datasets and real-time processing challenges.
 

Stability Issues

Sentiment score
6.5
Pentaho Business Analytics is stable but may face Java caching issues, impacting performance and requiring careful cache management.
Sentiment score
7.4
SSIS is generally praised for stability and reliability, though some users note issues and the need for strong infrastructure.
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 Business Analytics lacks an intuitive interface, robust integration, self-service features, and requires technical expertise, limiting usability.
SSIS needs improved scalability, data source support, real-time processing, cloud integration, and user-friendly interfaces for better performance.
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
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
The logging capabilities could be improved, particularly for error logging.
For more quotes and insights, download the SSIS report
AR
Sean Achim - PeerSpot reviewerAlbert Lacerda - PeerSpot reviewerChris Farris - PeerSpot reviewer
 

Setup Cost

Enterprise buyers find the free Pentaho Community Edition cost-effective, while the Enterprise Edition offers value with support and features.
SSIS offers a cost-effective ETL solution for enterprises using Microsoft, enhancing affordability by integrating with SQL Server licenses.
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.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
For more quotes and insights, download the SSIS report
AR
Albert Lacerda - PeerSpot reviewerChris Farris - PeerSpot reviewer
 

Valuable Features

Pentaho Business Analytics provides easy data integration, customizable dashboards, extensive connectivity, and supports efficient data transformation and delivery.
SSIS provides user-friendly drag-and-drop functionality, excellent integration, scalability, cost-efficiency, and robust data transformation features.
It is a stable product, and it can handle large datasets.
For more quotes and insights, download the Pentaho Business Analytics report
It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
SSAS is included in the base installation of SQL Server.
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
AR
Chris Farris - PeerSpot reviewerSean Achim - PeerSpot reviewerAlbert Lacerda - PeerSpot reviewer
 

Categories and Ranking

Pentaho Business Analytics
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
45
Ranking in other categories
BI (Business Intelligence) Tools (19th), Cloud Operations Analytics (2nd), Reporting (12th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
75
Ranking in other categories
Data Integration (2nd)
 

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 5.9% mindshare, down 7.7% since last year.
BI (Business Intelligence) Tools Market Share Distribution
ProductMarket Share (%)
Pentaho Business Analytics0.5%
Microsoft Power BI14.5%
Tableau Enterprise11.0%
Other74.0%
BI (Business Intelligence) Tools
Data Integration Market Share Distribution
ProductMarket Share (%)
SSIS5.9%
Informatica PowerCenter6.3%
Azure Data Factory5.6%
Other82.2%
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

Mir Gulzar Ahmed - PeerSpot reviewer
Excels in handling unstructured data, helping organizations navigate through different storage systems
Pentaho can help organizations by providing them an insight of their unstructured data using one platform(Pentaho Business Analytics). The features are almost identical to other BIS platforms but to me, customers can benefit as it has a community version with most of its Enterprise features. It also has a free limited-period trial version. The other feature that I would like to share here is, that users have access to a complete spectrum of data from different sources with the system’s adaptive big data layer, which takes the source of the data into account. The software is built on an open architecture and can be integrated with multiple systems. However, Pentaho Data Integration and Analytics has been acquired by HDS which offers an Enterprise edition for organizations that also need to meet product compliance.
Read full review
Chris Farris - PeerSpot reviewer
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
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
867,676 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
14%
Computer Software Company
9%
Educational Organization
8%
Manufacturing Company
8%
Financial Services Firm
18%
Computer Software Company
10%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business22
Midsize Enterprise7
Large Enterprise15
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise19
Large Enterprise57
 

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 offers the best value for money. While improvements can be made in some areas, particularly with more cloud-based solutions, it is not in their domain because they do not...
See all answers
What needs improvement with Pentaho Business Analytics?
From an integration perspective, Pentaho Business Analytics is not the best tool on the market. There are things done by Apache that are better, though I am not the one implementing them, so this i...
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 Business Hub vs Pentaho Business Analytics Logo
KNIME Business Hub vs Pentaho Business Analytics
Compared 45% of the time
Databricks vs Pentaho Business Analytics Logo
Databricks vs Pentaho Business Analytics
Compared 16% of the time
Microsoft Power BI vs Pentaho Business Analytics Logo
Microsoft Power BI vs Pentaho Business Analytics
Compared 13% of the time
Tableau Enterprise vs Pentaho Business Analytics Logo
Tableau Enterprise vs Pentaho Business Analytics
Compared 9% of the time
Apache Spark vs Pentaho Business Analytics Logo
Apache Spark vs Pentaho Business Analytics
Compared 8% of the time
More Pentaho Business Analytics Competitors
Informatica PowerCenter vs SSIS Logo
Informatica PowerCenter vs SSIS
Compared 13% of the time
Talend Open Studio vs SSIS Logo
Talend Open Studio vs SSIS
Compared 9% of the time
dbt vs SSIS Logo
dbt vs SSIS
Compared 7% of the time
Oracle Data Integrator (ODI) vs SSIS Logo
Oracle Data Integrator (ODI) vs SSIS
Compared 7% of the time
IBM InfoSphere DataStage vs SSIS Logo
IBM InfoSphere DataStage vs SSIS
Compared 6% of the time
More SSIS Competitors
 

Product Reports

Buyer's Guide
Pentaho Business Analytics
August 2025
Pentaho Business Analytics reportDownload Pentaho Business Analytics product report
Buyer's Guide
SSIS
August 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
August 2025
Download Free Report
Find out what your peers are saying about Microsoft, Salesforce, SAP and others in BI (Business Intelligence) Tools. Updated: August 2025.
DOWNLOAD NOW
867,676 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.