We have released the beta of our new product - BDC Alert Manager - head over to www.lightningtools.com and check it out for yourself, make sure you take a look at the screencast too to see it in action!
What it does.
BDC Alert manager allows you to set up email notifications on your BDC Data using custom rules!!!!
e.g.
if you have configured a Business Data Catalog (BDC) Application Definition File (ADF) for your Products Database and your database looks like:
| ProductID |
ProductName |
Price |
NumInStock |
| A1 |
Bike - Red |
25 |
6 |
| A2 |
Bike - Blue |
24 |
5 |
You can configure an alert to be sent to your supplier if NumInStock is less than or equal to 5 and then parse the information from your database into the email body
"Dear Supplier
We only have [NumInStock] left of the [ProductName] , please can you order us 10 more
Thanks"
and as you can guess the supplier will get an email saying
"Dear Supplier
We only have 5 left of the Bike - Blue, please can you order us 10 more
Thanks"
It is a great product and we look forward to your feedback on the beta!