1

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?

enter image description here

0

You may want to consider using Striim as mentioned here by Microsoft Program Manager of Azure SQL Data Warehouse. Ellis Butterfield.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy