AnsweredAssumed Answered

PI OLEDB Provider and PI AF

Question asked by MariaMoore on Mar 15, 2019
Latest reply on Mar 15, 2019 by vkaufmann

Hello All!


Just wanted to check my understanding of the abilities of PI OLEDB Provider vs. PI OLEDB Enterprise.


  • PI OLEDB Provider gives you the ability to run queries against the PI Data Archive
  • PI OLEDB Enterprise gives you the ability to run queries against PI AF Servers


I know the two have the ability to do other things on top of SQL queries, but I am looking at the aspect of writing a query against AF to get elements and attributes.


Is there no way of accessing the PI AF elements using the OLEDB Provider?




Thank you!




p.s. I used this to get my information Exposing PI Data with the PI SQL Framework Discussion Forum