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.
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It is easy to set up. The deployment is also very quick."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"Overall, it's a good product."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The solution is easy to use and developer friendly."
"Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others."
"The solution's technical support is responsive and helpful."
"The standout feature for me is the user-friendly nature of the components."
"The data integration aspect of the solution is excellent."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"This is a user-friendly solution that is easy to use."
"The most valuable features of Talend Open Studio are customization and integration."
"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."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"We'd like them to develop data exploration more."
"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."
"Video training would be a helpful addition."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"I would like to see better integration with Power BI."
"The stability of the solution could improve when running jobs. There can be errors when running projects but in the end, it works well and the errors do not impact the result."
"In the next release, Open Studio should include cloud storage as an input."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"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 think my biggest problem with the tool is that the errors are very hard to debug."
"Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve."
"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."
"Having additional training materials, such as a video tutorial, would be an improvement."
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.