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 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 reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The UI is very user-friendly."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It is easy to set up. The deployment is also very quick."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The scalability of SSIS is good."
"It's a competent product."
"It has got so many connectors. It is intuitive and easy to use."
"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 didn't have many problems installing it. It seemed very straightforward to me."
"The initial setup of the product was very easy."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"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."
"We're sold on the customization part of the solution."
"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."
"Performance could be better."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I would like to see better technical documentation because many times information is missing."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We'd like them to develop data exploration more."
"Future releases should improve the data lineage, as it currently is not good."
"It hangs a lot of the time."
"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."
"Talend should improve the log and error handling to better track the errors you find during development. Sometimes it's challenging to see what's causing an issue, and tracking that on Talend is complicated."
"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."
"Technical support and customer service need to be improved."
"The price for Talend Data Integration should be less expensive."
"The product could be more intuitive."
"I think my biggest problem with the tool is that the errors are very hard to debug."
"Talent consumes a lot of resources on my PC."
"It is not as visually appealing as some of the other tools."
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, AWS Glue and Informatica PowerCenter. 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.