We performed a comparison between Azure Data Factory 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: Azure Data Factory has an edge over Talend in this comparison. Most Azure Data Factory reviewers feel that it is reasonably priced when compared with Talend.
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"We have been using drivers to connect to various data sets and consume data."
"The solution is okay."
"The security of the agent that is installed on-premises is very good."
"ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"One advantage of Azure Data Factory is that it's fast, unlike SSIS and other on-premise tools. It's also very convenient because it has multiple connectors. The availability of native connectors allows you to connect to several resources to analyze data streams."
"What I like best about Azure Data Factory is that it allows you to create pipelines, specifically ETL pipelines. I also like that Azure Data Factory has connectors and solves most of my company's problems."
"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."
"The data integration aspect of the solution is excellent."
"The product is easy to install and configure. It is one of the best tools for data integration."
"I didn't have many problems installing it. It seemed very straightforward to me."
"The most valuable features of Talend Open Studio are customization and integration."
"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."
"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."
"A helpful feature for us is the integration with NoSQL databases."
"Azure Data Factory's pricing in terms of utilization could be improved."
"The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."
"I have not found any real shortcomings within the product."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"Azure Data Factory uses many resources and has issues with parallel workflows."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"The solution needs to be more connectable to its own services."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve."
"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."
"In the next release, Open Studio should include cloud storage as an input."
"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."
"I think my biggest problem with the tool is that the errors are very hard to debug."
"The physical appearance of the product is an area of concern where improvements are required."
"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."
"It is complicated to understand the configuration process for email components."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Talend Open Studio is ranked 5th in Data Integration with 48 reviews. Azure Data Factory is rated 8.0, while Talend Open Studio is rated 8.0. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". 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". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and FME, whereas Talend Open Studio is most compared with SSIS, IBM InfoSphere DataStage, Talend Data Fabric, Talend Data Management Platform and FME. See our Azure Data Factory 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.