PI Connector

The PI Connector for Statistica provides the capability to retrieve data from a PI database into a spreadsheet.

PI is a data-historian-software system from OSI Software (www.osisoft.com). PI collects data from multiple instruments and machines to store the data for review, trending, and analysis. The PI repository is non-relational, a proprietary format that is optimized for the storage and retrieval of huge amounts of historical data.

The Statistica PI Connector utilizes the PI SDK to create a native querying tool. With this connector, you can query your data for both offline and online analyses.

The Pi class is useful for gathering information about the installed PI SDK and the server. For querying data from a PI database, the Application's various PI* properties and functions should be used.

Note about PI3 servers

PI3 servers impose a limit on the maximum number of events that can be returned with a single call. By default, this is set at 150,000. This behavior can be changed on the server by editing the server's PITimeout table and adding or editing the value associated with the parameter ArcMaxCollect.