We performed a comparison between SSIS and Talend Open Studio based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Talend has a slight edge over SSIS in this comparison. According to its users, it has better integration options than SSIS.
"The solution is easy to use and developer friendly."
"The setup is straightforward. It's very easy to install."
"SSIS is easy to use."
"The interface is very user-friendly."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"It is easy to set up the solution."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"Talend Studio has the ability to use it to ensure data quality."
"This product is very easy to use."
"The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."
"It is user-friendly and the interface is good."
"We're sold on the customization part of the solution."
"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 graphical design environment is also very easy."
"A helpful feature for us is the integration with NoSQL databases."
"The drag-and-drop feature in the interface is very good."
"Video training would be a helpful addition."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The security could be improved, as it is more important in our context."
"It would be nice if you could run SSIS on other environments besides Windows."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The physical appearance of the product is an area of concern where improvements are required."
"It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git."
"We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features."
"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."
"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."
"I think my biggest problem with the tool is that the errors are very hard to debug."
"There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources."
"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."
SSIS is ranked 2nd in Data Integration with 69 reviews while Talend Open Studio is ranked 5th in Data Integration with 48 reviews. SSIS is rated 7.6, while Talend Open Studio is rated 8.0. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of Talend Open Studio writes "Intuitive interface and documentation make it simple to build jobs and APIs and logging helps pinpoint and resolve issues quickly". SSIS is most compared with Informatica PowerCenter, IBM InfoSphere DataStage, Oracle Data Integrator (ODI), AWS Glue and Azure Data Factory, whereas Talend Open Studio is most compared with IBM InfoSphere DataStage, Talend Data Fabric, Talend Data Management Platform, Informatica PowerCenter and AWS Glue. See our SSIS vs. Talend Open Studio 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.