Azure Data Factory vs. Azure Virtual Machines

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Data Factory
Score 8.3 out of 10
N/A
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.N/A
Azure Virtual Machines
Score 7.9 out of 10
N/A
Virtual Machines (VMs) are available on Microsoft Azure, providing what is built as a low-cost, per-second compute service, available via Windows or Linux.
$0
Per Hour
Pricing
Azure Data FactoryAzure Virtual Machines
Editions & Modules
No answers on this topic
3 Year Reserved - Burstable VMs - B1S
$0.0038
Per Hour
Spot - General Purpose - Av2
$0.005
Per Hour
1 Year Reserved - Burstable VMs - B1S
$0.0059
Per Hour
Pay as You Go - Burstable VMs - B1S
$0.0075
Per Hour
Spot - Compute Optimized - Fsv2
$0.0104
Per Hour
Spot - General Purpose - Dv3
$0.0125
Per Hour
Spot - Memory Optimized - Ev3
$0.016
Per Hour
3 Year Reserved - Compute Optimized - Fsv2
$0.0307
Per Hour
3 Year Reserved - General Purpose - Dv3
$0.0369
Per Hour
3 Year Reserved - Memory Optimized - Ev3
$0.0481
Per Hour
1 Year Reserved - Compute Optimized - Fsv2
$0.05
Per Hour
1 Year Reserved - General Purpose - Dv3
$0.0548
Per Hour
1 Year Reserved - Memory Optimized - Ev3
$0.0753
Per Hour
Pay as You Go - Compute Optimized - Fsv2
$0.0846
Per Hour
Pay as You Go - General Purpose - Dv3
$0.096
Per Hour
Pay as You Go - Memory Optimized - Ev3
$0.126
Per Hour
Offerings
Pricing Offerings
Azure Data FactoryAzure Virtual Machines
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Azure Data FactoryAzure Virtual Machines
Considered Both Products
Azure Data Factory

No answer on this topic

Azure Virtual Machines
Chose Azure Virtual Machines
In comparison with AWS EC2, it is easier to deploy using the GUI, when it comes to using CLI is pretty much the same.
Features
Azure Data FactoryAzure Virtual Machines
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Azure Data Factory
8.0
8 Ratings
2% below category average
Azure Virtual Machines
-
Ratings
Connect to traditional data sources9.08 Ratings00 Ratings
Connecto to Big Data and NoSQL7.18 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Azure Data Factory
8.0
8 Ratings
1% below category average
Azure Virtual Machines
-
Ratings
Simple transformations9.08 Ratings00 Ratings
Complex transformations7.08 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Data Factory
7.2
8 Ratings
8% below category average
Azure Virtual Machines
-
Ratings
Data model creation7.06 Ratings00 Ratings
Metadata management7.07 Ratings00 Ratings
Business rules and workflow7.08 Ratings00 Ratings
Collaboration7.97 Ratings00 Ratings
Testing and debugging6.08 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Azure Data Factory
7.0
8 Ratings
12% below category average
Azure Virtual Machines
-
Ratings
Integration with data quality tools6.08 Ratings00 Ratings
Integration with MDM tools8.07 Ratings00 Ratings
Server Virtualization
Comparison of Server Virtualization features of Product A and Product B
Azure Data Factory
-
Ratings
Azure Virtual Machines
7.2
24 Ratings
11% below category average
Virtual machine automated provisioning00 Ratings8.124 Ratings
Management console00 Ratings4.222 Ratings
Live virtual machine backup00 Ratings6.220 Ratings
Live virtual machine migration00 Ratings8.716 Ratings
Hypervisor-level security00 Ratings9.017 Ratings
Best Alternatives
Azure Data FactoryAzure Virtual Machines
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
DigitalOcean Droplets
DigitalOcean Droplets
Score 9.4 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
VMware vSOM (discontinued)
VMware vSOM (discontinued)
Score 10.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
VMware vSOM (discontinued)
VMware vSOM (discontinued)
Score 10.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Data FactoryAzure Virtual Machines
Likelihood to Recommend
8.1
(8 ratings)
9.2
(24 ratings)
Usability
8.0
(1 ratings)
9.0
(1 ratings)
Support Rating
7.0
(1 ratings)
7.0
(1 ratings)
User Testimonials
Azure Data FactoryAzure Virtual Machines
Likelihood to Recommend
Microsoft
Well-suited Scenarios for Azure Data Factory (ADF): When an organization has data sources spread across on-premises databases and cloud storage solutions, I think Azure Data Factory is excellent for integrating these sources. Azure Data Factory's integration with Azure Databricks allows it to handle large-scale data transformations effectively, leveraging the power of distributed processing. For regular ETL or ELT processes that need to run at specific intervals (daily, weekly, etc.), I think Azure Data Factory's scheduling capabilities are very handy. Less Appropriate Scenarios for Azure Data Factory: Real-time Data Streaming - Azure Data Factory is primarily batch-oriented. Simple Data Copy Tasks - For straightforward data copy tasks without the need for transformation or complex workflows, in my opinion, using Azure Data Factory might be overkill; simpler tools or scripts could suffice. Advanced Data Science Workflows: While Azure Data Factory can handle data prep and transformation, in my experience, it's not designed for in-depth data science tasks. I think for advanced analytics, machine learning, or statistical modeling, integration with specialized tools would be necessary.
Read full review
Microsoft
If you want to host a dedicated Windows server on the cloud, and especially if you want to integrate it with your on premises Active Directory, Azure Virtual Machines should be your first choice. Obviously running Linux on Azure works very well too, but given Azure's pricing is not the cheapest, there are other providers out there that have a better cost-benefit ratio for Linux. That said, hosting Windows on Azure can be affordable (especially when compared to other providers) if you plan your licensing, topology, and application architecture correctly.
Read full review
Pros
Microsoft
  • 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.
Read full review
Microsoft
  • When demand is high, we scale the service out, eg During a Football Match.
  • When a football match is over and the throughput of data from OPTA drops we save by the service scaling back in.
  • Our App Service Plans along with the Clean C# code are lightening fast giving a good customer experience.
  • When producing the TV Guide information and a program overruns its scheduled time, a client can instantly be updated to the new programming schedule as our change is instant and its in the right place for all the clients to download and adjust their television guides appropriately to send out to the public giving a 24x7 uptime service that is precise and accurate and resilient to outages due to failover zones around the world.
Read full review
Cons
Microsoft
  • 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.
Read full review
Microsoft
  • Pricing can be a concern if you are truly agnostic to which cloud you are building your particular solution in.
  • The UI, as is the case with any cloud provider, is crowded.
  • As with any cloud provider, it can be difficult to tune in exactly the right amount of servers for your needs...you might find yourself under/overprovisioning.
Read full review
Usability
Microsoft
So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.
Read full review
Microsoft
No VM console, weak management interface, changing CPU/memory is not straightforward. On the positive side, basic RDP functionality is good to have. As long as things are working, the ability to host Windows VMs is appreciated.
Read full review
Support Rating
Microsoft
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
Read full review
Microsoft
I give the overall support for Azure Virtual Machines a 7 because I think while the overall support do a great job there are still areas that it could improve on such as efficiency and speed. So while I only give it a 7 and it has some issues it is still better than the overall support at Amazon EC2 Auto Scaling.
Read full review
Alternatives Considered
Microsoft
The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.
Read full review
Microsoft
Azure Virtual Machines offer unparalleled flexibility in provisioning, managing and upgrading the VM instances, both manually and programmatically. AVM offer very granular billing options and enables high costs optimisations (while still being costly). The other competitors I mentioned are very good at offering dead-cheap VMs. But if you need anything beyond that, especially for big computing, you need Azure Virtual Machines.
Read full review
Return on Investment
Microsoft
  • It is very useful and make things easier
  • Debugging can improve
  • Its better suited than other products with the same objective
Read full review
Microsoft
  • It's so easy to spin up new instances, that it becomes also to easy to have to many of them to manage. Many teams end up with a couple of hundreds of VMs after a short while, making the whole thing very hard to maneuver
  • Azure VMs are the next step for us to rely on Onprem servers, and leaving the management of the infrastructure to the professionals
  • The ease of use, is also important when our main focus is to deliver new applications and integrations fast, and not having to worry about infrastructure. We sell bottles, not CPUs
Read full review
ScreenShots