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.3, and holds a 0.5% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 7.7, and holds a 8.9% mindshare. Additionally, 89% of Hitachi Vantara users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Pentaho Business Analytics

Read 43 Pentaho Business Analytics reviews

697 Views
524 Comparison Views

89% willing to recommend

SSIS

Read 72 SSIS reviews

13,383 Views
10,644 Comparison Views

79% willing to recommend

Pentaho Business Analytics

SSIS

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.

To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: January 2025).

Buyer's Guide

BI (Business Intelligence) Tools

January 2025

Download the complete report

Helped 831,615 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:

Categories and Ranking

Pentaho Business Analytics

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

BI (Business Intelligence) Tools (20th), Cloud Operations Analytics (4th), Reporting (14th)

SSIS

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

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 8.9% mindshare, down 9.5% since last year.

BI (Business Intelligence) Tools

Data Integration

Q&A Highlights

Philipp Scharfe

Research Assistant at a university with 10,001+ employees

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

Senior Manager, Financial Services at KPMG

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

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

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

Quotes from Members

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

Pros

"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."

"Easy to use components to create the job."

"It is robust, offers market intelligence, and utilizes modules effectively."

"The most valuable feature of Pentaho is the Tableau report."

"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."

"We were able to install it without any assistance from tech support."

"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."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."

"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The setup is straightforward. It's very easy to install."

"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

More SSIS pros

Cons

"The tool is very good, and yet it has some problems as it relies heavily on Java."

"Logging capability is needed."

"Version control would be a good addition."

"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."

"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."

"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."

"Another concern is that Pentaho is not customizable or interactive."

More Pentaho Business Analytics cons

"The performance of this solution is not as good as other tools in the market."

"It needs more integration tools, so you can connect to different sources."

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

"I would like to see better technical documentation because many times information is missing."

"The solution could improve by having quicker release updates."

"Future releases should improve the data lineage, as it currently is not good."

More SSIS cons

Pricing and Cost Advice

"Pentaho is expensive ."

"We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."

"Free and commercial versions are available."

"SSIS is fairly well-priced - I would rate it at four out of five."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"All of my clients have this product included as part of their Microsoft license."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

More SSIS pricing and cost advice

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

831,615 professionals have used our research since 2012.

Comparison Review

it_user6978

Co-Founder at Helical IT Solution (Jaspersoft, Pentaho, Talend, Kettle, DWBI, ETL, Ctools, iReport, Jasper Report)

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

Philipp Scharfe

Research Assistant at a university with 10,001+ employees

Apr 10, 2020

What is the biggest difference between SSIS and Pentaho?

See 2 answers

Rahul Sahay

Data Architect at Prolifics

Mar 18, 2020

Read full answer

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

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

26%

Computer Software Company

12%

Government

Educational Organization

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

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?

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.

See all answers

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.

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?

The solution comes free of cost.

See all answers

Comparisons

KNIME vs Pentaho Business Analytics

Compared 28% of the time

Databricks vs Pentaho Business Analytics

Compared 19% of the time

Microsoft Power BI vs Pentaho Business Analytics

Compared 15% of the time

SAP Crystal Reports vs Pentaho Business Analytics

Compared 9% of the time

Tableau vs Pentaho Business Analytics

Compared 8% of the time

More Pentaho Business Analytics Competitors

Informatica PowerCenter vs SSIS

Compared 22% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

AWS Glue vs SSIS

Compared 4% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Pentaho Business Analytics

January 2025

Download Pentaho Business Analytics product report

Buyer's Guide

SSIS

January 2025

Download 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

January 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: January 2025.

DOWNLOAD NOW

831,615 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.