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

SSIS vs Talend Data Integration comparison

 

Comparison Buyer's Guide

Executive Summary

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
7.6
SSIS is praised for cost-effective, efficient data management with significant savings, but users may switch with more budget.
Sentiment score
1.0
Talend Data integration streamlines processing, boosts efficiency, saves time, is scalable, user-friendly, improves accuracy, and adds business value.
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.
 

Customer Service

Sentiment score
6.0
Users rely on forums for SSIS issues; Microsoft support is mixed, with some finding response times and quality lacking.
Sentiment score
6.0
Talend Data integration's support is responsive and helpful, though some users face delays and desire quicker response times for complex issues.
The first line of support needs to be more knowledgeable.
 

Scalability Issues

Sentiment score
6.7
SSIS is scalable and excels in data integration, but efficiency varies with large datasets and real-time processing challenges.
Sentiment score
6.2
Talend Data Integration is praised for scalability, efficient large data handling, seamless system integration, and reliable performance across business scales.
 

Stability Issues

Sentiment score
7.4
SSIS is generally praised for stability and reliability, though some users note issues and the need for strong infrastructure.
Sentiment score
6.8
Users are satisfied with Talend Data Integration's stability, consistently describing it as reliable and free from disruptions or issues.
It processes large volumes of data quickly.
 

Room For Improvement

SSIS needs improved scalability, data source support, real-time processing, cloud integration, and user-friendly interfaces for better performance.
Talend Data Integration needs bug fixes, enhanced support, local data centers, and improved scheduling and real-time processing capabilities.
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.
Regarding ETL, Talend Data Integration is great, but concerning real-time data processing, people are not really sure about Talend Data Integration or might not know how it provides such types of flexibilities.
 

Setup Cost

SSIS offers a cost-effective ETL solution for enterprises using Microsoft, enhancing affordability by integrating with SQL Server licenses.
<p>Talend Data Integration offers scalable annual pricing, praised for cost-effectiveness but advanced features may increase costs, with strong support.</p>
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.
 

Valuable Features

SSIS provides user-friendly drag-and-drop functionality, excellent integration, scalability, cost-efficiency, and robust data transformation features.
Talend Data Integration offers advanced features, seamless Java integration, and economical solutions, enhancing compatibility, collaboration, and ease for developers.
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.
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.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Flexibility is a key feature I appreciate about Talend Data Integration, especially the integration of Java within it and the ease of integrating with multiple source repositories such as GitHub and Bitbucket.
 

Categories and Ranking

SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
75
Ranking in other categories
Data Integration (2nd)
Talend Data Integration
Average Rating
8.2
Reviews Sentiment
6.0
Number of Reviews
6
Ranking in other categories
Cloud Data Integration (19th), Integration Platform as a Service (iPaaS) (14th)
 

Q&A Highlights

RS
Sep 09, 2021
 

Featured Reviews

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.
Mubahir Rashid - PeerSpot reviewer
Offers flexibility and ease of integration while needing improvements in data flow management
I haven't worked with Talend Data Integration on real-time data processing; I have only seen the streaming component, and I think it can accommodate limited streaming, not at the level of larger big data platforms. Regarding ETL, Talend Data Integration is great, but concerning real-time data processing, people are not really sure about Talend Data Integration or might not know how it provides such types of flexibilities. I haven't worked on this aspect in Talend Data Integration, so this is definitely an area where it lacks. To elaborate on one drawback, if I am designing something in Talend Data Integration, I cannot backtrack in the flow. For example, if I read data from a source and transform it before applying complex aggregation in the third step, I cannot join this data with the second step. If I need to go back, I will have to use a memory component, or if I need to avoid memory consumption, I will have to read the data from step one again to join it with the third step.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
867,370 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…
 

Answers from the Community

RS
Sep 9, 2021
Sep 9, 2021
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 &gt; 100K€. Works with transaction logs There are many other pure ETL ...
2 out of 12 answers
SS
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
RS
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..?
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
10%
Government
8%
Healthcare Company
6%
Financial Services Firm
16%
Computer Software Company
11%
Comms Service Provider
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise19
Large Enterprise57
No data available
 

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.
What do you like most about Talend Data integration?
The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets.
What is your experience regarding pricing and costs for Talend Data integration?
The product pricing is considered very good, especially compared to other data integration tools in the market.
What needs improvement with Talend Data integration?
I haven't worked with Talend Data Integration on real-time data processing; I have only seen the streaming component, and I think it can accommodate limited streaming, not at the level of larger bi...
 

Also Known As

SQL Server Integration Services
Talend Cloud Integration, Talend Integration Cloud, Talend Cloud Remote Engine for AWS
 

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
ACCOR, ADR, L'OREAL, AstraZeneca
Find out what your peers are saying about SSIS vs. Talend Data Integration and other solutions. Updated: September 2025.
867,370 professionals have used our research since 2012.