Configuring Azure Data Factory to Azure SQL VM private (not managed or Azure SQL)

Question

An azure sql VM (not managed or Azure SQL) has a public IP (204.x.x.x) and a private IP (10.0.0.x) in the managed vnet.
Data factory can connect and consume the public IP like any sql server without a fuss.
There doesn't seem to be a way to connect to the private vnet. This documentation for on-prem doesn't seem to work and involves a hop-host in the vnet:
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
(all that's desired here is for the same functionality that can be yielded by the VM's public IP, but on the private side).

Answer 1

Hi Shaik ;
Not on-prem just a data factory bi-directional to an azure hosted SQL-VM, data flows and pipelines.
For Azure SQL (Non-VM) - the linked services can be made from the subscription. But SQLVMs are not available there.
The current advice seems to be to either add an integration runtime to the VM or do something similar to the on-prem article I mentioned.
Thanks for looking into it.