Design an Azure based Architecture for ingesting data from on prem sql servers to a azure generation 2 datalakes

Question

Accepted Answer

Design Azure architecture for ingesting data from on-prem SQL servers to Azure Gen 2 datalakes

Create a virtual network to connect on-premises SQL servers to Azure
Use Azure Data Factory to move data from on-premises SQL servers to Azure Data Lake Gen 2
Use Azure Data Factory to schedule data ingestion jobs
Use Azure Data Factory to transform data before ingestion
Use Azure Data Factory to monitor data ingestion jobs
Use Azure Data Factory to trigger alerts in case of job failures