How to create a data configuration in Statistica Enterprise to query from PI Historian ?
 

How to create a data configuration in Statistica Enterprise to query from PI Historian ?

1. Install PI OLEDB Enterprise kit as per instructions detailed in (if not installed already): https://livelibrary.osisoft.com/LiveLibrary/content/en/oledb-ent-v4/GUID-F058B981-E8ED-45FB-BB6E-9BD05FCB8332#addHistory=true&filename=GUID-C556CD45-8A2F-4CC8-9E00-4077F20F5C5D.xml&docid=GUID-F058B981-E8ED-45FB-BB6E-9BD05FCB8332&inner_id=&tid=&query=&scope=&resource=&toc=false&eventType=lcContent.loadDocGUID-F058B981-E8ED-45FB-BB6E-9BD05FCB8332

2. Launch Statistica Enterprise as a user with Database Admin permissions. Right click on Database Connections and choose New Database Connection.


3. Pick PI OLEDB Enterprise Provider. Define PI Server host name and credentials as required. Test connection to ensure connectivity.


4. Name the database connection Define access permissions click on commit on the top left corner to save the changes.
  
5. Right click on folder in Statistica System View and click on New Data Configuration

6. Define PI Query to bring back data from PI Historian as shown below, define access permissions and click on commit on the top left corner of Statistica Enterprise to save the changes.
  
7. Click Explore to bring the data into Statistica.

 

https://livelibrary.osisoft.com/LiveLibrary/content/en/sql-commander-v2/GUID-E2E1FC22-ABBF-4447-9F6D-4945B9C358B7#addHistory=true&filename=GUID-F7B501F6-D2DF-4B44-8046-3E1E44F626AF.xml&docid=GUID-E2E1FC22-ABBF-4447-9F6D-4945B9C358B7&inner_id=&tid=&query=&scope=&resource=&toc=false&eventType=lcContent.loadDocGUID-E2E1FC22-ABBF-4447-9F6D-4945B9C358B7