AnsweredAssumed Answered

Connect third-party software using PI OLEDB Enterprise

Question asked by MattLueders on Jun 8, 2020

I am working to connect our OSI Pi Asset Frameworks server to our Water Distribution System hydraulic model (using Bentley WaterGEMS software).  We were successful in connecting to our Pi Server, but I want to import Attribute References (calculated values) from the AF system into the model also to make various corrections and am having trouble discovering the proper tables and SQL statements to accomplish this.  I've searched the web for a description of the table structure, but have found myself using trial and error, so any assistance you can provide will be very much appreciated.

 

Outcomes