AnsweredAssumed Answered

Connecting PI Processbook with SQL Server Automatically

Question asked by PeteHerz on Jun 30, 2014

Good morning there!


Is there any way to immediately sign in to a protected database when opening a PI display?


Right now I have PI Calculations performing sql queries and pulling back specific TOP 1 results.  However the database is protected and users have to sign in when opening the display to see the query results.  I'm not sure if there is a way to automate this or am I stuck having to build my VBA code to include opening the database connection performing all of the queries and then refreshing on a set time interval.


Any help would be appreciated!