cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

How do I Connect to OSIsoft PI Server?

To import from the OSIsoft Pi Server, you must have the PI Web Server deployed and running and the PI Asset Framework installed and configured.

 

See how to open the JMP OSIsoft PI interface introduced in JMP 17, connect to the server by identifying the server url, authenticate if necessary, set the server name and database to which you want to connect, and then identify the Attributes (tags) you want to import. First, see how to access one Attribute and then how to access multiple Attributes. This example imports the Attribute data and the Timestamps for the time period you specify.

 

For multiple Attributes, you can identify Sync Time to ensure the Attributes are pulled for the same times into different tables. See how to edit the column names to streamline joining the tables using JMP Query Builder.

 

OSIsoft PI Server.mp4
Video Player is loading.
Current Time 0:00
Duration 10:03
Loaded: 0.00%
Stream Type LIVE
Remaining Time 10:03
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected
    • en (Main), selected
    (view in My Videos)

     

     

     

    Comments

    PI Server data is typically machine generated and collected at defined intervals that are often short, leading to large amounts of data that might be collectted as frequently as every millisecond. Learn more about OSIsoft PI Import. and how to use Max. Count,  Boundary Type, Filter,  Retrieve Attributes, and Timeout fields in JMP during import.