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 debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The initial setup of this solution is very straightforward."
"The interface is very user-friendly."
"The technical support is very good."
"The initial setup was easy."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The setup is straightforward. It's very easy to install."
"The rapidity of integration with data may be one of the valuable features."
"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."
"The solution's technical support is responsive and helpful."
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"The initial setup was quite straightforward. The deployment took between two and three days."
"The drag-and-drop feature in the interface is very good."
"There are many architectures: hybrid, cloud, and on-prem."
"I didn't have many problems installing it. It seemed very straightforward to me."
"We'd like more integration capabilities."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Options for scaling could be improved."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The solution could improve by having quicker release updates."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"This solution needs full support for real-time processing."
"We don't get continuous replication of the data."
"The user interface could be made simpler."
"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."
"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."
"The physical appearance of the product is an area of concern where improvements are required."
"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."
"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 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, 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.