AnsweredAssumed Answered

Store AF Analysis/ Notification Event in MS SQL Database

Question asked by PJain on Aug 9, 2020
Latest reply on Aug 12, 2020 by sraposo

Hello Folks,


Greetings for the day!


We are using PI Analysis to generate and send SMS & email notification to the designated users. The event for these notification is trigger is based on some complex condition based on around 100 signals. This Logic is too is written in PI Analysis. 


We have more than 5000 such notification rules (expanding on regular basis) written in AF, and is working all good. Recently, we have a new requirement that once this notification rule condition is meet we need to make one entry in our SQL database on realtime. Should some one suggest me an appropriate way of doing this, may be we could do in AF or we have to write custom code to fetch this data and store in our SQL database. Please note these notification rules will be active/ True only for few seconds (i.e some time less then 5 seconds as well)


Thank you in advance.


Thanks & Regards,

Paresh Jain