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.
"It is easy to set up the product."
"The performance is good."
"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 already very user-friendly and has a good dashboard."
"The interface is very user-friendly."
"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 most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"A very user friendly solution."
"The product is easy to install and configure. It is one of the best tools for data integration."
"Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good."
"The most valuable features of Talend Open Studio are customization and integration."
"The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component."
"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."
"The standout feature for me is the user-friendly nature of the components."
"It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading."
"It would be nice if you could run SSIS on other environments besides Windows."
"Video training would be a helpful addition."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The security could be improved, as it is more important in our context."
"Improvement as per customer requirements."
"The performance of this solution is not as good as other tools in the market."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"We'd like them to develop data exploration more."
"As for improvement or additional features, I would like to know how to use Java in Talend and also how to use Talend in the cloud or in big data. I would prefer to have storage directly on Talend."
"In the next release, Open Studio should include cloud storage as an input."
"It is not as visually appealing as some of the other tools."
"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."
"The server-side should be completely revamped."
"The user interface could be made simpler."
"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."
"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.