Skip to main content
Solved

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

  • August 24, 2017
  • 3 replies
  • 108 views
fmelizard
Safer
Forum|alt.badge.img+21

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

stalknecht
Contributor
Forum|alt.badge.img+22
  • 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.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.