Description
PI OLEDB Enterprise, PI ODBC and PI JDBC are products using the PI OLEDB Enterprise query engine. PI SQL Client has been introduced to improve performance and scalability of PI SQL products. It also uses a new query engine named RTQP Engine (Real-Time Query Processing Engine) that implements a very similar data model compared to PI OLEDB Enterprise and can be seen as its successor.
PI SQL Client currently includes OLE DB, ODBC and JDBC drivers so that also PI ODBC and PI JDBC applications can be migrated.
In this lab you will learn how to transform PI OLEDB Enterprise queries into PI SQL Client queries and compare performance and features using a sample database.
Additionally, you will learn how to address typical integration issues, for example working with parameters, conflicting datatypes or addressing limited querying capabilities of a 3rd party application.

Target Audience: PI Developers