A downstream java based application needs to use PI JDBC via a PI SQL DAS middleware deployment to query AF Attributes to determine:
- Current Value of a set of PI AF Attributes
- "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.
- Is it possible to have parameters in an OLEDB Enterprise View?
- 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.