This content is currently locked.

Your current McLean & Company subscription does not include access to this content. Contact your account representative to gain access to Premium SoftwareReviews.

Contact Your Representative

Or Call Us:
1-877-281-0480 (US/CAN) or
+1-519-936-2659 (International)

Microsoft Corporation

Microsoft Azure Data Factory

Composite Score

8.6 /10

CX Score

8.9 /10

73 Reviews Write a Review

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. Data Factory provides a data integration and transformation layer that works across your digital transformation initiatives.

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.

Product scores listed below represent current data. This may be different from data contained in reports and awards, which express data as of their publication date.

87 Likeliness to Recommend

100 Plan to Renew

77 Satisfaction of Cost Relative to Value

{y}

{name}

Emotional Footprint Overview

Product scores listed below represent current data. This may be different from data contained in reports and awards, which express data as of their publication date.

+91 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
Enables Productivity
Reliable
Efficient Service

Feature Ratings

Average 80

Data Security

Real Time Integration

iPaaS

Administrative Features

Batch Integration

Synchronization and Replication

Exception Handling and Notifications

Data Virtualization

API Management and Orchestration

Multi Channel Support

Metadata Management

Vendor Capability Ratings

Average 80

Quality of Features

Ease of Data Integration

Business Value Created

Breadth of Features

Usability and Intuitiveness

Ease of Implementation

Availability and Quality of Training

Ease of IT Administration

Vendor Support

Ease of Customization

Product Strategy and Rate of Improvement

Microsoft Azure Data Factory Reviews

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

Mohammad f.

Role: Sales Marketing
Industry: Education
Involvement: IT Leader or Manager

Validated Review

Verified Reviewer

Submitted May 2023

Go to product for my daily work

Likeliness to Recommend

10 /10

What differentiates Microsoft Azure Data Factory from other similar products?

it is a highly scalable solution, there is no limit to storage It integrates all of the data and you can design, create and monitor pipelines according to your requirements.

What is your favorite aspect of this product?

became more user friendly when data flows were introduced.

What do you dislike most about this product?

uses many resources and has issues with parallel workflows.

What recommendations would you give to someone considering this product?

Use of Ai in the the customer support will be very helpfull.

Pros

Helps Innovate
Continually Improving Product
Reliable
Performance Enhancing

How We Deliver

Microsoft Azure Data Factory

What is Microsoft Azure Data Factory?

Company Details

Need Assistance?

Awards & Recognition

2024 Emotional Footprint Champion

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

Emotional Footprint Overview

+91 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.

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.

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.

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.

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

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

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

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.

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.

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.

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.

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 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.

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 IT Administration This data indicates whether IT personnel will be able to resolve issues and perform configurations efficiently and effectively.

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.

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.

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

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

Mohammad f.

Go to product for my daily work

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

Title

Feature Ratings

Data Security

Real Time Integration

iPaaS

Administrative Features

Batch Integration

Synchronization and Replication

Exception Handling and Notifications

Data Virtualization

API Management and Orchestration

Multi Channel Support

Metadata Management

Vendor Capability Ratings

Quality of Features

Ease of Data Integration

Business Value Created

Breadth of Features

Usability and Intuitiveness

Ease of Implementation

Availability and Quality of Training

Ease of IT Administration

Vendor Support

Ease of Customization

Product Strategy and Rate of Improvement