Configuring the PI Historian Source block

Requirements

OSISoft PI OLE DB Provider.

In order to connect to a PI Historian using the PI Historian Source, please ensure that you have installed the PI Historian OLE DB Provider, provided with your PI Historian, on your client machine.

Properties

Data Source

The data source provider for this PI Historian. The data source provider is configured using the standard Microsoft Data Link Wizard.

NOTE: When configuring the data link wizard, be sure to select the PI OLE DB Provider as the data provider when presented with the list of available data providers.
Import data:
- Use raw values: Import all data contained in the historian for time window specified.
- Use interpolated values: Resample and interpolate between samples for data contained in the historian for the time window specified.
Sampling period:

Select the sampling period for the interpolated data. Sampling periods are specified in seconds.

NOTE: The Imported data option must be set to Use Interpolated values for this option to be available.

Import Options:

The following two options are available for this setting:
- Use only data in this time window: Allows users to specify a window start and end time for importing data
- Use the latest data available: Allows users to import the most recent data available for the selected tags by specifying a duration
Window Begin Time

Specifies the start of the time window for the selected tags. (See Import Options above).
Window End Time

Specifies the end of the time window for the selected tags (See Import Options above).
Duration:

The duration of the data import window (See Import Options above).

Select TAB

Select the fields you wish to import from the specified data set and set the data types. Five data types are supported:

String (S)
Double (D)
Integer (I)
Timestamp (T)
Quality (Q)

Convert between these data types by selecting the required fields from the list and clicking on the conversion buttons provided. Only valid conversions are supported.

Click Refresh to refresh the field list if property changes have been made.

Preview TAB

Provides a sample preview of the data set as read using the currently specified properties.

Return to top