Hi, I work at OSIsoft and I am the Product Manager for the PI OLEDB Enterprise provider you are talking about. We had a similar question posed on our own discussion forums (on the OSIsoft Virtual Campus, or vCampus), so I tried it myself and I could indeed reproduce. When I enabled logging on the PI OLEDB Enterprise side, however, I discovered a few strange behaviors (e.g. fetching the metadatata (the columns) but not the data (the rows), constant reinitialization of the session), so I contacted the ESRI tech support to clear this up. I will try and follow-up here when I get somewhere with them. Did you open a ticket with them already? Did they find anything? That being said, it is unlikely that you will utilize the tables directly in PI OLEDB Enterprise; your asset structure can be rather large and this can make up for complex SQL queries. Chances are you will rather create a view to wrap up a more complex query - and getting data from views worked for me in the ESRI software. If you are unsure about the kind of queries, views, etc. you should create with PI OLEDB Enterprise, I invite you to post your question on the OSIsoft vCampus - the equivalent to ESRI Development Network, but on the OSIsoft side 😉
... View more