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

SSIS vs Talend Data Management Platform comparison

Microsoft and Talend are both solutions in the Data Integration category. Microsoft is ranked #4 with an average rating of 8.0, while Talend is ranked #20 with an average rating of 7.8. Microsoft holds a 8.6% mindshare in DI, compared to Talend’s 1.6% mindshare. Additionally, 80% of Microsoft users are willing to recommend the solution, compared to 85% of Talend users who would recommend it.
SSIS
Read 71 SSIS reviews
  • 14,990 Views
  • 12,034 Comparison Views
80% willing to recommend
Talend Data Management Plat...
Read 19 Talend Data Management Platform reviews
  • 2,214 Views
  • 1,896 Comparison Views
85% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive Summary
We performed a comparison between SSIS and Talend Data Management Platform based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed SSIS vs. Talend Data Management Platform Report (Updated: November 2024).
Buyer's Guide
SSIS vs. Talend Data Management Platform
November 2024
Download the complete report
Helped 816,406 peers since 2012
 

Categories and Ranking

SSIS
Ranking in Data Integration
4th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
71
Ranking in other categories
No ranking in other categories
Talend Data Management Plat...
Ranking in Data Integration
20th
Average Rating
8.2
Reviews Sentiment
7.1
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of SSIS is 8.6%, down from 9.6% compared to the previous year. The mindshare of Talend Data Management Platform is 1.6%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Q&A Highlights

RS
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

Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
Read full review
Srinivas Mamidipalli - PeerSpot reviewer
Built for everything and packed with features but there are some monitoring limitations
Our company uses the solution to provide data integration services for customers. Most of our implementations are on-premises for large or enterprise-level customers.  We have six users with experience in both the local studio and the enterprise versions.  The solution can run on any machine and…
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

"We like that this solution includes a developer edition, free of charge, to allow for training."
"We can connect with multiple data sources easily using an external connector in SSIS."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It is easy to set up. The deployment is also very quick."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The initial setup of this solution is very straightforward."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The product's deployment phase is easy."
More SSIS pros
"I like everything about this product, but the biggest thing is the ease of use."
"We can develop our own code if we do not see the functionality we need."
"The most valuable feature is the data loading and scripting language"
"The solution is connected to various phones. It retrieves the configuration from the system."
"The most valuable features of the Talend Data Management Platform are the components."
"Talend Studio has the ability to connect to almost anything to integrate data from files, databases, web services, etc."
"The solution is very user-friendly and easy to understand."
"The features that I like the most are the simplicity of the interface, and the ability to quickly develop with a predefined component."
More Talend Data Management Platform pros
 

Cons

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"Tuning using this solution requires extensive expertise to improve performance."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The high prices attached to the product can be an area of concern where improvements are required."
"We'd like more integration capabilities."
"The solution could improve by having quicker release updates."
More SSIS cons
"The biggest challenge with Talend was its performance."
"They lack in memory capacity."
"The documentation from version to version could be more accurate."
"Once you get past the basic tools, it gets pretty complicated."
"The stability is good, but the performance is slower when I work on a huge amount of data."
"Including either XML or JSON in the next release would definitely be a good transformation. I'm not sure if Talend has that feature, but it's one of those requirements that we are working around and have to do some parsing of XML so this could make it easier."
"Performance and speed could be improved."
"The product must enhance the data quality."
More Talend Data Management Platform cons
 

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 comes free of cost."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"It would be beneficial if the solution had a less costly cloud offering."
"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."
"SSIS is fairly well-priced - I would rate it at four out of five."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
More SSIS pricing and cost advice
"The pricing is a little higher than what I had expected, but it's comparable with I-PASS competitors."
"The solution's pricing is very reasonable and half the cost of Informatica."
"The tool is cheap."
"The licensing cost is about 40,000 Euros a year."
"The price is on a per-user basis. It's a little more expensive than other tools. There aren't any additional costs beyond the standard licensing fee."
"License renewal is on a yearly basis."
"The price of the Talend Data Management Platform is reasonable. The other competing solutions are priced high. Gartner Magic Quadrant identified other solutions, such as Informatica, that are far more expensive."
report
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
816,406 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…
Read full review
 

Answers from the Community

RS
Sep 9, 2021
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
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
Read full answer
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..?
Read full answer
See all 12 answers
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
Computer Software Company
20%
Financial Services Firm
17%
Manufacturing Company
9%
Government
6%
 

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...
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
What do you like most about Talend Data Management Platform?
We can develop our own code if we do not see the functionality we need.
See all answers
What is your experience regarding pricing and costs for Talend Data Management Platform?
Talend was an open-source tool, so there were no fees associated with it.
See all answers
What needs improvement with Talend Data Management Platform?
The biggest challenge with Talend was its performance. Sometimes data cleaning from the data warehouse was very slow, and we had to restart the server to enhance performance.
See all answers
 

Comparisons

Informatica PowerCenter vs SSIS Logo
Informatica PowerCenter vs SSIS
Compared 24% of the time
Talend Open Studio vs SSIS Logo
Talend Open Studio vs SSIS
Compared 13% of the time
IBM InfoSphere DataStage vs SSIS Logo
IBM InfoSphere DataStage vs SSIS
Compared 8% of the time
Oracle Data Integrator (ODI) vs SSIS Logo
Oracle Data Integrator (ODI) vs SSIS
Compared 7% of the time
AWS Glue vs SSIS Logo
AWS Glue vs SSIS
Compared 5% of the time
More SSIS Competitors
Talend Open Studio vs Talend Data Management Platform Logo
Talend Open Studio vs Talend Data Management Platform
Compared 21% of the time
Talend Data Fabric vs Talend Data Management Platform Logo
Talend Data Fabric vs Talend Data Management Platform
Compared 17% of the time
Collibra Catalog vs Talend Data Management Platform Logo
Collibra Catalog vs Talend Data Management Platform
Compared 10% of the time
SAP Data Services vs Talend Data Management Platform Logo
SAP Data Services vs Talend Data Management Platform
Compared 8% of the time
Oracle Integration Cloud Service vs Talend Data Management Platform Logo
Oracle Integration Cloud Service vs Talend Data Management Platform
Compared 5% of the time
More Talend Data Management Platform Competitors
 

Product Reports

Buyer's Guide
SSIS
October 2024
SSIS reportDownload SSIS product report
Buyer's Guide
Talend Data Management Platform
October 2024
Talend Data Management Platform reportDownload Talend Data Management Platform product report
 

Also Known As

SQL Server Integration Services
Talend Integration Suite
 

Learn More

Microsoft
Video not available
Talend
 

Overview

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.

Talend offers robust data integration in an open and scalable architecture to maximize its value to your business. Simple, graphical tools and wizards get you up and running quickly with native code generation that streamlines development.
 

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
Accent Group, Acticall, Allianz Global Investors Distributors LLC, Car & Boat Media, Cdiscount.com
Buyer's Guide
SSIS vs. Talend Data Management Platform
November 2024
Free Report: SSIS vs. Talend Data Management Platform
Find out what your peers are saying about SSIS vs. Talend Data Management Platform and other solutions. Updated: November 2024.
DOWNLOAD NOW
816,406 professionals have used our research since 2012.
See our SSIS vs. Talend Data Management Platform 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.