Microsoft Corporation

Microsoft Azure Data Factory

8.6 /10

67 Reviews Write a Review

Claim Software

What is Microsoft Azure Data Factory?

Azure Data Factory is Azure's cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management.

Company Details

Need Assistance?

We're here to help you with understanding our reports and the data inside to help you make decisions.

Get Assistance

Awards & Recognition

Microsoft Azure Data Factory won the following awards in the Data Integration category

Filter By

Microsoft Azure Data Factory Ratings

Real user data aggregated to summarize the product performance and customer experience.
Download the entire Product Scorecard to access more information on Microsoft Azure Data Factory.

87 Likeliness to Recommend

100 Plan to Renew

77 Satisfaction of Cost Relative to Value

1
Since last award

{y}

{name}

Emotional Footprint Overview

+90 Net Emotional Footprint

The emotional sentiment held by end users of the software based on their experience with the vendor. Responses are captured on an eight-point scale.

How much do users love Microsoft Azure Data Factory?

4% Negative

5% Neutral

91% Positive

Pros

Performance Enhancing
Reliable
Enables Productivity
Efficient Service

Feature Ratings

Average 79

Data Security

iPaaS

Administrative Features

Real Time Integration

Batch Integration

Synchronization and Replication

Exception Handling and Notifications

Metadata Management

API Management and Orchestration

Data Virtualization

Multi Channel Support

Vendor Capability Ratings

Average 79

Quality of Features

Ease of Data Integration

Ease of Implementation

Breadth of Features

Business Value Created

Usability and Intuitiveness

Ease of IT Administration

Availability and Quality of Training

Ease of Customization

Vendor Support

Product Strategy and Rate of Improvement

Microsoft Azure Data Factory Reviews

Rahul A.

Role: Information Technology
Industry: Banking
Involvement: IT Leader or Manager

Validated Review

Verified Reviewer

Submitted Jul 2023

Data Pipeline at scale

Likeliness to Recommend

9 /10

What differentiates Microsoft Azure Data Factory from other similar products?

This is managed PaaS offering from azure for data ingestion and processing

What is your favorite aspect of this product?

Pipelien monitoring and integration with multiple data sources

What do you dislike most about this product?

Error handling and alerting

What recommendations would you give to someone considering this product?

When hosting bigdata ecosystem on azure cloud, ADF is must have azure offering.

Pros

Helps Innovate
Continually Improving Product
Reliable
Performance Enhancing

Nishit R.

Role: Consultant
Industry: Consulting
Involvement: IT Development, Integration, and Administration

Validated Review

Verified Reviewer

Submitted May 2023

Azure Data Factory - Awesome Product

Likeliness to Recommend

10 /10

What differentiates Microsoft Azure Data Factory from other similar products?

Azure Data Factory is a cloud service for data integration management that collects and links diverse data. In addition, it can be linked to various systems to automate multiple information extraction processes required for data analysis. It can also be used for data integration, such as ETL and ELT. ADF allows linking and using fragmented data through the development of ICT, accelerating the diversification of systems used in the enterprise from on-premises to the cloud. It makes business more efficient and convenient, as data is accumulated, analyzed and used efficiently i.e., centrally managed. Transforms collected and stored data. Allow

What is your favorite aspect of this product?

df is an ETL tool provided by MS, what I like most is that it is easy to use and we can easily connect to third party resources using link services to get datasheet. We can create separate files for the source and the repository and using the channel work we can use all the variables and use the repository to get the desired results. We use dbx workspace tokens to connect directly to Databricks and we can use ADF to connect to our Databricks books.

What do you dislike most about this product?

It's unbelievable how they keep renaming and rebranding things. SQL Warehouse becomes Azure Synapse. If you ask someone what is Synapse, they will give you a different answer than the other answers and it will be both. It's enough for MS to name their products correctly and stick with them without repetition.

What recommendations would you give to someone considering this product?

My recommendation is to definitely go for this product. It is currently the best product available in the market and it can be used in both of the workloads i.e. ETL and ELT . Its is easier to use , no setup required and integration available with 100+ sources to fetch data. Also if you want to migrate to and fro from one cloud tool to another it is useful.

Pros

Helps Innovate
Continually Improving Product
Reliable
Performance Enhancing

Kumar S.

Role: Information Technology
Industry: Consulting
Involvement: End User of Application

Validated Review

Verified Reviewer

Submitted May 2023

Really good product good UI, no code drag n drop

Likeliness to Recommend

9 /10

What differentiates Microsoft Azure Data Factory from other similar products?

Microsoft Azure Data Factory provides with the good UI for No code data pipelines creation. It also includes the capabilities of ingest and transforming the data with Azure services or external services like azure databricks.

What is your favorite aspect of this product?

My favourite aspect of this product is that it has many options available for creating pipelines with drag and drop platform with no code required.

What do you dislike most about this product?

UI for nested pipelines is not really liked by me

What recommendations would you give to someone considering this product?

I would recommend that it is a good product for creating and managing data pipelines

Pros

Continually Improving Product
Reliable
Performance Enhancing
Effective Service

Microsoft Azure Data Factory

What is Microsoft Azure Data Factory?

Company Details

Need Assistance?

Awards & Recognition

2024 Data Quadrant Gold Medalist

2023 Emotional Footprint Champion

2020 Emotional Footprint Champion

Microsoft Azure Data Factory Ratings

87 Likeliness to Recommend

100 Plan to Renew

77 Satisfaction of Cost Relative to Value

1 Since last award

Emotional Footprint Overview

+90 Net Emotional Footprint

How much do users love Microsoft Azure Data Factory?

Pros

Feature Ratings Average rating of all product features, some of which may not be shown below

Data Security Includes ability to hide sensitive data by masking with special characters or anonymous information.

iPaaS Includes iPaaS (Cloud hosting) features and other advanced integration capabilities

Administrative Features Includes basic aspects of data extraction, transformation, and loading. Administrative console and process viewing, interruption, restart, cancel, and rollback.

Real Time Integration Able to integrate data in near-real time and handle movement of data from a source to target. Monitoring for changes in a data source in a non-invasive manner.

Batch Integration Includes ability to schedule integration processes to run on a periodic basis to control the movement of data from a source to target.

Synchronization and Replication Includes the ability to accurately catch, reflect, and correct changes in data across multiple data stores.

Exception Handling and Notifications Ability to catch, report, and handle exceptions; includes transaction logging and event viewing.

Metadata Management A metadata layer makes reporting easy and eliminates the need for coding and SQL, allowing users to see and access information in simple business language.

API Management and Orchestration Includes publishing, promoting and overseeing APIs and Orchestration Services.

Data Virtualization Includes ability to create views joining disparate data sources without the need for persistence.

Multi Channel Support The ability to support and connect with channels including Cloud Services, Big Data Platforms, web, mobile, social, IoT, wearables, etc.

Vendor Capability Ratings Average rating of all vendor capabilities, some of which may not be shown below

Quality of Features Feature quality is just as important as quantity. Use this data to determine if this product will do what you're purchasing it to do, easily, intuitively, reliably, and effectively.

Ease of Data Integration Use this data to determine whether the product will cause headaches or make data integration easy.

Ease of Implementation Successfully implementing new software is necessary to realize its full value and promote end user adoption. This data indicates whether or not the product is easy to implement.

Breadth of Features Users prefer feature rich software that enables them to perform diverse series of tasks. This data expresses user satisfaction with the product's breadth of features.

Business Value Created Software needs to create value for employees, customers, partners, and, ultimately, shareholders. This data expresses user satisfaction - or lack thereof - with the product's business value.

Usability and Intuitiveness End user learning curves cost the organization money. Pay attention to your end users' technical ability to determine how important UX is in your purchase.

Ease of IT Administration This data indicates whether IT personnel will be able to resolve issues and perform configurations efficiently and effectively.

Availability and Quality of Training Effective and readily available training enables users to get the most out of the software you've chosen. Use this section to make sure your vendor's training programs and materials measure up.

Ease of Customization Don't get bogged down in a difficult customization; use this data to make sure you can easily achieve the functionality you need for your particular situation.

Vendor Support The importance of vendor support will vary for each organization depending on internal capabilities, but there will always be issues that only the vendor can resolve.

Product Strategy and Rate of Improvement Vendors who don't stay on top of emerging needs and trends won't enable you to meet your business goals. Use this data to separate innovators from imposters.

Microsoft Azure Data Factory Reviews

Rahul A.

Data Pipeline at scale

Likeliness to Recommend

Pros

Nishit R.

Azure Data Factory - Awesome Product

Likeliness to Recommend

Pros

Kumar S.

Really good product good UI, no code drag n drop

Likeliness to Recommend

Pros

Most Popular Microsoft Azure Data Factory Comparisons

Microsoft SQL Server

Zapier

Oracle Data Integrator

Altova MapForce

Cleo Integration Cloud

SAP Data Services

1
Since last award

Feature Ratings

Data Security

iPaaS

Administrative Features

Real Time Integration

Batch Integration

Synchronization and Replication

Exception Handling and Notifications

Metadata Management

API Management and Orchestration

Data Virtualization

Multi Channel Support

Vendor Capability Ratings

Quality of Features

Ease of Data Integration

Ease of Implementation

Breadth of Features

Business Value Created

Usability and Intuitiveness

Ease of IT Administration

Availability and Quality of Training

Ease of Customization

Vendor Support

Product Strategy and Rate of Improvement