Skip to main content
Solved

Database listeners to send real-time e-mail notification with FME Server

fmelizard
Contributor
Forum|alt.badge.img+17

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!

Best answer by stalknecht

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

View original
Did this help you find an answer to your question?

3 replies

stalknecht
Contributor
Forum|alt.badge.img+19
  • stalknechtContributor
  • Contributor
  • Best Answer
  • August 29, 2017

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

P
  • pholmes
  • August 31, 2017

@stalknecht - Thank you very much!

helmoet
Forum|alt.badge.img+8
  • helmoet
  • March 15, 2018

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


Helpful Members This Week

Community Stats

30,912
Posts
117,125
Replies
38,717
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.