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 Oct 8, 2024
 

Categories and Ranking

SSIS
Ranking in Data Integration
4th
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
72
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 December 2024, in the Data Integration category, the mindshare of SSIS is 8.8%, down from 9.5% compared to the previous year. The mindshare of Talend Open Studio is 5.8%, down from 6.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

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.
Jason Hale - PeerSpot reviewer
Intuitive interface and documentation make it simple to build jobs and APIs and logging helps pinpoint and resolve issues quickly
Talend is doing a lot of work at the moment, and it's not there yet, but the whole platform could be managed in a SaaS-type environment. You still need to have the Studio running on a virtual desktop or a PC. They will get to be able to do the whole thing inside your browser, so you don't need to install anything locally. It's down the track, and it's the nirvana that we were looking for in Boomi. But the biggest challenge they have is that the platform is so focused on the Studio for all of its development. They'll probably get there, but they have such a mature Studio client that it's a huge amount of work to get all of that functionality into a browser or SaaS platform. That's pretty much the biggest flaw with the Talend environment—being reliant on the Studio, which needed to be on a local machine. The only other thing is that you have to integrate into an API gateway. We're in Azure, so we use Microsoft Azure Gateway. It doesn't come with its own gateway, which is another sort of big plus side that we saw in Boomi. Talend isn't quite there yet with the API gateway. Other than that, it's bloody hard to find something because it just seems to be all good.

Quotes from Members

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

Pros

"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"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 was easy."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"It is easy to set up the product."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The product is easy to install and configure. It is one of the best tools for data integration."
"The most valuable features are the ETL tools."
"It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading."
"The Talend Studio connected to the Talend MDM (Master Data Management) is the most valuable feature. Talend Studio is used to create a job stream that connects to multiple data sources, matches, compares or creates a golden record for overall identification. It also has a good catalogue of objects that can be dragged and dropped for building models."
"You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality."
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields. It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool."
"The data integration aspect of the solution is excellent."
 

Cons

"I would like to see better integration with Power BI."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"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."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"This solution needs full support for real-time processing."
"Generic processes should be used instead of custom code for each table."
"Options for scaling could be improved."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"When faced with a challenge, such as the necessity to link up with an unconventional data source like the legacy Cyprus Vision database that wasn't inherently supported by Talend, I had to resort to writing Python code to establish the connection."
"The profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."
"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."
"It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them."
"Talend Open Studio's interface does not provide a good experience...I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good."
"The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it."
"Inter-version compatibility is a problem, and migration projects between versions are required."
 

Pricing and Cost Advice

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"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."
"We have an enterprise license for this solution."
"The solution is available at a lesser price than that of Informatica."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"The solution comes free of cost."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"People have to opt for a perpetual-based licensing model."
"Right now, because we're using the open-source version, there's no cost."
"It is an open-source product."
"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."
"Talend is free and you can download it."
"Price could be lower. It is getting too expensive when compared to some other solutions, which is actually a little bit concerning."
"There are many versions available and one is open-sourced which is free."
"The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price."
"We are using the free version of the tool, because the enterprise version is a little expensive."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
824,053 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
12%
Government
8%
Healthcare Company
6%
Financial Services Firm
16%
Computer Software Company
15%
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.
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
 

Learn More

 

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: November 2024.
824,053 professionals have used our research since 2012.