Introduction to PI OLEDB Enterprise

PI OLEDB Enterprise is an OLE DB data provider you can use to access asset metadata stored in PI Asset Framework (PI AF). PI OLEDB Enterprise supports read-only access to PI AF server data. It exposes only the AF asset namespaces.

PI OLEDB Enterprise also provides read-only access to data from PI Servers, since AF attributes can be configured to reference PI points. PI OLEDB Enterprise exposes this information through a relational view of AF databases, which is accessible through SQL queries.

The PI OLEDB Enterprise data provider meets the OLEDB 2.7 specification. The SQL Engine is embedded and supports SQL (Structured Query Language) compliant with ANSI SQL 92 Entry Level.

Microsoft’s OLE DB specification is a powerful middleware interface that is supported by many commercially available applications, including Microsoft Office and SQL Server. In addition to using these commercial applications for OLEDB, you can also write custom applications that access data through OLEDB.

PI OLEDB Enterprise is part of the AVEVA PI System developer technologies product suite. For more information, see About Developer Technologies