none
Real time SQL server Data to ADL

    Question

  • Hi Guys,

    We have On premises SQL server 2016 server; we would like to get data from SQL server to ADL with max of 2 minute delay per table; How is it possible?

    Use ADF simple flow per table to ADL?

    or

    https://mrfoxsql.wordpress.com/2017/07/12/streaming-etl-send-sql-change-data-capture-cdc-to-azure-event-hub/

    or

    https://mrfoxsql.wordpress.com/2016/06/23/azure-cortana-intelligence-suite-with-azure-data-catalog/

    Regards,

    Navin


    Navin.D http://dnavin.wordpress.com


    • Edited by Navind Thursday, July 12, 2018 5:37 PM
    Thursday, July 12, 2018 4:55 PM

All replies

  • Both ADF and stream analytics can be used.

    I think with azure data factory, it will be easy to setup the migration workflow and scheduling the data transfer.

    How often are you gonna transfer? Are you gonna move data every 2 minutes? In that case, Please use pricing calculator to determine, ADF might be expensive in that case.


    Thursday, July 12, 2018 10:38 PM
    Moderator