j.rao

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.

Outcomes