AnsweredAssumed Answered

How to use PI OLEDB Enterprise View to determine the change in tag value between a Start Time and End Time

Question asked by stevensnashall on Dec 12, 2019

A downstream java based application needs to use PI JDBC via a PI SQL DAS middleware deployment to query AF Attributes to determine:

  1. Current Value of a set of PI AF Attributes
  2. "Delta" or change in PI AF Attribute tag value between a given Start Time and End Time


Both of these queries need to be able to parse the query time (Start and End Time for query 2 above) as they will be dynamic.



  1. Is it possible to have parameters in an OLEDB Enterprise View?
  2. Do you have any tips / examples of using Stored Procedures via a Linked SQL Server with PI SQL DAS?


Appreciate any help anyone can provide.