使用Azure Data Factory for Azure VM中运行的SQL创建基于事件的触发器 [英] Creating Event based triggers using Azure Data Factory for SQL running in Azure VM

问题描述

设置:

Azure搜索< -------- Azure数据工厂(复制管道)--------> SQL(在Azure VM上运行，而不是Azure SQL).

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

要求:

当管道在SQL上完成并且数据可用时.我们需要一个触发器来通知ADF从SQL中提取数据并将其转储到Azure搜索中.

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.

ADF的文档仅在Azure存储blob上讨论事件触发器.有没有办法在sql中配置此事件?

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

SQL管道完成后，我又想到了调用ADF.想知道是否有一种从SQL端触发ADF的方法吗?

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.

推荐答案

当前，事件触发器仅支持Blob事件.也许您可以看一下SQL触发器 逻辑APP ?

Currently, Event trigger only supports Blob Event. Maybe you could take a look at SQL trigger in Logic APP?

这篇关于使用Azure Data Factory for Azure VM中运行的SQL创建基于事件的触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！