4

I've done a fair bit of reading and it seems like there are a couple of off-the-shelf products that replicate/sync data from on-premise database to Azure SQL Data Warehouse but I've found nothing that syncs using an Azure database as the source. The Azure Data Factory holds some promise however it looks more suited to one off loads.

Anyone know of a way? (SSIS package not really an option as I want the transfer to occur wholly inside the cloud)

Ram
  • 3,092
  • 10
  • 40
  • 56
Sean
  • 43
  • 3

1 Answers1

4

Azure Data Factory can run continuous loads from SQL Database to SQL Data Warehouse. You'll want to look into the frequency and interval parameters for the pipeline

The documentation is here https://azure.microsoft.com/en-us/documentation/articles/data-factory-create-datasets/.

santiaago
  • 608
  • 9
  • 19
Matt Usher
  • 1,325
  • 6
  • 10
  • I was asked this question recently. The maximum interval you can set Azure Data Factory at the moment is 15 minutes, so not real-time, or even near-real time. Is there an update on this? Thanks. – wBob Jun 29 '17 at 12:13
  • What are you trying to accomplish with the real time sync to a data warehouse? I can help but a little context would be helpful. – Matt Usher Jun 29 '17 at 17:29