SSIS vs Talend Data Management Platform comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Number of Reviews
69
Ranking in other categories
No ranking in other categories
Talend Data Management Plat...
Ranking in Data Integration
21st
Average Rating
8.2
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Market share comparison

As of June 2024, in the Data Integration category, the market share of SSIS is 9.8% and it decreased by 9.9% compared to the previous year. The market share of Talend Data Management Platform is 1.8% and it increased by 27.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
Unique Categories:
No other categories found
No other categories found
 

Q&A Highlights

RS
Sep 09, 2021
 

Featured Reviews

BobAmy - PeerSpot reviewer
Aug 21, 2023
Robust and does a good job of handling overload conditions
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. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.
SK
Dec 12, 2023
A scalable tool that enables users to write codes and develop custom functionalities
The solution is based on Java. It connects to all available data sources, like APIs, Workday, Salesforce, relational database management systems, Azure, Google Cloud, and AWS. It can do big data processing. It also does batch processing and streaming. It hosts APIs, too. We can consume the queuing…

Quotes from Members

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

Pros

"The initial setup was easy."
"The UI is very user-friendly."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The basic tools are easy to pick up and understand."
"They're very competitive in terms of performance, which is a good selling point. It has very rich features. It provides a very rich feature set in the application."
"Talend Studio has the ability to connect to almost anything to integrate data from files, databases, web services, etc."
"I like the way that you can use the context variables, and how you can work those context variables to give you values and settings for every development environment, such as PROD, TEST, and DEV."
"The availability of connectors is great."
"The most valuable features of the Talend Data Management Platform are the components."
"The most valuable feature is integration."
"The solution is very user-friendly and easy to understand."
 

Cons

"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."
"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."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"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."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"The high prices attached to the product can be an area of concern where improvements are required."
"It's a legacy tool, that is nearing the end of its useful life."
"The sales and market department could improve the Talend Data Management Platform."
"I would like to sync a project and do an upload from that current version, and then from GitLab, be able to download the latest one."
"The stability is good, but the performance is slower when I work on a huge amount of data."
"I'd be interested in seeing the running of Python programs and transformations from within the studio itself."
"The solution's memory sometimes bottlenecks and that can be challenging."
"They lack in memory capacity."
"I think they should drive toward AI and machine learning. They could include a machine-learning algorithm for the deduplication."
"Performance and speed could be improved."
 

Pricing and Cost Advice

"All of my clients have this product included as part of their Microsoft license."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"This solution is included with the MSSQL server package."
"Our license with SSIS is annual."
"It would be beneficial if the solution had a less costly cloud offering."
"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."
"SSIS' licensing is a little high, but it gives good value for money."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"The tool is cheap."
"The pricing is a little higher than what I had expected, but it's comparable with I-PASS competitors."
"The licensing cost is about 40,000 Euros a year."
"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."
"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."
"The solution's pricing is very reasonable and half the cost of Informatica."
"License renewal is on a yearly basis."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
787,061 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
12%
Government
7%
Healthcare Company
7%
Computer Software Company
19%
Financial Services Firm
15%
Manufacturing Company
9%
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?
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.
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.
What is your experience regarding pricing and costs for Talend Data Management Platform?
The product is cost-effective. If you have to do it with Talend or any other informational tools, it's very expensive. It has a very flexible licensing cost. It's a SaaS-based model. It costs aroun...
 

Also Known As

SQL Server Integration Services
Talend Integration Suite
 

Learn More

Video not available
 

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
Accent Group, Acticall, Allianz Global Investors Distributors LLC, Car & Boat Media, Cdiscount.com
Find out what your peers are saying about SSIS vs. Talend Data Management Platform and other solutions. Updated: May 2024.
787,061 professionals have used our research since 2012.