We performed a comparison between AWS Lake Formation and Azure Data Factory based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"The solution has many features that are applicable to events such as audits."
"It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services."
"We use AWS Lake Formation typically for the data warehouse."
"The most important advantage in using AWS Lake Formation is its ability to connect the data lake to the other technologies in AWS. This is what I advise my clients."
"The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."
"The trigger scheduling options are decently robust."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"In terms of my personal experience, it works fine."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"The solution is okay."
"In our experience what could be improved are not the support, performance or monitoring, but at a managerial level, the very expensive professional services of AWS. This could be an area of improvement for them. It's too expensive to acquire their support."
"AWS Lake Formation's pricing could be cheaper."
"It falls short when it comes to more granular access control, such as cell-level or row-level entitlements which is a significant drawback for organizations that require precise control over who can access specific rows of data."
"For the end-users, it's not as user-friendly as it could be."
"The solution could make improvements around orchestration and doing some automation stuff on AWS front automation. It would be useful if we could use automation to build images and use hardened images which are CIS compliant."
"Some known bugs and issues with Azure Data Factory could be rectified."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"Data Factory has so many features that it can be a little difficult or confusing to find some settings and configurations. I'm sure there's a way to make it a little easier to navigate."
"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."
"I rate Azure Data Factory six out of 10 for stability. ADF is stable now, but we had problems recently with indexing on an SQL database. It's slow when dealing with a huge volume of data. It depends on whether the database is configured as general purpose or hyperscale."
"The initial setup is not very straightforward."
"When the record fails, it's tough to identify and log."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews. AWS Lake Formation is rated 7.6, while Azure Data Factory is rated 8.0. The top reviewer of AWS Lake Formation writes "Strategically aligning data management in a multi-cloud environment with significant reporting challenges". On the other hand, the top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". AWS Lake Formation is most compared with Snowflake, Amazon Redshift, Microsoft Azure Synapse Analytics, BigQuery and Apache Hadoop, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Denodo. See our AWS Lake Formation vs. Azure Data Factory report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.