Skip to main content
  • EN

Hello,

I want to create a workflow that will monitor updates to tabular SQL Servers tables, which would send email notifications when my workbench has updated "error" tables. My workspace is effectively processing data and writing these error tables.

But I am unsure of the best way to create database "listeners" that would note when new data has been added to an error table and then send out an email notification via FME Server.

We have FME Server up and running and it does send email notification for when the workspace fails to run. But we have never sent email notifications for when a SQL Server table has been updated.

Can anyone provide some suggestions on how to best do this with some links and possibly an example work bench that "Listens" for database updates?

 

 

Thank you!

You can use a database trigger. See: https://knowledge.safe.com/articles/806/push-data-out-of-databases-to-fme-server-in-real-t.html

@stalknecht - Thank you very much!

Yep, @stalknecht @FMELizard, that would do the trick, alternatively one could use a schedule and an FME Workspace to check the contents of the table, however that would be less event-driven.

Reply


Community Stats

30,108
Posts
114,284
Replies
37,742
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.