For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Import Your Data > Import Data from an OSIsoft PI Server
Publication date: 06/21/2023

Import Data from an OSIsoft PI Server

This import functionality is built on the Web API, and requires the PI Web Server to be deployed and running. In addition, the PI Asset Framework must be installed and configured.

PI Server data is typically machine generated and collected at defined intervals. The interval time can be short, leading to large amounts of data. For example, you have a process that is being monitored. Every 15 minutes, data is collected from various sensors and this data is sent to the PI Server. In another application, sensor readings can be collected more frequently, for example, every millisecond. The table below illustrates how this can lead to a large amount of data.

Table 3.6 Example of Collected Data

Number of sensors

10

10

10

Data Collected Every Unit of Time

15

1

1

Units of Time

Minutes

Seconds

Millisecond

Units of Time per Day

96

86,400

86,400,000

Data Points per Day

960

864,000

864,000,000

Data Points per Month

29,200

26,280,000

26,280,000,000

Data Points per Year

350,400

315,360,000

315,360,000,000

The PI Server can import the following types of data:

raw data

plot data

interpolated data

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).