How do I Connect to OSIsoft PI Server?

[#1]

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.

Play Video

Play

Mute

Current Time 0:00

/

Duration 10:03

Loaded: 0.00%

00:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -10:03

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

• en (Main), selected

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

[gail_massari]

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.