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 performance and stability are good."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"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."
"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."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The UI is very user-friendly."
"The best thing I have found with Talend Open Studio is their major support for the lookups."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good."
"Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others."
"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 is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source is very good. They have the same commercials with additional connectors. The graphical design environment is also very easy."
"This is a user-friendly solution that is easy to use."
"The most valuable features are the ETL tools."
"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."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"The creation of the measure in the DAC's model could be improved."
"This solution needs full support for real-time processing."
"The solution could improve by having quicker release updates."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"We'd like more integration capabilities."
"The price for Talend Data Integration should be less expensive."
"The user interface could be made simpler."
"It gets the job done but it's a bit slow."
"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."
"The solution needs more integrations."
"The product could be more intuitive."
"The solution should offer better integration with other products."
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.