Skip to main content
Question

Can I send by email the new record added to a table that is in a database?? thanks

J

Can I send by email the new record added to a table that is in a database? and each time there is a new record send me an email

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+48

Short answer: yes.

Longer answer: can you tell us a bit more? Are you using FME to add the new records? If so, an Emailer transformer at the end of that workspace should do the trick. Do you want to send an email for every record? How many are you adding per transaction? Per day?

J
  • joeroses
  • Author
  • October 4, 2019
redgeographics wrote:

Short answer: yes.

Longer answer: can you tell us a bit more? Are you using FME to add the new records? If so, an Emailer transformer at the end of that workspace should do the trick. Do you want to send an email for every record? How many are you adding per transaction? Per day?

No, i am working with a table in Oracle and when a new record is added i need to send that record to a user by email.
redgeographics
Celebrity
Forum|alt.badge.img+48
joeroses wrote:
No, i am working with a table in Oracle and when a new record is added i need to send that record to a user by email.
In that case you need to set up a database trigger that fires after the insert and have that run an external application, which could be FME, sending you an email.

Reply


Helpful Members This Week

Community Stats

30,922
Posts
117,196
Replies
38,727
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.