PI OLEDB Provider Overview
The PI System itself is not a relational database, but it is possible to expose PI System data in a relational way. The classic PI OLEDB Provider implements SQL to allow relational queries to be run against the PI Data Archive, the PI Point Database and other configuration data. This product is mostly used in the context of other OLE DB-compliant products such as reporting, analytics, Business Intelligence (BI) and similar tools, or for the development of custom applications.
OSIsoft will continue to maintain PI OLEDB Provider but does not plan any major enhancements. For new projects, we recommended using PI OLEDB Enterprise, which provides access to PI System data through the PI Asset Framework (PI AF).