I need to install the PI OLEDB PROVIDER, is it good practise to install the PI OLEDB on interface machine.
It is generally okay to install the PI OLEDB provider on the interface node. PI OLEDB behaves like an interface as well. However, if your interface server is having performance issue, then you might want to reconsider to install it in another box. Also, when you install PI OLEDB provider, you might need to upgrade your PI SDK depends on your version of the PI SDK at the interface node.
I also wanted to mention, we have a PI OLEDB Enterprise which look at data in the AF server.
PI OLEDB Provider will look at data in the PI Data Archive.
Here is the documentation for PI OLEDB Provider. https://techsupport.osisoft.com/Downloads/File/4726a972-57d2-45f4-b407-43ca03992971
Retrieving data ...