I have on-premises sql server database. I need to load data from this DB to azure DW.
What is the best solution?
I am good in classic ETL using SSIS.
When I search google, there are many options like traditional ETL(SSIS), ADF, Polybase, Azure BLOBs
I am confused which one to use. I need to perform incremental load and schedule a job to refresh