Supported scenarios

While PI OLEDB Enterprise can be used programmatically, such as through the use of Microsoft's ADO.NET components, its main use consists of integrating with products already known as OLE DB consumers.

Applications that PI OLEDB Enterprise is known to integrate well with include:

• Microsoft SQL Server (as a Linked Server, including Integration Services, Analysis Services and Reporting Services capabilities). See Recommended configuration for Linked Server in Microsoft SQL Server.

• Microsoft SharePoint (including Excel Services)

• Microsoft Excel (including PowerPivot)

• PI WebParts

PI OLEDB Enterprise includes PI SQL Commander Lite, a tool that helps you learn the product, develop queries, and test functionality. PI SQL Commander Lite offers two kinds of sample queries:

• One sample SQL query for each table in the PI AF server catalog. For details, see Run sample SQL queries.

  Note: The amount of data queried is typically small enough to avoid timeouts but the predefined queries can also be customized to adapt to customer-specific database needs.

• A compendium of SQL queries that can be opened as a solution in PI SQL Commander Lite. See More queries - PI SQL query compendium solution for details.

Webinars, tutorials, and programming examples are also available in PI Square, the OSIsoft community.