I would like to copy our data from Azure SQL (OLTP) into Azure Datawarehouse. I want the path to be close to real time.
The Microsoft system looks it takes two steps copying data from SQL Server into Azure Data Warehouse.
First into Blob Storage with Azure Data Factory
and then with Polybase into Azure Datawarehouse.
It looks like a two step ETL and not close to real time.
Does Microsoft have any simpler way of copying data from Azure SQL into DW for analytics?