--- title: Azure Data Factory Reviews meta_title: 'Azure Data Factory Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 100 reviews by the users' company size, role or industry to find out how Azure Data Factory works for a business like yours. aggregate_rating: rating_value: 4.6 review_count: 100 scale: '5' date_modified: '2026-07-17' parent_category: name: Cloud Data Integration url: https://www.g2.com/categories/cloud-data-integration --- # Azure Data Factory Reviews **Vendor:** Microsoft **Category:** [Big Data Integration Platforms](https://www.g2.com/categories/big-data-integration-platforms) **Average Rating:** 4.6/5.0 **Total Reviews:** 100 ## About Azure Data Factory Azure Data Factory (ADF) is a fully managed, serverless data integration service designed to simplify the process of ingesting, preparing, and transforming data from diverse sources. It enables organizations to construct and orchestrate Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) workflows in a code-free environment, facilitating seamless data movement and transformation across on-premises and cloud-based systems. Key Features and Functionality: - Extensive Connectivity: ADF offers over 90 built-in connectors, allowing integration with a wide array of data sources, including relational databases, NoSQL systems, SaaS applications, APIs, and cloud storage services. - Code-Free Data Transformation: Utilizing mapping data flows powered by Apache Spark™, ADF enables users to perform complex data transformations without writing code, streamlining the data preparation process. - SSIS Package Rehosting: Organizations can easily migrate and extend their existing SQL Server Integration Services (SSIS) packages to the cloud, achieving significant cost savings and enhanced scalability. - Scalable and Cost-Effective: As a serverless service, ADF automatically scales to meet data integration demands, offering a pay-as-you-go pricing model that eliminates the need for upfront infrastructure investments. - Comprehensive Monitoring and Management: ADF provides robust monitoring tools, allowing users to track pipeline performance, set up alerts, and ensure efficient operation of data workflows. Primary Value and User Solutions: Azure Data Factory addresses the complexities of modern data integration by providing a unified platform that connects disparate data sources, automates data workflows, and facilitates advanced data transformations. This empowers organizations to derive actionable insights from their data, enhance decision-making processes, and accelerate digital transformation initiatives. By offering a scalable, cost-effective, and code-free environment, ADF reduces the operational burden on IT teams and enables data engineers and business analysts to focus on delivering value through data-driven strategies. ## Azure Data Factory Pros & Cons **What users like:** - Users love the **seamless data integration** capabilities of Azure Data Factory, simplifying complex workflows and enhancing productivity. (7 reviews) - Users value the **ease of use** of Azure Data Factory, simplifying data integration with its low-code visual interface. (7 reviews) - Users appreciate the **seamless connectivity** of Azure Data Factory for integrating diverse data sources with minimal coding. (6 reviews) - Users value the **seamless integration capabilities** of Azure Data Factory, simplifying complex data workflows across various sources. (6 reviews) - Users value the **scalability** of Azure Data Factory, enabling them to effortlessly manage and integrate vast data sources. (5 reviews) - Users appreciate the **low code interface and integration flexibility** of Azure Data Factory for its usability and efficiency. (5 reviews) - Users benefit from the **automation capabilities** of Azure Data Factory, simplifying complex data integration and transformation tasks. (4 reviews) - Easy Integrations (4 reviews) - Flexibility (4 reviews) - Connectors Quantity (3 reviews) **What users dislike:** - Users find the **debugging difficulty** in Azure Data Factory frustrating, particularly for complex pipelines and troubleshooting failures. (5 reviews) - Users find **difficult debugging** with Azure Data Factory, often facing challenges in troubleshooting complex pipelines effectively. (4 reviews) - Users find Azure Data Factory to be **expensive** due to unpredictable costs linked to pipeline executions and data movements. (4 reviews) - Users find the **feature limitations** of Azure Data Factory hinder their ability to efficiently monitor and integrate with Power BI. (4 reviews) - Users find Azure Data Factory's **complexity and limitations** challenging, particularly with debugging and managing intricate workflows. (3 reviews) - Users find **complex usability** in Azure Data Factory, particularly in debugging and managing intricate pipelines. (3 reviews) - Users find the **error reporting** in Azure Data Factory unclear, making troubleshooting more challenging and time-consuming. (3 reviews) - Limitations (3 reviews) - Users find **complex processes** in Azure Data Factory overwhelming, particularly when debugging and managing intricate workflows. (2 reviews) - Users often experience **connectivity issues** with Azure Data Factory, leading to frustrating downtime during service outages. (2 reviews) ## Azure Data Factory Reviews ### 1. Review on Azure Data Factory **Rating:** 5.0/5.0 stars **Reviewed by:** Arijit C. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 09, 2022 **What do you like best about Azure Data Factory?** It helps to orchestrate different jobs through pipeline creation. Also, various environments can be connected easily through ADF, and the no code environment makes it easier. **What do you dislike about Azure Data Factory?** Azure Data Factory doesnt allow you to send customized mails based on the failed activity. If any activity of a pipeline fails, it will send a mail that the pipeline has failed, but doesnt mention which activity has failed. **What problems is Azure Data Factory solving and how is that benefiting you?** Its helps us to schedule jobs based on a specific time or event based. It also helps to orchestrate various activities and thus removies the manual dependency a lot. ### 2. Azure Data factory : one of the best ETL tools **Rating:** 4.5/5.0 stars **Reviewed by:** Prabhat R. | Cloud Engineer I, Enterprise (> 1000 emp.) **Reviewed Date:** April 22, 2022 **What do you like best about Azure Data Factory?** The best part about the azure data factory is the UI, where one can design complex ETL pipelines without writing single line of code and can simply achieve it by drag-n-drop different activities. Also the updates of feature improvement and new activities are also very frequent, which eventually increses the craze between users for this service. **What do you dislike about Azure Data Factory?** There are some limitatons in ADF like you cannot perform nested control statements directly. Apart from that in mapping data flows for upsert, one need to select both upsert and insert together. Also, for very complex transformations ADF mapping data flows are not very much suggested . These are some drawbacks that i am able to list down as per my experience. **Recommendations to others considering Azure Data Factory:** Must look at dyanmic side of ADF Pipelines as it's a very amazing thing that can be done from ADF. **What problems is Azure Data Factory solving and how is that benefiting you?** Till now i was constantly solving different different variety of use cases in Azure data factory, that includes : 1. Migrating on premise data on azure 2.Automating ETL pipelines 3. Designing tranformations in ADF mapping DFs 4. Running ML worksflows, HD insight clusters, Databrick notebooks using ADF etc... ### 3. Breakthrough Orchestration & Data loading /ETL service from Azure **Rating:** 4.0/5.0 stars **Reviewed by:** Digambar J. | Senior Technical Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** October 09, 2022 **What do you like best about Azure Data Factory?** Data factory is a breakthrough Orchestration & Data loading /ETL service from Azure With connectors available for various SAAS applications like Snowflake, Zoho, GA & more. Easy to set up with a low/no-code platform & quick development time without any heavy installation needed **What do you dislike about Azure Data Factory?** still a lot more services are not available to connect directly using ADF, so I would love to see more & more services. **What problems is Azure Data Factory solving and how is that benefiting you?** 1. orchestration 2. easy data copying from vast services/tools databases. 3. notification set up 4. pay as you use model ### 4. Hybrid data integration tool for both ELT and ETL **Rating:** 4.5/5.0 stars **Reviewed by:** Kubendra Reddy M. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 04, 2022 **What do you like best about Azure Data Factory?** The best thing about the Azure data factory is that it has a wide range of connectors for many on-premise servers and cloud servers. It has many clusters compute services like HDInsight, Databricks so we can just use them for bulk data processing without knowing about the cluster. It provides all the components that need for data orchestration and to automate it. It can also allow us to run the SSIS packages so that ETL process can be done easily. **What do you dislike about Azure Data Factory?** It should allow us to code up to some extent and change the compute service clusters so that we can further optimize our pipeline. It uses external compute services such as HDInsight, DataBricks by using these we cant estimate the cost until the completion of the pipeline. **Recommendations to others considering Azure Data Factory:** One of the best data orchestration tool **What problems is Azure Data Factory solving and how is that benefiting you?** We are using this to load the data from different sources like files, on-premise servers and MySQL databases to Azure data warehouse from which BI team pulls the data for their insights. ### 5. Azure datafactory is an excellent microsoft product for data transformation needs!! **Rating:** 4.0/5.0 stars **Reviewed by:** Giridhar P. | Sr. Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 17, 2022 **What do you like best about Azure Data Factory?** Azure Data Factory is a microsoft product that provides the ability to create data pipelines for the migration of data and transforming them. The data flow defines the stages of data movement. Individual components are defined in user friendly format. The pipelines are created by assembling these individual components and linking them in the required format. After the completion of end to end component assembly, the activities could be individually tested and validated. As a final step these pipelines could be automated for scheduled executions. **What do you dislike about Azure Data Factory?** The Azure Data Factory interface is not an easy one to be understood by beginners. The number of activities, components, dataset definitions etc are many that requires good understanding. Parameters, variables and settings when configured cannot be wrong. The definitions of all the lists should be complete and accurate. **Recommendations to others considering Azure Data Factory:** Good tool to consider for dealing with BigData or Data science needs. **What problems is Azure Data Factory solving and how is that benefiting you?** Azure Data factory is being used for extracting several data feeds within our organization that meet business needs. The tool provides many features such as Move and Transform, Data explorer, Azure Functions, Data bricks, Data Lake Analytics, Machine Learning and Power Query. The end users were able to get several downstream file feeds employing ADF. Also, several structures were assembled within the tool to create a Data Lake to perform serverless analytics. Several batch jobs were automated to be executed on a daily bases to refresh the Data Lake components for end users decision support. ### 6. Data Factory Azure Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Industrial Automation | Small-Business (50 or fewer emp.) **Reviewed Date:** September 10, 2022 **What do you like best about Azure Data Factory?** Being from a non-tech background, the GUI of the Azure data factory was best to help me automate tasks of ETL workflows. When I used its GUI, it was straightforward to locate the required navigation to complete the ETL job schedules. **What do you dislike about Azure Data Factory?** I found the Azure data factory's dependency on other azure services to function mainly on the demerit side. I could only use the data factory service with azure services, not with other third-party applications. **What problems is Azure Data Factory solving and how is that benefiting you?** As I am part of the workflow Operation and Monitoring team, I am solving the problem of deploying ETL jobs in the production environment and helping us track them daily through dashboards. ### 7. Azure Data Factory Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2022 **What do you like best about Azure Data Factory?** Although azure data factory provides many advantages, one of the best and most used by me is its user-friendly GUI while creating ETL workflows. It is super easy to learn and deploy workflows using ADF GUI. **What do you dislike about Azure Data Factory?** One of the significant drawbacks of Azure data factory is it is a service of Azure, so other nonazure services can not be integrated with it. I have to rely entirely on using Azure Services for its usage. **What problems is Azure Data Factory solving and how is that benefiting you?** Azure data factory is solving ETL workflow automation problems after building workflows. It allows us to monitor and deploy ETL workflow pipelines for our business users. ### 8. Azure Data Factory !!! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 27, 2022 **What do you like best about Azure Data Factory?** The most liked feature of the data factory is that it is easy to use, and Drag & Drop functionality gives more benefits to creating the pipelines to integrate the source and destination. With the help of a data factory, we can perform the automation with the Azure platform or cross-platform. **What do you dislike about Azure Data Factory?** In Azure Data Factory, we haven't faced any challenges on it. ADF is as simple as. **What problems is Azure Data Factory solving and how is that benefiting you?** We have used the ADF for various use cases, like transferring the data from the cross-platform using a copy tool in ADF. ### 9. Best about Azure Data Factory **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 21, 2022 **What do you like best about Azure Data Factory?** Over all experience with Azure DataFactory is automating the process with the Azureplatform and able to perform and Collect the information from different platform. We have been usig the datafactory to mostly of copy tool which helps to connect any sources to copy the data to azure like S3 Bucket to Azure Blob. Also We can connect and peform en numbers of task with help of the Azure Data Factory. Its easy to deploy ,connect & Automate the process. **What do you dislike about Azure Data Factory?** We haven't encountered any issue in the Data Factory. **What problems is Azure Data Factory solving and how is that benefiting you?** We have automated a lot of process with the help of the Azure data factory. ### 10. Best Data Orchestration and Integration Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Shubham S. | Lead Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2022 **What do you like best about Azure Data Factory?** Easiness to use , no setup required and integration available with 100+ sources to fetch data. **What do you dislike about Azure Data Factory?** Data fetched through JSON API is limited to 1000 records and stored at intermediate location, this can be improved. **What problems is Azure Data Factory solving and how is that benefiting you?** Data Orchestration and automation of data pipelines and 100+ connectors available to fetch data from multiple sources ### 11. Great wait to start with data pipelines **Rating:** 3.5/5.0 stars **Reviewed by:** José L. | D, Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2021 **What do you like best about Azure Data Factory?** Its really simple to use but the best part has to be the integration with tools outside the Azure environment, if you want to migrate from AWS or GCP it already provide easy ways to do it **What do you dislike about Azure Data Factory?** No actual coding option; I see Azure Data Factory as Azure options for data pipelines like apache Airflow, but everything is visual, or json based having a real coding option would be nice (This is my opinion as a Data Engineer mostly, as a Data Architect I can't complain) **Recommendations to others considering Azure Data Factory:** Azure Data Factory and data pipelines were designed with a specific purpose. I have seen a lot of users trying to implement it as an alternative to streaming data, use it for batch processing, not streaming data running every minute, is not what is supposed to do, learn what the tool is really for since is a powerful and easy to use option **What problems is Azure Data Factory solving and how is that benefiting you?** We had a Sync problem between our data stores; we were initially using a bunch of Azure Functions to solve this, but then with Azure Data Factory, we had a more robust and straightforward process to keep data stores in sync ### 12. We have migrated on-Prem ingestion pipeline to Azure cloud using Azure Data factory **Rating:** 4.5/5.0 stars **Reviewed by:** Pramod K. | Advisory Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** July 15, 2022 **What do you like best about Azure Data Factory?** It is user friendly ETL tool, easy to use **What do you dislike about Azure Data Factory?** Iteration functionality task is not up to mark. **What problems is Azure Data Factory solving and how is that benefiting you?** We can intigrate and club the difference functionality together ### 13. Azure Data Factory For Delta Processing And Moving Data in Azure **Rating:** 5.0/5.0 stars **Reviewed by:** Ajay Kumar S. | Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2020 **What do you like best about Azure Data Factory?** The best part of the Azure Data Factory is that by using Service or User Authentication (Azure Key Vault to fetch Secrets), one can connect to many Databases all around the technologies. You can connect to various databases like Mongo DB, Google Big Query, Azure Data Lake Gen1, Azure Synapse, Azure SQL, Postgre SQL, Oracle, EDW, etc. Also in this, we create pipelines that are easy to implement either by writing codes or by dragging/dropping the fields and attributes and then providing values for them. One does not need to manually run the pipeline, it can be scheduled as needed and many pipelines can work in parallel if we use different self-hosted Integrated runtime machine. Azure Data Factory can be integrated with various tools like Azure Functions, Azure Web Jobs, Azure Data Bricks. **What do you dislike about Azure Data Factory?** Till now I have nothing to mention here as I am using the DataFactory for various purposes. But sometimes it takes a while to load the Azure Data Factory Interface which can be due to Slow Network or machine. **Recommendations to others considering Azure Data Factory:** If you are working on the projects which involve lots of Data Movement and Data Modeling and you want things to happen in a sequential manner, then I would request to use the Azure Data Factory to create pipelines that can be scheduled to run as required and also save time and resource. Various process/projects where you can use Azure Data Factory are:- 1) Setting up od Delta Lake Setup in Azure Data lake to do the Delta Processing. 2) Refreshing Azure Analysis Model by triggering Logic Apps to refresh tables with real-time data for Analysis and Reporting. 3) To Stop or Start Azure Analysis Server to save some cost in which it triggers the run book of Azure Automation Account which pauses the server over weekends. 4) Bringing data from Google Analytics and Google BigQuery and store the data in the form of tables in Azure Data Ware House. 5) Union of Data Pipes from two workstreams following the same schema. 6) Moving data from various Databases ad then storing them on Azure Data Ware House. 7) Running Azure Function without any manual intervention. 8) Running Azure Web Jobs without any manual intervention. 9) For Automation of some tasks and processes required for software development and maintenance. I will mention that the use of Azure Data Factory in Data Science Projects is very much needed and priceless. **What problems is Azure Data Factory solving and how is that benefiting you?** I have used the Azure Data Factory for various purposes. You can consider Azure Data Factory the same as SSIS. We have used Data Factory to bring data from enormous Databases to Azure DataLake. The Problems that Azure Data Factory solved for us are:- 1) Setting up od Delta Lake Setup in Azure Data lake to do the Delta Processing. 2) Refreshing Azure Analysis Model by triggering Logic Apps to refresh tables with real-time data for Analysis and Reporting. 3) To Stop or Start Azure Analysis Server to save some cost in which it triggers the run book of Azure Automation Account which pauses the server over weekends. 4) Bringing data from Google Analytics and Google BigQuery and store the data in the form of tables in Azure Data Ware House. 5) Union of Data Pipes from two workstreams following the same schema. 6) Moving data from various Databases ad then storing them on Azure Data Ware House. 7) Running Azure Function without any manual intervention. 8) Running Azure Web Jobs without any manual intervention. 9) For Automation of some tasks and processes required for software development and maintenance. ### 14. Azure Data Factory Review **Rating:** 4.5/5.0 stars **Reviewed by:** Rahul B. | Specialist Programmer, Enterprise (> 1000 emp.) **Reviewed Date:** January 04, 2022 **What do you like best about Azure Data Factory?** Azure data factory provides a one-stop solution for managing and authoring everything you'll need for your automation needs, from triggers to data pipelines. The ability to monitor current and past runs, trigger debug pipelines is helpful. **What do you dislike about Azure Data Factory?** Sometimes it takes rather long to load the objects when the user switches from one branch to another; most of the time, when this happens, I have to reload ADF base URL and start in a new tab altogether. **What problems is Azure Data Factory solving and how is that benefiting you?** The team uses ADF to monitor and author Data ingestion and transformation pipelines and scheduled and storage triggers. The ease of use and features provided by ADF help in rapid development. ### 15. Modern tool for Migration and ETL for cloud offering **Rating:** 5.0/5.0 stars **Reviewed by:** Suresh S. | Software Engg IV, Enterprise (> 1000 emp.) **Reviewed Date:** May 22, 2021 **What do you like best about Azure Data Factory?** numerous options for connectivity let it be a database or storage account it helps us move to move data transfer to cloud or on-prem systems. out of the box support for compress file systems like parquet helped us to use outlook files directly with space management. DataFactory helps us automate to schedule job as per customer demands to make ETL trigger when need arises. anyone can define the workflow with DataFactory UI designer tool and easily test the systems. it helped us automate the same workflow with programming language like python or automation tool like ansible. **What do you dislike about Azure Data Factory?** a looping approach is difficult to achieve with the Designer tool, for complex JSON when it comes to mapping nested attribute it's not easy to flatten out **What problems is Azure Data Factory solving and how is that benefiting you?** we had binary files which are DICOM extracted from PAC machines and need to run ETLon those DICOM. those are files are zip one and size around in Terabytes. with DataFactory we can define the workflow to extract the zips and then copy the flattened data in logical geographies storage account, with this We can turn around our ETL time on terabytes of data in a few ours and extracted data ready to use for our Data Scientists to run their ML algorithms. The real benefit I would say quick transformation no matter what the the type of data let it be CSV, JSON, or binary and storage compaction format help us a lot when dealing with BigData problems. ### 16. Azure Data Factory - best data orchestration platform **Rating:** 5.0/5.0 stars **Reviewed by:** Bharati S. | Graduate Engineering Trainee, Small-Business (50 or fewer emp.) **Reviewed Date:** July 31, 2021 **What do you like best about Azure Data Factory?** Azure Data Factory (ADF) is one of the best data orchestration platform. 1. It makes data load and transformation possible with easy to use and readily available tasks. It also allows to monitor the executed tasks, rerun them, schedule and automate them. 2. We can you one linked service in multiple pipeline/data load. 3. Dataflows created in adf have lots of data transformation tasks readily available. They are very easy to use. A dataflow can be again used in more than one pipeline. 4. It allows to copy data from various types of datasources like on premise file, azure database, excel, json, azure synapse, api etc to desired destination. 5. It provides lots of data transmission like pivot,unpivot, conditional split,loop iteration and so on. 6. It also allows to run ssis packages which make it an easy to use etl tool. 7. It allows us to automate data loads by scheduling triggers based on events or at desired time. There are several other benefits of azure Data Factory **What do you dislike about Azure Data Factory?** Azure data factory has been really helpful to me. There is nothing that I dislike about it currently. **Recommendations to others considering Azure Data Factory:** It's the best and the most user friendly tool for data orchestration with an amazing user interface and readily available tasks. **What problems is Azure Data Factory solving and how is that benefiting you?** 1. Create ETL solutions related to data loads and transformation as per business requirements. 2. It helps execute more than one tasks by creating dataflow and pipelines. 3. It allows to create child pipelines which enable us to execute complex etl with several tasks easily. 4. It helps us to automate the etl jobs using the azure data factory triggers. These triggers can be created based on events as well as can be scheduled to run at desired time. ### 17. ADF: A Great Service To Move and Transform Data **Rating:** 5.0/5.0 stars **Reviewed by:** Gonzalo A. | Civil Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 13, 2021 **What do you like best about Azure Data Factory?** I love that it's a low code Software that helps you to retrieve, format, manipulate, and then store large amounts of data. **What do you dislike about Azure Data Factory?** I've had some issues regarding integrating with competitor products like Oracle BI, and sometimes it gets significantly less responsive. **What problems is Azure Data Factory solving and how is that benefiting you?** We use ADF to integrate our multiple data sources and create automated upload pipelines that maintain our Data Warehouse. ### 18. Perfect Data orchestration or migration tool. **Rating:** 5.0/5.0 stars **Reviewed by:** Shruti J. | Salesforce Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 23, 2021 **What do you like best about Azure Data Factory?** I like how perfectly just on click you can migrate tons of data from onprem/cloud or multiple sources to multiple destination. You can schedule those pipeline you can transform data on fly and so much you have in this single service. **What do you dislike about Azure Data Factory?** I hate when i have a scenario and adf doesn't support that. It's hard fo debug error due to lack of resources when I'm stuck in particular scenario. For users perspective it's bit tough to showcase them or drill down the errror to showcase. **Recommendations to others considering Azure Data Factory:** If you're looking for ssis version of cloud adf is all yours. Data orchestration using ETL or ELT you can go with adf. Supports alot of activities within a pipeline like Databricks, notebook, logicapps,api etc **What problems is Azure Data Factory solving and how is that benefiting you?** Data orchestration, data movement all Etl i.e. extract transform and load type of task we have performed using adf. Use of databricks to integrate within or schedule our pipeline for particular requirements. ### 19. ADF is best cloud based data integration and ETL tool to handle multiple data sources **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) **Reviewed Date:** October 30, 2021 **What do you like best about Azure Data Factory?** ADF handle multiple data sources, data format and handles complex data transformation requirements with in-build data pipeline and schedulers **What do you dislike about Azure Data Factory?** Real time data integration requirements requires enhancement to improve performance and data refresh quicker for dashboard reporting **What problems is Azure Data Factory solving and how is that benefiting you?** Using ADF we are loading telematics data streaming out of IOT devices connected to trucks into Azure data cloud to analyze the health of various components like engine, moving components such as engine transmission, fuel systems, battery and other components and parameters. ### 20. Smart and reliable Cloud ETL service. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** July 29, 2021 **What do you like best about Azure Data Factory?** 1. The best way to manage data is to use Azure data factory. 2. Each to connect with other data sources. 3. Flow process using pipelines are the best. 4. Can be linked to many azure services like Blob storage, sql etc.. **What do you dislike about Azure Data Factory?** 1. Little Complicates than preivous versions(Which is SSIS) 2. Too expensive 3. Nedd flexibility for movings Data Factory between environments(Test, Prod) 4. No Propoer documentation for new features, or new releases or no enough examples. **What problems is Azure Data Factory solving and how is that benefiting you?** 1. Creating the Workflows process made it easy. 2. Data migration became very comfortable with vast data types. 3. infrastructure wise it's reliable. ### 21. Best orchestration or ETL Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Preeti J. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 25, 2021 **What do you like best about Azure Data Factory?** The way in just some steps and clicks it can migrate transform or we can simply do ETL activities in azure data factory. It provides various services in activities of data factory like azure functions azure databricks or storage. **What do you dislike about Azure Data Factory?** Everything isn't handy and its documentation isn't that helpful if you're stuck somewhere in between. Lack of resources leads to make a simpler task so hard. **Recommendations to others considering Azure Data Factory:** If you want to do orchestration or ETL it's just what you need. Also if you're looking for SSIS cloud version this is it. Go for it . You'll be amazed with its features. **What problems is Azure Data Factory solving and how is that benefiting you?** Migrating the data is perfect as far as i have worked on it. Also data engineering works perfectly with it be because of its data orchestration capabilities and can be used as ETL tool. ### 22. Experience with Azure Data Factory **Rating:** 5.0/5.0 stars **Reviewed by:** Venkatesh K. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 05, 2021 **What do you like best about Azure Data Factory?** Data transform Activities for data ingestion from various sources **What do you dislike about Azure Data Factory?** Performance issues with DataFlow Task while connecting to Rest API Data **Recommendations to others considering Azure Data Factory:** It's a fantastic tool for ETL developers who are mainly working on ETL.ELT approach **What problems is Azure Data Factory solving and how is that benefiting you?** Mainly we are solving the data ingestions with ELT approach ### 23. ADF reusability and limitations **Rating:** 4.5/5.0 stars **Reviewed by:** Ashok G. | Associate Manager, Enterprise (> 1000 emp.) **Reviewed Date:** September 05, 2021 **What do you like best about Azure Data Factory?** Integration with 100 of external sources. Eas of setup. Easy drag and drop UI. **What do you dislike about Azure Data Factory?** Limitations with max activity limit. Nested loop support is not there Expression do not support nesting. Monitoring is poor **What problems is Azure Data Factory solving and how is that benefiting you?** Orchestration of big data ingestion. Created reusable pipelines. ### 24. Futuristic integration service to carry data from different sources and perform transformations **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Enterprise (> 1000 emp.) **Reviewed Date:** July 17, 2021 **What do you like best about Azure Data Factory?** No need to perform coding, and hence low code level transformations. Also no need for large up-front license purchases, but you can pay as per your usability **What do you dislike about Azure Data Factory?** Less marketing for this kind of products **What problems is Azure Data Factory solving and how is that benefiting you?** Ability to solve the vast amount of data while it is ingested into the cloud. ADF makes the whole ETL process very simple and manageable. It saves a lot of cost and time. ### 25. Cloud based data transformation tool **Rating:** 4.0/5.0 stars **Reviewed by:** Abhishek C. | Senior Technology Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** January 08, 2021 **What do you like best about Azure Data Factory?** Works well as a data transformation and integration tool with no coding and quick time to market **What do you dislike about Azure Data Factory?** There is no on-premise support and works only in cloud **Recommendations to others considering Azure Data Factory:** Highly recommended it for ETL operations involving big data for reporting **What problems is Azure Data Factory solving and how is that benefiting you?** Leveraging Azure data factory to connect to source application and integrating with data warehouse and data lake for analytic needs ### 26. The power of data pipelines **Rating:** 5.0/5.0 stars **Reviewed by:** Uayeb C. | Advanced Analytics Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** October 31, 2019 **What do you like best about Azure Data Factory?** Companies nowadays get a lot of information from different sources; the amazing thing is that all this new information that we are getting brings a ton of value. But How we can move and centralize these raw data and even how we can trigger the extraction of data mine. Data factory is the answer of that, Microsoft has done an excellent service implementation with this great tool. The main thing that need to know is the concept of data pipelines. In an data pipeline you will be able to add different kind of activities as for example connect from your on premise SFTP and move CSV files to storage accounts. As well data factory has its own data flow if you are an ETL developer experimented maybe you have worked with SSIS, thus, you will start quickly with this new feature of data factory. Power of connection is one the best features of Data Factory you can connect with all azure storage repositories and as the same way you can connect with other cloud sources as amazon and google. **What do you dislike about Azure Data Factory?** In my experiences working with this tool Data Factory V1 does not have a good implementation experience as V2 has, however, it provides knowledge of JSON Settings file. Data Factory V2 has this channel of implementation. But you can use its wizard tool. Work with on premise solutions sometimes is not too friendly because you will need to set a VPN. **What problems is Azure Data Factory solving and how is that benefiting you?** Data factory is our schedule service, we have integrated different solutions of analytics in many institutions of laureate network. We ingest information from SFTP and after that we run our machine learning experiments with Azure ML. as well we implemented azure functions to run service implementation as sendgrid to send notifications. ### 27. Working in Azure Data Factory from past 2 years.. **Rating:** 4.5/5.0 stars **Reviewed by:** Sanjeev J. | Cloud Architect, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** October 11, 2019 **What do you like best about Azure Data Factory?** Most robust, easy to learn and use. integrated with Bigdata using data bricks. We can use to Extract Load and Transform and Load data from diffrent sources. No code or maintenance required to build hybrid ETL and ELT pipelines within the Data Factory visual environment Cost-efficient and fully managed serverless cloud data integration tool that scales on demand Azure security measures to connect to on-premises, cloud-based and software-as-a-service apps with peace of mind SSIS integration runtime to easily rehost on-premises SSIS packages in the cloud using familiar SSIS tools. Work the way you want Data Factory provides a single hybrid data integration service for all skill levels. Use the visual interface or write your own code in Python, .NET or ARM to build pipelines. Put your choice of processing services into managed data pipelines or insert custom code as a processing step in any pipeline. Protect your data while it is in use with Azure confidential computing. Data Factory management resources are built on Azure security infrastructure and use all the Azure security measures. Pay only for what you need, with no upfront cost Explore a range of cloud data integration capabilities to fit your scale, infrastructure, compatibility, performance and budget needs. Options include managed SSIS for seamless migration of SQL Server projects to the cloud and large-scale, serverless data pipelines for integrating data of all shapes and sizes. **What do you dislike about Azure Data Factory?** Needs to incorporate more ETL and audit features. **Recommendations to others considering Azure Data Factory:** Yes **What problems is Azure Data Factory solving and how is that benefiting you?** Moving our onprime data to cloud with ETL. ### 28. Software Developer **Rating:** 4.0/5.0 stars **Reviewed by:** Moeez A. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 02, 2019 **What do you like best about Azure Data Factory?** The main part of the Azure Data factory is how Microsoft is moving to words to the cloud moving everything to the cloud. No more worry about the hardware within a few clicks you can change the configuration of the server where you are running you Data Factory **What do you dislike about Azure Data Factory?** In the Azure Data Factory, the data flow debug take 7 to 10 mins sping time to active the debug mode that too much for me. and sometimes the debug mode deactivated automatically but the on the UI in the show it is active **What problems is Azure Data Factory solving and how is that benefiting you?** We are moving from SSIS packages to Azure data flow the issue was with SSIS package too much configuration for us and had to upgrade the hardware ### 29. Is a great tool to use integration services **Rating:** 4.5/5.0 stars **Reviewed by:** Alvaro R. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 31, 2019 **What do you like best about Azure Data Factory?** It is easy to use. Very clear with its components very usefull components. Easy integration with other azure services. Has scheduling. It is in constant updating with new features. **What do you dislike about Azure Data Factory?** Actually I am really pleased with this product, I don't have a complaint. **Recommendations to others considering Azure Data Factory:** This is a great tool to ease out integration processes, use best if you integrate it with other azure services. **What problems is Azure Data Factory solving and how is that benefiting you?** Currently, helps out to automate different processes such as moving and transforming data thanks to its integration with other azure services, definitely stands out from other integration tools. ### 30. A pretty good workflow orchestration tool from the house of microsoft **Rating:** 5.0/5.0 stars **Reviewed by:** Supratik D. | Senior ML Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** September 24, 2019 **What do you like best about Azure Data Factory?** ADF is a cloud data integration service, to compose data storage, movement, and processing services into automated data pipelines. Very easy to set up and manage data pipelines, and how to move and transform data for analysis. **What do you dislike about Azure Data Factory?** The UI might have been a bit more intuitive. Easier option of setting error notifications should be introduced **What problems is Azure Data Factory solving and how is that benefiting you?** Scalable Big data and AI work. To create complex data pipelines with multiple components. Works pretty well in Handling complex workflows and handling complex scenerios as well . Integrate data silos with Azure Data Factory, Integrate data silos with Azure Data Factory, ### 31. SSIS for cloud **Rating:** 3.5/5.0 stars **Reviewed by:** Shayan H. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 26, 2019 **What do you like best about Azure Data Factory?** Ability to scaling the work pipeline workload, Web interface and introduce data flows **What do you dislike about Azure Data Factory?** The costing is hard to understand. Lack of flexibility in the pipelines **What problems is Azure Data Factory solving and how is that benefiting you?** extract load and transform the data using azure blob storage ### 32. Great product, easy to integrate with Azure products and other vendors **Rating:** 5.0/5.0 stars **Reviewed by:** Marco U. | Application Developer Analyst, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** June 14, 2019 **What do you like best about Azure Data Factory?** its design as well as its high compatibility with Azure products and how easy is to make those connections through MSI or Azure key Vault **What do you dislike about Azure Data Factory?** Some features don't work, the options are there but they do nothing. Creating the right script for automating the pipelines through C# was a pain due to outdated documentation. There are some errors on the UI with firefox, the debugger is not real and the errors sometimes are not very descriptive **Recommendations to others considering Azure Data Factory:** Its great when you're on the me Azure ecosystem and when you want to combine products of other vendors **What problems is Azure Data Factory solving and how is that benefiting you?** Data transformation, integration with other Azure services as well as from other vendors. Its a very cool product because it is compatible with mostly anything on the market. ### 33. setting up data flow has never been made so easier! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Outsourcing/Offshoring | Mid-Market (51-1000 emp.) **Reviewed Date:** October 14, 2019 **What do you like best about Azure Data Factory?** The ability to visualize and establish connection to various data sources from API, SFTP server, data lake, sql server... etc. Visualising and setting up pipelines of data flow is made easy and seamless. The tool allows you to create your own structure and data convention. The integration with devops is amazing ! **What do you dislike about Azure Data Factory?** The fact that it lets you build you own structure, pre existing template for the structure would be perfect! **What problems is Azure Data Factory solving and how is that benefiting you?** data flow, linking raw data sources to the cloud, cleansing data, moving data from raw sources to production source. ### 34. Great tool for connecting ecommerce platforms **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.) **Reviewed Date:** August 15, 2019 **What do you like best about Azure Data Factory?** Using a runbook, you can schedule your Integration Runtime to only run when necessary (saving HUGE dollars). Ours runs for an hour during the night and we schedule our SSIS packages accordingly. **What do you dislike about Azure Data Factory?** Like much of the Microsoft Platform, the solution can be a bit cumbersome to learn. Help articles leave much to be desired. **What problems is Azure Data Factory solving and how is that benefiting you?** We are connecting data from ecom platforms to a single Azure database for reporting purposes. ### 35. My review on Azure DataFactory **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Electrical/Electronic Manufacturing | Mid-Market (51-1000 emp.) **Reviewed Date:** April 29, 2019 **What do you like best about Azure Data Factory?** It is mainly used to retrieve bulk data from various systems and integrate with different systems. Like the idea of using having pipelines and triggers. we use various types of triggers like blob and schedule triggers to make the pipeline run at predefined times **What do you dislike about Azure Data Factory?** The thing which we don't like about is the error description is not very descriptive and the way to run manually is not very useful. after debugging the information is not stored anywhere. **Recommendations to others considering Azure Data Factory:** This is very useful when we have bulk data with various formats **What problems is Azure Data Factory solving and how is that benefiting you?** we work on integration platform where we connect to various types of end systems to collect data. Datafactory is very useful in terms of retrieving bulk data of any format and convert to end system format. ### 36. Data integration in the cloud **Rating:** 4.5/5.0 stars **Reviewed by:** Lakshita P. | Sr. Software Engineer, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** December 14, 2018 **What do you like best about Azure Data Factory?** Easy to use and manage the linked services over the network. Data sets defination is pretty simple to define and great thing i can map the same with file based data as well just definig a path for it. Its connectivity with different data stores is amazing. Easy to review and monitoring of the logged data. Creating new pipleline is pretty simple and can schedule these as per the need. **What do you dislike about Azure Data Factory?** As i noticed azure data factory can not pull the data directly from virtual machine, this can be only done with linked services. **What problems is Azure Data Factory solving and how is that benefiting you?** Managed the cloud and on-premeise data efficiently. Added more security in linked services to interact with azure data lake stores. Increased the data scalabilty and moved on cloud. Summarized the data at daily and weekly level in an efficient way. ### 37. Best Solution For Database Management System **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2018 **What do you like best about Azure Data Factory?** Everything is pretty much straightforward, given that you have some database knowledge. The DBMS allows you to easily create several things entirely in design (tables, views, etc) - which is a big plus when you don't know the entire syntax. Mainly, the ability to extract the precise data is the best part for me. THe reasons made me use this product were : Create internal/operational efficiencies Drive revenue growth Enhance decision making Improve business process agility Improve business process outcomes **What do you dislike about Azure Data Factory?** Scalability is great but not the best like other new databases there in the market. CPU memory consumption is always more than normal on production. Difficult to setup permissions and roles. On that point i want to suggest that SQL server has always fulfilled the new requirements and has great features to utilize. This will always exceed your expectation for sure. If your environment is window and you want a full secure fast native database SQL server is the product you are looking for. **Recommendations to others considering Azure Data Factory:** SQL Server is a robust, well-established relational database manager, it's relatively easy to set up a new database server and connectivity between clients. **What problems is Azure Data Factory solving and how is that benefiting you?** Overall an excellent tool for data gathering and visualization. Excellent support and other new databases large user community. What I like the most is its IDE to do everything in design view, the creation of customized views, stored procedures I think that is its strength today we can also have SQL server in Linux distributions. Compatibility with enterprise software that needs DB integration, this environment allows us to integrate (locally or cloud) all our solutions on the main server with cluster functionality. ### 38. Perfectly Ties Together Other Microsoft Products **Rating:** 5.0/5.0 stars **Reviewed by:** Matt P. | Associate Performance Analyst, Medical Devices, Enterprise (> 1000 emp.) **Reviewed Date:** October 29, 2018 **What do you like best about Azure Data Factory?** Data factory has been a great tool move data from the data lake through SQL into PowerBI. The best part is the ability to create and automate pipelines with preloading scripts **What do you dislike about Azure Data Factory?** It is not very intuitive. When I first started using df there was a lot to learn and figure out. Once you get the hang of it though there is a lot of opportunity **What problems is Azure Data Factory solving and how is that benefiting you?** We used data factory to solve the issue of receiving data from our vendor, processing it, then pushing it to an analytics tool like PowerBI. With the Azure service we were able to have our client load the data to data lake and data factory took care of the rest from processing the data to pushing it to where we needed it without lifting a finger ### 39. The final big data integration platform **Rating:** 4.0/5.0 stars **Reviewed by:** Rubén L. | Responsable Funcional, Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2018 **What do you like best about Azure Data Factory?** Azure Data Factory is very easy to use with drag and drop functions. It's secured, scalable and supports code in Python, .NET o ARM. **What do you dislike about Azure Data Factory?** Azure Data Factory is really brilliant but I had problems with the installing and configurations as same as other products of Microsoft Azure **What problems is Azure Data Factory solving and how is that benefiting you?** It's the final big data integration platform. Any project of big data is really easy to complete with this software ### 40. Azure Data Factory review - it's a winner **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2018 **What do you like best about Azure Data Factory?** Really like the ability to do data transformation prior to loading into a proprietary database - allows for data integrity to remain intact **What do you dislike about Azure Data Factory?** Azure monitoring capability less than ideal for publishing of content **What problems is Azure Data Factory solving and how is that benefiting you?** We've been collating several disparate DBs into one mega structure and like the integrated tools that this SW provides ### 41. A tool you can rely on **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 21, 2018 **What do you like best about Azure Data Factory?** I have worked on AF v1. The best part of this tool is that you can easily get it up and running with little knowledge. It provides out of the box feature to connect to most of the data sources. **What do you dislike about Azure Data Factory?** There is no way to create dependencies between run slices **Recommendations to others considering Azure Data Factory:** It is one the best tool to implement event base workflows. Though one need to be careful when implementing real time data scenarios. **What problems is Azure Data Factory solving and how is that benefiting you?** Help business to transform data from traditional data lake to azure cloud using Azure data factory in short span of time. ### 42. Makes organizing a dream! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Textiles | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2018 **What do you like best about Azure Data Factory?** I love the simplicity and ease of use! Truly saves so much time and effort to have documents saved from different sources to one main drive for ease of use and finding. **What do you dislike about Azure Data Factory?** Getting started was a little tricky to get everything set up and fixed to store correctly but once you figure out how it works it truly is so simple **What problems is Azure Data Factory solving and how is that benefiting you?** Able to save sources from the cloud, on premises and unstructured all to one main data storage. I ### 43. Data integrations services in Azure **Rating:** 5.0/5.0 stars **Reviewed by:** Nikolay K. | System Administrator, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** February 17, 2018 **What do you like best about Azure Data Factory?** Azure Data factory provides ability to build ETL processes in Azure, in simple and familiar for SQL developers way. You can deploy your SSIS packages there, you can select from a different types of sources like BLOB objects, Hadoop clusters or different kinds of relational databases. You can orchestrate your data movement using pipelines, which provides sets of actiities like extraction, transofmation and uploading of data to relational data warehouse for analytical processing. There are a lot of tools are supported by Data Factory, you can manage it with Azure Portal, Python, REST interface or ARM template. **What do you dislike about Azure Data Factory?** You will not be able to deploy your SSIS packages designed to run on-premises immediately, backwards compatibility is partial, so you will need to do some modification **Recommendations to others considering Azure Data Factory:** Works better than SSIS in Azure but requires some additional training **What problems is Azure Data Factory solving and how is that benefiting you?** Creating and orchestrating ETL processes in Azure ### 44. Azure Data FActory **Rating:** 4.5/5.0 stars **Reviewed by:** James M. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 13, 2018 **What do you like best about Azure Data Factory?** I like how well organized Azure is and that you can easily do what you need **What do you dislike about Azure Data Factory?** It seems like there are a lot of steps to accomplish certain items **What problems is Azure Data Factory solving and how is that benefiting you?** Web Development ### 45. nice **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** December 01, 2018 **What do you like best about Azure Data Factory?** easy to use. the system interface suits my business for communication and analysis of data. Very good for working in teams. Hybrid data integration tool functions help monitor my business target achievements. **What do you dislike about Azure Data Factory?** interface is not clean when using code free data movement **Recommendations to others considering Azure Data Factory:** consider visual drag and drop and scalable features for business, it is also a trusted provider **What problems is Azure Data Factory solving and how is that benefiting you?** solving business communication issues ### 46. Best way to migrate your SSIS to Azure **Rating:** 5.0/5.0 stars **Reviewed by:** Arthur S. | Database Administrator, Airlines/Aviation, Enterprise (> 1000 emp.) **Reviewed Date:** February 22, 2018 **What do you like best about Azure Data Factory?** Creation of data movement and transformation processes wiithout deploying separate server for this. Very good when using it with Azure SQL databases and warehouses, as well as picking data from non-relational sources in cloud and on-premises, like different NoSQL databases, event hubs or even excel files or table storage. Data is being transformed in the way you need and put do DWH for further analysis. Can be used to deploy your existing SSIS packages, that were used on-premises. These will just need several adjustments to start working **What do you dislike about Azure Data Factory?** Overall complexity of product, need some time to get used with it **Recommendations to others considering Azure Data Factory:** Data Factory is much more cost effective that SSIS running on Azure VM **What problems is Azure Data Factory solving and how is that benefiting you?** Driving ETL processes across organization ### 47. Great for large systems **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Networking | Enterprise (> 1000 emp.) **Reviewed Date:** December 12, 2018 **What do you like best about Azure Data Factory?** I liked the scalability. My team really enjoys building systems using it. **What do you dislike about Azure Data Factory?** The subscription costs aren't ideal to be honest. **What problems is Azure Data Factory solving and how is that benefiting you?** We're simulating the characteristics of distributed databases. ### 48. Nice product **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** December 16, 2018 **What do you like best about Azure Data Factory?** Works very good with complex data set. Very nice data cloud solution. **What do you dislike about Azure Data Factory?** I don't think I can say something I dislike **What problems is Azure Data Factory solving and how is that benefiting you?** Highly scalable. ### 49. Azure Data Factory **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Mid-Market (51-1000 emp.) **Reviewed Date:** January 31, 2018 **What do you like best about Azure Data Factory?** The most important thing with Data Factory is the ease of creating new pipelines. The pipelines are structures which you define to move data from Cloud to On-prem Sql Server. These pipelines can then be run at a particular time of day/week. **What do you dislike about Azure Data Factory?** The user interface needs a small change to make it intuitive. New users can get confused by the window pane positions and may delete their work inadvertantly. **Recommendations to others considering Azure Data Factory:** I recommend using Azure data factory to integrate and enable data transfers between cloud based services and on-prem data clusters. **What problems is Azure Data Factory solving and how is that benefiting you?** I have been using Azure data factory as a link between Azure Machine Learning and Sql Server Data base. This allows me to schedule data job runs at a particular time and automatically trigger stored procedures on the SQl-Server end of the pipeline. We can realize many important functions using this. ### 50. Excellent customer support and easy to use **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.) **Reviewed Date:** August 28, 2018 **What do you like best about Azure Data Factory?** I like the integration this platform has with other web applications and Github. Also, the website interface is designed very well and easy to use. Moreover, there is no cost to sign up. **What do you dislike about Azure Data Factory?** Its a bit expensive for the added features. Other than that, There is nothing I can report that I dislike. **What problems is Azure Data Factory solving and how is that benefiting you?** Use of mobile apps help coordinate with customers ## Azure Data Factory Discussions - [Is Azure data Factory an ETL tool?](https://www.g2.com/discussions/is-azure-data-factory-an-etl-tool) - 2 comments - [View Azure Data Factory pricing details and edition comparison](https://www.g2.com/products/azure-data-factory/reviews?page=2§ion=pricing&secure%5Bexpires_at%5D=2026-08-04+03%3A40%3A32+-0500&secure%5Bsession_id%5D=e15311fd-559e-4912-983b-8aab30ef77b0&secure%5Btoken%5D=70c5acad30958eb7f33c437fcbf5cdc8740510c43cfac4d1c62e92c55d604d62&format=llm_user) ## Azure Data Factory Integrations - [Agentforce Sales (formerly Salesforce Sales Cloud)](https://www.g2.com/products/agentforce-sales-formerly-salesforce-sales-cloud/reviews) - [Amazon Simple Email Service (Amazon SES)](https://www.g2.com/products/amazon-simple-email-service-amazon-ses/reviews) - [Azure Blob Storage](https://www.g2.com/products/azure-blob-storage/reviews) - [Azure Databricks](https://www.g2.com/products/azure-databricks/reviews) - [Azure Data Lake Store](https://www.g2.com/products/azure-data-lake-store/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Google Ads](https://www.g2.com/products/google-ads/reviews) - [Microsoft Power Automate](https://www.g2.com/products/microsoft-power-automate/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) ## Azure Data Factory Features **Management** - Reporting - Auditing **Functionality** - Extraction - Transformation - Loading - Automation - Scalability ## Top Azure Data Factory Alternatives - [SnapLogic Intelligent Integration Platform (IIP)](https://www.g2.com/products/snaplogic-intelligent-integration-platform-iip/reviews) - 4.4/5.0 (375 reviews) - [dbt](https://www.g2.com/products/dbt/reviews) - 4.7/5.0 (208 reviews) - [AWS Glue](https://www.g2.com/products/aws-glue/reviews) - 4.3/5.0 (194 reviews)