This course shows how to create optimized PI SQL Client queries as well as how to transform existing PI OLEDB Enterprise queries into PI SQL Client queries. You will compare performance and features of the aforementioned data providers on two sample AF databases, NuGreen and WindFarm.
The course consists of the following parts:
- Get Familiar with PI SQL Client – in this part, you will configure drivers included in the PI SQL Client bundle and will establish a connection to RTQP Engine using PI SQL Commander Lite and DBVisualizer.
- Understand the New Data Model – in this part, you will learn the key concepts of the new data model. You will look at the model structure, the objects it contains, and how it differs from the PI OLEDB Enterprise data model.
- Build RTQP Engine Queries – in this part, you will learn principles of how to form queries against the new data model.
- Migrate Custom Application – in this part, you will migrate a C# console application from PI OLEDB Enterprise to PI SQL Client.
- Integrate PI SQL Client with Microsoft SQL Server Reporting Services – in this part, you will use PI SQL Client as a data source for a simple Reporting Services report.
By the end of the course, you will be able to...
- Explain how the PI SQL products evolved in time.
- Compare architecture of older PI SQL products with PI SQL Client.
- Configure drivers included in the PI SQL Client bundle.
- Clarify how the RTQP Engine data model differs from the PI OLEDB Enterprise model and why the changes have been made.
- Use PI SQL Commander Lite to browse the metadata and form SQL queries.
- Migrate queries from PI OLEDB Enterprise data model into RTQP Engine data model.
- Create a SQL Server Reporting Services report based on PI SQL Client queries.
This course is designed for users familiar with SQL language who want to learn more about the new generation of PI SQL products – PI SQL Client and
Real-Time Query Processing Engine (RTQP Engine).
Course Access: Unlimited access. The only exception is the Training Cloud Environment for which you have 30 day access. After those 30 days you can purchase additional access with one of the two options below: