Need alerts to trigger action to make entry into db table

Hi,

I've got a requirement for SMS integration for alerts. Basically, whenever there's an alert for nodes, the trigger/reset of the alert needs to execute an action that makes an entry into SMS DB table.

Then SMS agent installed on the DB server will grab the entry and relay the entry to SMS service provider.

I believe I could use Powershell script that can grab the alert details and make a table entry as per the SMS db table definition.

Has anyone done this type of SMS integration rather than using HTTP API?

It'd be great if someone could share insights on this.

Find more posts tagged with

sms integration

Accepted answers

All comments

m_roberts

What SMS solution are you working with. I have never worked with any that uses a mechanism of a DB insert being performed. Usually it is API, command line or script based.

If that is the only method, then yes I would write a PowerShell script to perform the DB update. That then depends on what the DB app being used is.

adam.beedell

First write a script to deposit the payload you're looking to put in the DB

Second add an alert action to run your script (External Program) when the event occurs

Pass data into the script using arguments on the action. And in the script referring to the argument variables.

There are obviously some complicated bits here, but that rough structure will work. Other structures are possible too.

roundrush

Thanks for the comment. SMS solution providers offer a variety of methods but certain businesses in the financial sector (at least in this country) prefer direct DB integration for mass SMS distribution. It's mostly for MySQL, Oracle DB.

KMSigma.SWI

I'm going to +1 @m_roberts here. If you can do this via a webhook or an API call do it that way. There are a few benefits, but the largest one would be that it'll be easier to troubleshoot if (when) things change. Many databases change the underlying schema (tables, views, indexes, etc.), but they rarely will change their API calls (and if they do, they normally give you plenty of warning).