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

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
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

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.

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

Data Transformations

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

8.5
Avg 8.4

Data Modeling

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

7.7
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.2
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-7 of 7)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Data Integration: We harness Azure Data Factory's capabilities to move data from various sources – both on-premises databases and cloud storage – into our Azure data storage solutions like Azure SQL Database, Azure Blob Storage, and Azure Data Lake Store. This ensures all our data, regardless of its origin, is consolidated in one place.
Transformations: Azure Data Factory's data flow transformations help us clean, transform, and enrich our data before loading it to the destination. This is crucial for maintaining data quality, especially when dealing with diverse datasets.
Rajarshi Maitra PMI™- ASM®, ACP® and CAPM® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
One of the best Data Integration tools for both ETL and ELT. I have been using ADF for the last 6+ years and it helped me in extracting several data feeds within our organization that meets our specific business needs. The tool provides many features such as Move and Transform, Data explorer, Azure Functions, Data bricks, Data Lake Analytics, Blob Storage, Linked services, Machine Learning, and Power Query.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Azure Data Factory to orchestrate ETL and ELT pipelines in our projects and it has a wide range of data connectors right from classic(FTP) and modern data lake storage like ADLS and AWS S3. Using the Dataflow and SSIS integration runtime server, it can perform complex transformations without the need for another tool. Executing and Monitoring ETL loads the data factory is very simple and user-friendly.
Niloofar Keshvari Nia | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Get full data integration at scale with Microsoft Azure Data Factory's management service for serverless data integration,‌ hybrid data integration is easily and agilely possible through this software. We are creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code. Full management and serverless integration with default features installed on the system and various connectors reduce costs. It is used in all company departments and project management units of our customers. Since ADF adopts an intelligent intent-driven mapping methodology, it enables copy activities to be automated.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
Return to navigation