mikeloria

PI Notification Delivery Channel to Database Table

Discussion created by mikeloria on Nov 8, 2012
Latest reply on Nov 9, 2012 by Mike Zboray

How can I take a notification event and write results to an Oracle database? 

 

One solution I am considering is to create a custom delivery channel that makes a call to a web service for a notification when it triggers. I will have multiple notifications using the same channel so it will need to be able to identify itself (which notification). I would also like to send the current values of a number of attributes from different elements in this web service call

 

I am not sure how to accomplish this so any example or advise is greatly appreciated.

 

 

 

Here is some info on what I need to achieve and why

 

Requirement Detail

 

I have a requirement to monitor particular PI tags and determining when the value falls outside of a range. I need to create a record in an Oracle database with the beginning and end time that the value fell out of range and then fell back in again plus I will gather other PI data as well for the event. I already plan to use AF to set up elements with the min/max values and use an enumerated formula to determine the state (normal, out of range high, out of range low,...)

 

I was first considering writing a standalone process to monitor each element but would really like to leverage PI Notifications. 

 

Basically, my question is:

 

What is the best way to write the results of a number of tags to an oracle table record on a PI notification trigger? I am thinking that somehow I would have a delivery channel write to a web service. Does anyone else have any suggestions of solving this? Maybe even something outside of notifications if there is a more feasible way? I was ruling out event frames for this because we are using some standard report making tools ad also will be forming relationships with this table against existing tables.

 

Also, if a web call is the best solution, I would greatly appreciate an example or any examples for other ideas.

 

I greatly appreciate any and all help in this

 

Thank You

Outcomes