AnsweredAssumed Answered

PI-OLEDB vs PI-ODBC

Question asked by bjsower on Sep 9, 2020
Latest reply on Sep 10, 2020 by jyi

Is there a white paper or any information that does a comparison and contrast of these two methods for doing SQL queries against PI AF and/or the PI Archive.  Is one recommended over the other?  Is one better at certain types of queries than the other?  Does one perform better than the other?  I have been using PI-OLEDB classic for a long time, but have not used PI-OLEDB enterprise nor PI-ODBC.  Do both use PI SQL DAS (RTQP)?  Do the PI-OLEDB and PI-ODBC drivers still rely on the PI and/or AF SDK's?

Outcomes