We are planning to use MS SQL Server linked server concept to connect to OSI PI servers using PI OLEDB.
Does this require PI AF to be installed and available?
No, PI OLEDB Provider is based on PI SDK which doesn't know anything about the Asset framework.
One the other hand, there is a lot of value using PI Asset Framework and additional value comes with Asset Analytics and PI Notifications. What keeps you away from using it?
Retrieving data ...