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.