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 product's deployment phase is easy."
"SSIS' most valuable feature is its reporting services."
"It's already very user-friendly and has a good dashboard."
"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."
"SSIS integrates well with SQL servers and Microsoft products."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"We're able to handle large amounts of data with ease."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"This solution has improved our overall time to value for data ingestion."
"The initial setup of the product was very easy."
"It has got so many connectors. It is intuitive and easy to use."
"The most valuable features are the ETL tools."
"You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality."
"The rapidity of integration with data may be one of the valuable features."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"I would like to see more features in terms of the integration with Azure Data Factory."
"It hangs a lot of the time."
"We'd like them to develop data exploration more."
"Generic processes should be used instead of custom code for each table."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"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."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"The product could be more intuitive."
"It is complicated to understand the configuration process for email components."
"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 the next release, Open Studio should include cloud storage as an input."
"We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features."
"When faced with a challenge, such as the necessity to link up with an unconventional data source like the legacy Cyprus Vision database that wasn't inherently supported by Talend, I had to resort to writing Python code to establish the connection."
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, 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.