The go-to ETL tool for most situations
Data Integration: We harness Azure Data Factory's capabilities to move data from various sources – both on-premises databases and cloud …
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…
Recent 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
- Connect to traditional data sources (7)9.292%
- Simple transformations (7)9.292%
- Connecto to Big Data and NoSQL (7)9.090%
- Complex transformations (7)7.777%
Reviewer Pros & Cons
- Azure Data Factory provides a unified monitoring dashboard that offers a holistic view of all pipeline activities. I think this makes it easier for us...
- Granularity of Errors: Sometimes, Azure Data Factory provides error messages that are too generic or vague for us, making it challenging to pinpoint t...
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.
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
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 Systems | Unspecified |
|---|---|
| Mobile Application | No |
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).
Comparisons
Compare with
Reviews and Ratings
(57)Attribute Ratings
Reviews
(1-7 of 7)Companies can't remove reviews or game the system. Here's why
September 14, 2023
The go-to ETL tool for most situations
- Azure Data Factory supports a vast array of source and destination connectors, both from within the Microsoft ecosystem (like Azure Blob Storage, Azure SQL Database, Azure Cosmos DB) and external platforms (like Amazon S3, Google Cloud Storage, SAP, Salesforce, and many more).
- Azure Data Factory's Mapping Data Flows provides a code-free environment to design data transformations visually. Users can drag and drop elements to create complex ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes without needing to write any code.
- Azure Data Factory provides a unified monitoring dashboard that offers a holistic view of all pipeline activities. I think this makes it easier for users to track the status of various jobs, identify failures, and pinpoint bottlenecks.
- Granularity of Errors: Sometimes, Azure Data Factory provides error messages that are too generic or vague for us, making it challenging to pinpoint the exact cause of a pipeline failure. Enhanced error messages with more actionable details would greatly assist us as users in debugging their pipelines.
- Pipeline Design UI: In my experience, the visual interface for designing pipelines, especially when dealing with complex workflows or numerous activities, can become cluttered. I think a more intuitive and scalable design interface would improve usability. In my opinion, features like zoom, better alignment tools, or grouping capabilities could make managing intricate designs more manageable.
- Native Support: While Azure Data Factory does support incremental data loads, in my experience, the setup can be somewhat manual and complex. I think native and more straightforward support for Change Data Capture, especially from popular databases, would simplify the process of capturing and processing only the changed data, making regular data updates more efficient
November 12, 2022
One of the best and reliable ETL & ELT platforms for pulling data from multiple sources
- It allows copying data from various types of data sources like on-premise files, Azure Database, Excel, JSON, Azure Synapse, API, etc. to the desired destination.
- We can use linked service in multiple pipeline/data load.
- It also allows the running of SSIS & SSMS packages which makes it an easy-to-use ETL & ELT tool.
- For complex JSON when it comes to mapping nested attribute it's not easy to flatten out
- Data Factory V1 does not have a good implementation experience as compared to V2
- Work with on premise solutions sometimes is not too friendly because you will need to set a VPN
June 03, 2022
Azure Databricks
- Orchestration engine
- Low code Data pipeline
- Logic apps integration
- Error Flagging, Details of the error code is not specific especially faced this during Azure Table load
- Missing feature of Data exploration functionality similar to Synapse Data explorer
- missing access to orchestrate/create stream analytics job
June 22, 2021
Simple Solution to Data Migration
- Orchestration
- On premises support
- Support to vast no of data connectors
- Cloud migration
- Native transform functions missing.
- Pricing
- Limited trigger functions.
- Creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code.
- Hybrid data integration is easily and agilely possible through this software.
- It has lot of various useful components
- It should integrate more ETL and audit functionality.
- Pipelines lack flexibility because moving Data Factory pipelines between different environments, such as for development or testing, require increased security and flexibility.
- The number of pre-defined templates is small and they should have more variety.
January 20, 2021
ADF is awesome!
- Cloud-based
- Fast
- Reliable
- Some features exist on the UI but are not implemented
- Its always changing
July 24, 2020
Azure Data Factory - Don't Abandon SSIS Just Yet
- 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.