I am pleased to announce the availability of the beta release PI ODBC 2014. This is our new implementation of the ODBC standard to access PI Server data. PI ODBC 2014 is compliant with version 3.8 the ODBC API and offers the same SQL query functionality as the PI OLEDB Enterprise Provider and the classic PI OLEDB Provider. The PI ODBC 2014 runs on Windows and has both 32-bit and 64-bit drivers in its installation kit.
PI ODBC 2014 Beta has been tested with several ODBC clients including Microsoft's time-honored Access database. PI ODBC 2014 also supports Oracle's Database Gateway for ODBC which is part of the Oracle Heterogeneous Connectivity suite. You may remember that Oracle discontinued support for OLEDB data sources in Version 11g which left us without an option to directly connect Oracle to the PI System. PI ODBC 2014 will finally solve that problem. To help you configure Oracle to use PI ODBC 2014, we've created an Oracle Database Gateway Configuration Guide.
PI ODBC 2014 is not a direct upgrade from our current PI ODBC Client 18.104.22.168. SQL query syntax and capabilities are different but we think you'll appreciate the improvements. PI ODBC 2014 can be installed in parallel with PI ODBC Client 22.214.171.124 so we won't break any of your working configurations.
How do you get the bits? The PI ODBC 2014 Beta installation kit can be found on the Technical Support website. You will also need to download and install the PI SQL Data Access Server (PI SQL DAS) beta. The PI SQL DAS provides the actual SQL processing capability and is often installed on the same Windows machine as the PI ODBC 2014 Driver. Whichever machine runs the PI SQL will also have the PI OLEDB Enterprise Provider which must be installed first.
If you have any questions, comments or problems to report, please contact us at BetaODBC@osisoft.com.