AnsweredAssumed Answered

SQL link to PI - how do you do it?

Question asked by caffreys_col on May 23, 2019
Latest reply on May 24, 2019 by jyi

I've been asked if it is possible to connect PI to a SQL database, so that the SQL database can run queries against the PI server to retrieve data. I know its possible but when looking at the options (PI OLEDB enterprise, PI OLEDB Provider, Pi ODBC driver, PI SQL client) its all getting a little confusing. Can anyone give a brief guide as to what the differences are between each one, or even what might be the best solution? The application is for corporate reporting, and the existing solution uses an SQL database to pull data from various data historians (including PI), but we have no details on how the PI solution is working.

 

Thanks

 

Col

Outcomes