Pentaho Data Integration and Analytics vs SSIS comparison

Hitachi Vantara and Microsoft are both solutions in the Data Integration category. Hitachi Vantara is ranked #24 with an average rating of 7.7, while Microsoft is ranked #4 with an average rating of 7.7. Hitachi Vantara holds a 1.4% mindshare in DI, compared to Microsoft’s 7.9% mindshare. Additionally, 94% of Hitachi Vantara users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,330 Views
1,055 Comparison Views

94% willing to recommend

SSIS

Read 72 SSIS reviews

13,383 Views
10,644 Comparison Views

79% willing to recommend

Pentaho Data Integration an...

SSIS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

Pentaho Data Integration and Analytics and SSIS are competitors in the field of data integration solutions. Based on the available data, SSIS appears to have the upper hand due to its strong integration with Microsoft products and exceptional enterprise deployment capabilities.

Features: Pentaho Data Integration and Analytics is known for its ease of use, support for multiple data sources, and a robust graphical interface. It excels in providing comprehensive capabilities such as big data support and rapid development cycles, with a user-friendly GUI and extensive functionality. In contrast, SSIS is recognized for its seamless integration with Microsoft products, extensive scripting capabilities, scalability, and high performance, making it ideal for enterprise-level deployments. It offers beneficial features for complex data transformations.

Room for Improvement: Pentaho users seek better performance with large datasets, expanded Hadoop utilities support, and improved logging. There is also a need for enhanced error handling and repository management. On the other hand, SSIS users suggest improvements in handling various data sources, better integration, and advanced real-time processing capabilities, with a demand for more native connectors and enhanced debugging features.

Ease of Deployment and Customer Service: Pentaho Data Integration can be flexibly deployed across diverse environments, including on-premises and hybrid clouds, catering to various business needs. While community and enterprise support are available, response times can vary. SSIS, primarily deployed on-premises, offers easy integration within Microsoft ecosystems. Its customer service and technical support receive high ratings, providing reliable enterprise-level assistance.

Pricing and ROI: Pentaho offers competitive pricing with its free Community Edition and subscription-based Enterprise Edition, providing significant ROI through reduced ETL development time and cost savings, especially for open-source users. SSIS, included with SQL Server licenses, offers value through its integration with the Microsoft stack, presenting a favorable pricing model for enterprises already within the Microsoft ecosystem, thus achieving cost-effective data integration solutions.

To learn more, read our detailed Pentaho Data Integration and Analytics vs. SSIS Report (Updated: January 2025).

Buyer's Guide

Pentaho Data Integration and Analytics vs. SSIS

January 2025

Download the complete report

Helped 832,138 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 Data Integration an...

Ranking in Data Integration

24th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

SSIS

Ranking in Data Integration

4th

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.4%, up from 0.5% compared to the previous year. The mindshare of SSIS is 7.9%, down from 8.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Q&A Highlights

RajneeshShukla

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

Sep 09, 2021

Which ETL tool would you recommend to populate data from OLTP to OLAP?

We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator). But OLAP exporting wasn't in our scope until now.

See all answers

Featured Reviews

Ryan Ferdon

Senior Data Engineer at Burgiss

Low-code makes development faster than with Python, but there were caching issues

If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was. It was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.

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

"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."

"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."

"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."

"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."

"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."

"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."

"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."

"The solution has a free to use community version."

More Pentaho Data Integration and Analytics pros

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"The simplicity of the solution is great. The solution also offers excellent integration."

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

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

"The script component is very powerful, things that you cannot normally do, is feasible through C#."

"We can connect with multiple data sources easily using an external connector in SSIS."

"It has good data integration and good processes."

More SSIS pros

Cons

"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."

"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."

"I would like to see more improvements with AS400 DB2."

"One thing that I don't like, just a little, is the backward compatibility."

"Should provide additional control for the data warehouse"

"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."

"In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud."

"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."

More Pentaho Data Integration and Analytics cons

"It would be nice if you could run SSIS on other environments besides Windows."

"The creation of the measure in the DAC's model could be improved."

"Tuning using this solution requires extensive expertise to improve performance."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

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

"Video training would be a helpful addition."

"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."

"This solution needs full support for real-time processing."

More SSIS cons

Pricing and Cost Advice

"There is a good open source option (Community Edition)."

"I believe the pricing of the solution is more affordable than the competitors"

"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."

"There was a cost analysis done and Pentaho did favorably in terms of cost."

"You don't need the Enterprise Edition, you can go with the Community Edition. That way you can use it for free and, for free, it's a pretty good tool to use."

"I primarily work on the Community Version, which is available to use free of charge."

"I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

More Pentaho Data Integration and Analytics pricing and cost advice

"People have to opt for a perpetual-based licensing model."

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

"The solution is available at a lesser price than that of Informatica."

"This solution is included with the MSSQL server package."

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

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

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

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

832,138 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Answers from the Community

RajneeshShukla

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

Sep 9, 2021

Which ETL tool would you recommend to populate data from OLTP to OLAP?

There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs There are many other pure ETL ...

2 out of 12 answers

Stefan Schäfer

CEO / Owner with 51-200 employees

Apr 6, 2020

We usually use Talend. Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719

Read full answer

RajneeshShukla

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

Apr 7, 2020

Thanks Stefan !!! May I know if Talend is opensource /free ? It is available in all 3 editions - basic , standard end enterprise? it is capable to read data from all heterogeneous system like various types of data bases and files etc..?

Read full answer

See all 12 answers

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

14%

Government

Comms Service Provider

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

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

See all answers

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

See all answers

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

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

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 18% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 11% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 8% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 7% of the time

AWS Glue vs Pentaho Data Integration and Analytics

Compared 7% of the time

More Pentaho Data Integration and Analytics Competitors

Informatica PowerCenter vs SSIS

Compared 21% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

Ab Initio Co>Operating System vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Pentaho Data Integration and Analytics

January 2025

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Buyer's Guide

SSIS

January 2025

Download SSIS product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

SQL Server Integration Services

Overview

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

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

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

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

Pentaho Data Integration and Analytics vs. SSIS

January 2025

Free Report: Pentaho Data Integration and Analytics vs. SSIS

Find out what your peers are saying about Pentaho Data Integration and Analytics vs. SSIS and other solutions. Updated: January 2025.

DOWNLOAD NOW

832,138 professionals have used our research since 2012.

See our Pentaho Data Integration and Analytics vs. SSIS report.

See our list of best Data Integration vendors.

We monitor all Data Integration 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.