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. Only the AF asset namespaces are exposed.

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 a member of the OSIsoft Developer Technologies product suite. For more information, see About Developer Technologies