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 initial setup was easy."
"SSIS integrates well with SQL servers and Microsoft products."
"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 technical support is very good."
"It is easy to set up the product."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"We can connect with multiple data sources easily using an external connector in SSIS."
"Talend Studio has the ability to use it to ensure data quality."
"The product is easy to install and configure. It is one of the best tools for data integration."
"This product is very easy to use."
"The data integration aspect of the solution is excellent."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"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."
"The initial setup of the product was very easy."
"This solution has improved our overall time to value for data ingestion."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"We have issues with SSIS connectors while extracting data from Excel sources."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Video training would be a helpful addition."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"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."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"The pricing could be lower. They should work to make it more affordable."
"If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface."
"Talent consumes a lot of resources on my PC."
"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."
"The price for Talend Data Integration should be less expensive."
"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 needs more integrations."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good."
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.