Skip to main content
TrustRadius
Azure Data Factory

Azure Data Factory

Overview

What is Azure Data Factory?

Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own…

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Connect to traditional data sources (7)
    9.2
    92%
  • Simple transformations (7)
    9.2
    92%
  • Connecto to Big Data and NoSQL (7)
    9.0
    90%
  • Complex transformations (7)
    7.8
    78%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
Azure Data Factory

Azure Data Factory

N/A
Unavailable

What is Azure Data Factory?

Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

11 people also want pricing

Alternatives Pricing

Clear Analytics

Clear Analytics

$29
Per Seat per Month
What is Clear Analytics?

Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.

Vertify

Vertify

$7,350
per year
What is Vertify?

VertifyData is a cloud-based integration platform with core integration capacities, including a drag-and-drop interface and real-time synchronization. It also offers over 80 prebuilt connectors and templates, plus customizable integrations for scaling businesses.

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

9.1
Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

8.5
Avg 8.3

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

7.6
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

7.7
Avg 8.3
Return to navigation

Product Details

What is Azure Data Factory?

A fully managed, serverless data integration service that enables users to visually integrate data sources with more than 90 built-in, maintenance-free connectors. Users can construct ETL (extract, transform, and load) and ELT (extract, load, and transform) processes, code-free or optionally with code. Integrated data can then be sent to Azure Synapse Analytics to unlock business insights.

Azure Data Factory Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.

Reviewers rate Connect to traditional data sources and Simple transformations highest, with a score of 9.2.

The most common users of Azure Data Factory are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(57)

Attribute Ratings

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
July 24, 2020

Azure Data Factory - Don't Abandon SSIS Just Yet

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Azure Data Factory, particularly V2, offers a good option as a cloud-based ETL tool if you are leveraging the Azure cloud. We are using it as we begin to hybridize our on-prem data warehouse and applications with Azure. Up until now, we have leveraged SSIS for these purposes, but are beginning to migrate ETL and other data movement functions to the cloud, with Azure Data Factory as the primary utility.
Pros and Cons
  • Easy to set up and get started.
  • Runtimes make integration with on-prem data simple and also allow for support of existing investments in SSIS.
  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Likelihood to Recommend
If you are just getting started and all your data is resident in the Azure cloud, then Azure Data Factory is likely to work fine without having to jump through too many hoops. However, in a hybrid environment (which is most of them these days), ADF will likely need a leg up. It works well for scheduling and basic scheduling/orchestration tasks, but the feature set is not at a level with SSIS (which has been around for 15 years so...). As ADF now supports deploying SSIS, it is also a good candidate if large amounts of your data are resident in the Azure cloud and you have an existing SSIS investment in code and licensing. We are using it in a hybrid fashion for the data warehouse and will slowly transition over to ADF as the feature set improves. We are also using it for cloud-native applications that only require supplemental data from on-prem resources.
Azure Data Factory Feature Ratings
Data Source Connection (2)
70%
7.0
Connect to traditional data sources
60%
6.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
65%
6.5
Simple transformations
80%
8.0
Complex transformations
50%
5.0
Data Modeling (2)
60%
6.0
Business rules and workflow
60%
6.0
Testing and debugging
60%
6.0
Data Governance (2)
60%
6.0
Integration with data quality tools
70%
7.0
Integration with MDM tools
50%
5.0
Return on Investment
  • Limiting the amount of data moving up and down from the cloud for cloud-native applications.
  • Overall simple to use interface which is actually easier for a first time ETL developer than SSIS.
Alternatives Considered
Azure Data Factory is a relatively new player in the space, and its feature set marks it as such. It does not have the full features of a more mature product set such as any of the above. However, it does allow for the creation of ETL/ELT flows/pipelines with minimal initial training. I would actually consider it a more approachable product for a first time ETL developer (with the possible exception of AbInitio, which is highly intuitive). If you are an Azure shop, you at least want to look into it. If you're not, stick with one of the more mature offerings, or a 3rd party cloud-based tool that spans clouds. We are an Azure shop with an SSIS lineage, so it makes sense for us.
Support Rating
7
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue.
Other Software Used
Return to navigation