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
5.9
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.
It has helped us save a lot of time by automating repetitive data processes and reducing manual interventions.
They didn't want to use separate ETL tools for MDM or for TMC and data preparation, which is all included in one package.
 

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
7.2
Talend Data Integration's customer service is quick, supportive, and enhanced by partnerships, though complex issues may take more time.
The first line of support needs to be more knowledgeable.
The support team is responsive when we raise issues, and they usually provide clear guidance or solutions.
The customer support for Talend Data Integration is very good; whenever I raise a ticket in the customer portal, I immediately receive an email, and follow-up communication is prompt.
 

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.9
Talend Data Integration excels in scalability, handling large data volumes and complex tasks with modular design and parallelization features.
By using features like job parallelization and modular design, we can expand our data flows without having to rebuild everything.
The scalability of Talend Data Integration is good; if it weren't scalable, it wouldn't be reliable.
 

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
7.2
Talend Data Integration is highly stable and reliable, performing consistently across projects regardless of data volume or infrastructure.
It processes large volumes of data quickly.
Once the jobs are properly designed and deployed, they run reliably without major issues.
 

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 struggles with real-time processing, high costs, complex interface, and lacks features like versioning and cloud connectors.
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.
It would be great to have more ready-to-use connectors for modern cloud and SaaS platforms.
Talend Data Integration can be improved by reducing the license cost, as it is a bit high compared to other tools, which can be a burden for small-scale companies wanting to buy a license.
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.
Talend Data Integration uses token-based pricing, affecting costs, and opinions vary on its affordability compared to other tools.
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.
My experience with Talend Data Integration's pricing, setup cost, and licensing is that it is a bit higher compared to other tools, making it not very affordable.
 

Valuable Features

SSIS provides user-friendly drag-and-drop functionality, excellent integration, scalability, cost-efficiency, and robust data transformation features.
Talend Data Integration offers versatile data handling, automation, and seamless platform integration, enhancing efficiency, accuracy, and collaborative decision-making.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
SSAS is included in the base installation of SQL Server.
By automating daily data loading processes, we reduced manual effort by around three or four hours per day, which saved roughly 60 to 80 hours per month.
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.
The best feature of Talend Data Integration is its multiple data DB components; we have almost all the components and also cloud versions, with TMC allowing us to perform data preparation and data stewardship.
 

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.5
Number of Reviews
8
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.
869,952 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 > 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
15%
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
By reviewers
Company SizeCount
Small Business2
Midsize Enterprise2
Large Enterprise4
 

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?
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.
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.
869,952 professionals have used our research since 2012.