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's saved time using visualization descriptions."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"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."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The technical support is very good."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"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."
"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."
"We're able to handle large amounts of data with ease."
"We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate."
"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."
"Talend is significantly easier to use."
"The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component."
"The rapidity of integration with data may be one of the valuable features."
"The standout feature for me is the user-friendly nature of the components."
"The high prices attached to the product can be an area of concern where improvements are required."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Improvement as per customer requirements."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"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."
"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."
"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 terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM."
"Talend Open Studio is in Java language, and right now, you can only use the debug functionality in Java. I see that people who know programming languages other than Java currently face difficulties."
"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 security features could be improved."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"The profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."
"The price for Talend Data Integration should be less expensive."
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.