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 most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The UI is very user-friendly."
"The performance is good."
"The scalability of SSIS is good."
"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 script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good."
"The solution's technical support is responsive and helpful."
"Talend Studio has the ability to use it to ensure data quality."
"This is a user-friendly solution that is easy to use."
"A helpful feature for us is the integration with NoSQL databases."
"The initial setup was quite straightforward. The deployment took between two and three days."
"We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"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."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"I would like to see better integration with Power BI."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"Performance could be better."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"The product could be more intuitive."
"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 user interface could be made simpler."
"The solution needs more integrations."
"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 security features could be improved."
"If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface."
SSIS is ranked 2nd in Data Integration with 69 reviews while Talend Open Studio is ranked 5th in Data Integration with 47 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 "An open-source ETL tool, when deployed on-premises, requiring an easy installation phase". 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, AWS Glue, Talend Data Management Platform and Azure Data Factory. 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.