locked
Creating Event based triggers using Azure Data Factory for SQL running in Azure VM RRS feed

  • Question

  • Hi,

    Setup:

    Azure Search <-------- Azure Data Factory (Copy Pipeline) --------> SQL (Running on Azure VM, not azure sql).

    Requirement:

    When the pipeline on completes on SQL and data is available. We need a trigger to inform ADF to pull data from SQL and dump it in Azure Search.

    The documentation of ADF talks about the event triggers only on Azure Storage blob. Is there way to configure this event in sql?

    I had one more thought of invoking ADF once the SQL pipeline completes. Would like to know is there a way to trigger ADF from the SQL side? 


    Komal.

    Tuesday, November 13, 2018 4:52 AM

All replies

  • Currently, Event trigger only supports Blob Event. Maybe you could take a look at SQL trigger in Logic APP?
    • Proposed as answer by Jason_J (Azure) Wednesday, November 14, 2018 5:36 PM
    Wednesday, November 14, 2018 2:40 AM