Simple Solution to Data Migration
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 …
Azure Data Factory
Azure Data Factory
Overview
Recent Reviews
Popular Features
View all 12 featuresConnect to traditional data sources (5)
9.2
92%
Simple transformations (5)
8.9
89%
Connecto to Big Data and NoSQL (5)
8.7
87%
Complex transformations (5)
8.3
83%
Reviewer Pros & Cons
View all pros & cons
Niloofar Keshvari Nia
IT Operations and Support Specialist
AZEREX LLC. (Information Technology & Services, 1-10 employees)Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Azure Data Factory, and make your voice heard!
Pricing
View all pricingN/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 80…
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?
3 people want pricing too
Alternatives Pricing
What is Fivetran?
Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…
What is Oracle GoldenGate?
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Features Scorecard
Data Source Connection
8.9
89%
Data Transformations
8.6
86%
Data Modeling
8.8
88%
Data Governance
8.3
83%
Product Details
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 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.
Azure Data Factory Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
View all alternatives
Frequently Asked Questions
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 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.
What is Azure Data Factory's best feature?
Reviewers rate Data model creation highest, with a score of 9.4.
Who uses Azure Data Factory?
The most common users of Azure Data Factory are from Mid-sized Companies (51-1,000 employees) and the Information Technology & Services industry.
Reviews and Ratings
 (40)
Reviews
(1-5 of 5)- Popular Filters
Companies can't remove reviews or game the system. Here's why
June 22, 2021
Simple Solution to Data Migration
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.
- Orchestration
- On premises support
- Support to vast no of data connectors
- Cloud migration
- Native transform functions missing.
- Pricing
- Limited trigger functions.
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.
- 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.
Thanks to the implementation of Azure as software for our data integrations we have been able to transport different data structures to the cloud without losing any content, with entirely automated movements that we have been able to leverage in several ways: one of them was to streamline the creation of funnels, so that we could transform the data before transporting it. It does not require prior configuration of some kind of ETL process to write code, since the platform lets you do it by itself, and without the need to necessarily create an environment where data traffic is intuitive. That is to say, it can be used to create varied programming environments. Basically creates a layer where data is integrated in different ways, whether or not business intelligence or IT mechanics are being used to integrate with analytics software. Creates very fast transformations where data mapping can be managed so that it carries some level of intelligence, and data source copy operations require less manual review and management.
- Once a sales funnel is defined and configured, it can be interconnected to another, so that we can create a complete network where it is possible to monitor the different executions of each funnel linked to our data from one place.
- Azure Data Factory promotes excellent data management strategies, which we have been able to leverage during the workday, and all thanks to the help provided by their support team, which from the beginning of our interactions kept us properly informed about solutions to every issue that arose.
- An advantage of Data Factory is that data structures can be stored in several warehouses at the same time, and these can be moved from one warehouse to another by configuring a trigger that is automatically executed when certain predefined parameters are met, such as the generation of a blob within the platform.
- Azure Data Factory has helped us to carry out data assignments with much more integrity and comfort, and we will continue to use it, given its excellent ease of execution of administrative operations and its incredible approach to business intelligence management.
- Creating data infrastructures without prior design is entirely possible with Azure, as the platform properly defines all the processes to be followed to create a solid foundation for information and data flows.
- If you are working with Azure synapse Analytics you have to keep in mind that the collection of all local data is not properly handled when integrating it to data Factory, and this can result in problems in the long run if you have not been able to transform the data into other streams.
- There are very few data sets allowed by the platform, the most adaptable being blob and SQL as tables, but it leaves out many other dynamics that are currently used, such as string and raw SQL data coming from database services like MongoDB.
- It is not recommended for working with machine learning mechanics, mostly because the reports handled within the platform have restructurable formats, but do not adapt correctly to services such as PowerBI.
January 20, 2021
ADF is awesome!
I've used it to perform PoC's and work with data transformation processes that interact with other applications or tools.
- 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
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.
- 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.