1 Reply Latest reply on Mar 15, 2019 12:34 PM by vkaufmann

    PI OLEDB Provider and PI AF

    MariaMoore

      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!

       

      Maria

       

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