I'm trying to build daily ETL process from Azure SQL Database to on-premises SQL Server data warehouse.
I have experience in ETL between on-premises SQL Servers but when it comes to Azure I'm not sure the best practise. I did some researches and got the options on ETL and ADP.
Would anyone here have similar experience before, could shed me some lights? Any comment, example or tutorial are much appreciated.