Pentaho Data Integration and Analytics vs SSIS vs TIBCO Cloud Integration comparison

The compared Hitachi Vantara and Microsoft solutions aren't in the same category. Hitachi Vantara is ranked #19 in DI , with an average rating of 7.7, and holds a 1.7% mindshare in the category. Microsoft is ranked #2 in DI , with an average rating of 7.6, and holds a 5.9% mindshare. Additionally, 94% of Hitachi Vantara users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,544 Views
1,959 Comparison Views

94% willing to recommend

SSIS

Read 75 SSIS reviews

13,499 Views
11,069 Comparison Views

80% willing to recommend

TIBCO Cloud Integration

Read 3 TIBCO Cloud Integration reviews

557 Views
195 Comparison Views

80% willing to recommend

Pentaho Data Integration an...

SSIS

TIBCO Cloud Integration

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Pentaho Data Integration and Analytics, SSIS, and TIBCO Cloud Integration based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration.

To learn more, read our detailed Data Integration Report (Updated: August 2025).

Buyer's Guide

Data Integration

August 2025

Download the complete report

Helped 867,445 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:

Mindshare comparison

Data Integration Market Share Distribution
Product	Market Share (%)
Pentaho Data Integration and Analytics	1.7%
Informatica PowerCenter	6.3%
SSIS	5.9%
Other	86.1%

Data Integration

Data Integration Market Share Distribution
Product	Market Share (%)
SSIS	5.9%
Informatica PowerCenter	6.3%
Azure Data Factory	5.6%
Other	82.2%

Data Integration

Integration Platform as a Service (iPaaS) Market Share Distribution
Product	Market Share (%)
TIBCO Cloud Integration	1.4%
Microsoft Azure Logic Apps	13.1%
Boomi iPaaS	12.4%
Other	73.1%

Integration Platform as a Service (iPaaS)

Featured Reviews

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

Transform data efficiently with rich features but there's challenges with large datasets

Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…

Read full review

Chris Farris

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

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

NarendraThota

Vice President of Technology Services at SAge IT inc

A product that is easy to install and offers good stability to users

The API part of the solution is an area in the solution where improvements are made since I see that TIBCO is currently trying to revamp its tool by focusing more on redesigning it. There was a tool called Mashery, which is an API management tool that was acquired by TIBCO. TIBCO Cloud Integration is not a user-friendly tool when it comes to the installation phase or for maintaining the systems since its architecture is really complex. I think in the UK, one of the major telecom providers for whom I had done the infrastructure setup uses TIBCO Cloud Integration. Basically, TIBCO Cloud Integration is a bit difficult to install and manage the platform, but I feel there are improvements in the tool's latest version, especially on the API management side. Instead of moving to the higher version and converting the older version of TIBCO Cloud Integration or the legacy platform covered under TIBCO, they still use it because the architecture is completely different, and the components that the product has are completely different from what the new version of the product offers, making it one of the major reasons why TIBCO is coming up with a new version of the product that will be released in the upcoming year. The legacy platform of TIBCO will run on the cloud directly. TIBCO plans to develop a unified tool that is supported on the cloud and in an on-premises environment.

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

"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."

"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."

"The abstraction is quite good."

"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."

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

"It is easy to use, install, and start working with."

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

More Pentaho Data Integration and Analytics pros

"The most important features are it works well and provides self-service BI."

"The setup is easy to use and understand."

"The data reader is the most valuable feature."

"The initial setup of this solution is very straightforward."

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

"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

"SSIS integrates well with SQL servers and Microsoft products."

More SSIS pros

"The product's initial setup phase was easy."

"I am really impressed by TIBCO's integration of any level of complexity."

"I like that it is a very good integration tool with many other things. TIBCO is very good for cloud integration"

Cons

"There is not a data quality or MDM solution in the Pentaho DI suite."

"If you develop it on MacBook, it'll be quite a hassle."

"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."

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

"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."

"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."

"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."

More Pentaho Data Integration and Analytics cons

"We'd like them to develop data exploration more."

"SSIS has a difficult learning curve when dealing with complex transformations."

"It's a legacy tool, that is nearing the end of its useful life."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"Improvement as per customer requirements."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

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

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

More SSIS cons

"TIBCO Cloud Integration is not a user-friendly tool when it comes to the installation phase or for maintaining the systems since its architecture is really complex."

"Integrations could be better. Although integration is good, we have faced some block issues."

"The deployment was rather complicated."

Pricing and Cost Advice

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

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

"The price of the regular version is not reasonable and it should be lower."

"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"

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

"The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."

"I use it because it is free. I download from their page for free. I don't have to pay for a license. With other tools, I have to pay for the licenses. That is why I use Pentaho."

More Pentaho Data Integration and Analytics pricing and cost advice

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"The solution comes free of cost."

"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 available at a lesser price than that of Informatica."

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

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

More SSIS pricing and cost advice

"We don't pay for a license."

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

867,445 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

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Computer Software Company

11%

Government

Manufacturing Company

Financial Services Firm

18%

Computer Software Company

10%

Government

Manufacturing Company

Financial Services Firm

12%

Consumer Goods Company

10%

Computer Software Company

Construction Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	17
Midsize Enterprise	16
Large Enterprise	25

By reviewers
Company Size	Count
Small Business	26
Midsize Enterprise	19
Large Enterprise	57

No data available

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

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

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

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

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

What do you like most about TIBCO Cloud Integration?

The product's initial setup phase was easy.

See all answers

What needs improvement with TIBCO Cloud Integration?

The API part of the solution is an area in the solution where improvements are made since I see that TIBCO is current...

See all answers

What is your primary use case for TIBCO Cloud Integration?

I mainly use TIBCO Cloud Integration for iPaaS platforms, SaaS connectors, and SaaS connectivity that you have. The s...

See all answers

Comparisons

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

Compared 15% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 10% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 8% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 8% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 7% of the time

More Pentaho Data Integration and Analytics Competitors

Informatica PowerCenter vs SSIS

Compared 13% of the time

Talend Open Studio vs SSIS

Compared 9% of the time

dbt vs SSIS

Compared 7% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

IBM InfoSphere DataStage vs SSIS

Compared 6% of the time

More SSIS Competitors

Informatica PowerCenter vs TIBCO Cloud Integration

Compared 26% of the time

Microsoft Azure Logic Apps vs TIBCO Cloud Integration

Compared 18% of the time

Boomi iPaaS vs TIBCO Cloud Integration

Compared 16% of the time

Oracle Integration Cloud Service vs TIBCO Cloud Integration

Compared 12% of the time

TIBCO BusinessWorks vs TIBCO Cloud Integration

Compared 11% of the time

More TIBCO Cloud Integration Competitors

Product Reports

Buyer's Guide

Pentaho Data Integration and Analytics

August 2025

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Buyer's Guide

SSIS

August 2025

Download SSIS product report

Buyer's Guide

Integration Platform as a Service (iPaaS)

August 2025

Download TIBCO Cloud Integration product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

SQL Server Integration Services

No data available

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

TIBCO Cloud Integration, built on open-source technologies, can connect cloud, on-premises, and IoT edge applications. It has a drag-and-drop and API-led design approach and a deploy-anywhere model.

TIBCO

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

NASA, T-Mobile, EagleView, Air France KLM, Caesars Entertainment

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: August 2025.

DOWNLOAD NOW

867,445 professionals have used our research since 2012.