AnsweredAssumed Answered

Is it possible to update an AF attribute using PI OLEBD Enterprise?

Question asked by wilsona on Jul 15, 2015
Latest reply on Jul 16, 2015 by dng

Hi community,

 

I have thousands of Elements (all templatised) in an  AF hierarchy, each of element has a number of attributes that I would like to periodically update the value of. Ideally I would not have to resort to AF SDK code. These attributes are not PI Point Data References in fact they have no data reference. I use these these attributes in analyses and I want to to avoid using Table Lookup for performance reasons.

For me the easiest way would be if I could write an SQL stored procedure which periodically updates the values using a linked server (using the PI OLEDBD Enterprise provider).

 

Is this possible?

 

Cheers,

 

Arthur

Outcomes