PI ACE and SQL Reference data based on the MDB-AF context

Discussion created by j.rao on Oct 31, 2013
Latest reply on Oct 31, 2013 by Marcos Vainer Loeff

I am trying to accomplish an ACE calculation which works on few PI Tags and some reference data in a SQL table. When I scale this calculation to hundreds of equipment, I want to query the right set of reference data based on the equipment. 


AF has all the equipment (based on a template). One of the attributes is the Equipment ID.  


I want to query the context in MDB (MDB-AF sync) so I can use the right SQL data for the Equipment ID. 


Do I use AF SDK in the PI ACE calculation to query the context? If yes, how do I query the context?


Another way of achieving this is storing the reference data (back-filling) from SQL in PI Tags using PI RDBMS. I want to avoid this since it can be more maintenance in the future. 


I think AF Analytics should help with the way some calcs work. Eagerly awaiting its arrival!


Any thoughts are much appreciated.