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

SSIS vs Talend Open Studio comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Apr 20, 2025

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

SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
74
Ranking in other categories
No ranking in other categories
Talend Open Studio
Ranking in Data Integration
5th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
50
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Data Integration category, the mindshare of SSIS is 7.4%, down from 7.7% compared to the previous year. The mindshare of Talend Open Studio is 4.4%, down from 5.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Sean Achim - PeerSpot reviewer
Building impactful organizational KPIs with ease and precision
Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.
Costin Marzea - PeerSpot reviewer
Allows you to develop your own components and can be used as an OEM
Sometimes, scalability is part of planning. It depends on what you mean by scalability. People talk a lot about it, but scalability is not always about system functionality. Sometimes, it may be planning the job you're doing. If you want to split it into several jobs or servers, you don't actually have to have it built in as a functionality. You can create a job using a loop, which runs and controls several jobs in a loop that may be controlled. Scaling should not always be part of the infrastructure based on whether the engine can scale or not. I think it's your plan or project that should scale and split, and you can define these parameters. These parameters include how many servers you want to run or how many executions you want to do on different parts of the data. It's not always an issue of the engine running. Sometimes, your database should be configured to support partitioning. The product may scale very well without partitioning, but if the basic response is very slow, you didn't solve the problem. You should solve the problems at a higher level, not just at the execution level. They should be solved at the database level and communication level, and you should have firewalls. We are trying to add to the open source the ability to generate code for containers and Kubernetes that exist in the subscription version. Once you do this, Kubernetes will take care of the scaling, so there is no problem.

Quotes from Members

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

Pros

"SSIS integrates well with SQL servers and Microsoft products."
"It is easy to set up. The deployment is also very quick."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The performance and stability are good."
"The setup was easy. All Microsoft products are easy to set up."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."
"The data integration aspect of the solution is excellent."
"A very user friendly solution."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"The drag-and-drop feature in the interface is very good."
"The solution's technical support is responsive and helpful."
"I didn't have many problems installing it. It seemed very straightforward to me."
 

Cons

"I would like to see better integration with Power BI."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Integration and the user interface are areas with certain shortcomings that require some improvements."
"The physical appearance of the product is an area of concern where improvements are required."
"The pricing could be lower. They should work to make it more affordable."
"In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot."
"The user interface could be made simpler."
"It gets the job done but it's a bit slow."
"The technical support and documentation need a lot of work to come up to standard."
"The solution should integrate with a version control system in the subscription versions to make it easy to work with and manage the version control."
"The solution should offer better integration with other products."
 

Pricing and Cost Advice

"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."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"The solution comes free of cost."
"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."
"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."
"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."
"Talend is free and you can download it."
"For Talend Open Studio, there is a need to make yearly payments towards the licensing cost. Talend Open Studio is a bit expensive, in my opinion."
"The paid version of this solution has a very high price, but even with the limitations, the Community version works fine."
"There are many versions available and one is open-sourced which is free."
"Pricing is always a challenge. It is quite an expensive model, but because the platform is so simple to use, we haven't had to purchase any additional licenses."
"It is an open-source tool which means it is a free solution."
"Pricing and licensing are fairly straightforward. It is reasonably priced and managed."
"It is an open-source product."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
862,499 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
11%
Government
8%
Manufacturing Company
6%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
8%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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...
What do you like most about SSIS?
The product's deployment phase is easy.
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.
How does Talend Open Studio compare with AWS Glue?
We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...
What do you like most about Talend Open Studio?
It is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source is very good. They have the same commercials with additional connectors. The...
 

Also Known As

SQL Server Integration Services
Open Studio
 

Overview

 

Sample Customers

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
Almerys, BF&M, Findus
Find out what your peers are saying about SSIS vs. Talend Open Studio and other solutions. Updated: July 2025.
862,499 professionals have used our research since 2012.