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
0

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

0

Your Answer

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