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 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."
"We can connect with multiple data sources easily using an external connector in SSIS."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The data reader is the most valuable feature."
"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 is easy to set up the solution."
"The most important features are it works well and provides self-service BI."
"It's saved time using visualization descriptions."
"The initial setup was quite straightforward. The deployment took between two and three days."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"The best thing I have found with Talend Open Studio is their major support for the lookups."
"This product is very easy to use."
"This is a user-friendly solution that is easy to use."
"The standout feature for me is the user-friendly nature of the components."
"The rapidity of integration with data may be one of the valuable features."
"The most valuable feature for me when it comes to this solution is that it's easy to use."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Video training would be a helpful addition."
"I would like to see better technical documentation because many times information is missing."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The user interface could be made simpler."
"In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot."
"The solution should offer better integration with other products."
"Talent consumes a lot of resources on my PC."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"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 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."
"In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised."
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.