How to query data from PI historian in TIBCO Statistica ?
Article ID: KB0073914
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.5 and higher |
Description
This article details how PI historian can be queried from TIBCO Statistica or How to resolve "You are licensed for the Statistica PI connector but PI SDK is not installed" ?
Issue/Introduction
How to query data from PI historian in TIBCO Statistica ? or How to resolve "You are licensed for the Statistica PI connector but PI SDK is not installed" ?
Resolution
1. Download and Install PI SDK as detailed in the OSISoft Site ( if it is not already installed ). Specify the default PI server if it is known. https://livelibrary.osisoft.com/LiveLibrary/content/en/server-v8/GUID-57119CA6-0E22-4059-ABEA-18F65C6184A8#addHistory=true&filename=GUID-7A29997E-33AB-4BA0-B21C-0789CAEB7B18.xml&docid=GUID-57119CA6-0E22-4059-ABEA-18F65C6184A8&inner_id=&tid=&query=&scope=&resource=&toc=false&eventType=lcContent.loadDocGUID-57119CA6-0E22-4059-ABEA-18F65C6184A8
2. Launch Statistica and open a new workspace by clicking on Home>>New>>Workspace . You may select a blank template with no data sources.
3. Select the PI tab and pick to use the Batch database nodes to query PI historian as required . In other words select one of -Compressed, Interpolated, Summary or Timed nodes depending on the kind of data intended to be queried.
4. Click on the gear icon to open the parameters of the node and select Edit parameters.Click on PI Logon and connect to the PI Server. If default PI server was not specified during step 1 of PI SDK installation . This can be done by clicking on Server >> Add Server
5. Click on Tag search>>Search and enter search criteria and select the tags and select OK. Optionally enter more filtering criteria and select OK. Run the node by clicking on the green triangle to bring data from PI historian into TIBCO Statistica workspace.
Add other analytic nodes as required to process and analyze data from OSISoft PI Historian.
2. Launch Statistica and open a new workspace by clicking on Home>>New>>Workspace . You may select a blank template with no data sources.
3. Select the PI tab and pick to use the Batch database nodes to query PI historian as required . In other words select one of -Compressed, Interpolated, Summary or Timed nodes depending on the kind of data intended to be queried.
4. Click on the gear icon to open the parameters of the node and select Edit parameters.Click on PI Logon and connect to the PI Server. If default PI server was not specified during step 1 of PI SDK installation . This can be done by clicking on Server >> Add Server
5. Click on Tag search>>Search and enter search criteria and select the tags and select OK. Optionally enter more filtering criteria and select OK. Run the node by clicking on the green triangle to bring data from PI historian into TIBCO Statistica workspace.
Add other analytic nodes as required to process and analyze data from OSISoft PI Historian.
Feedback
Yes
No
Powered by
