OSI PI Adapter Sample

This topic describes the use of the OSI PI Adapter suite in a sample application to query and update data in a PI server. For more information about this operator, see OSIsoft PI Adapters.

Prerequisites

In order to run correctly, the adapters in this sample require that the OSIsoft PI Asset Framework (AF) Client version 2016 R2 or later, and the OISsoft PI SDK version 2014 R2 or later, be installed on development and deployment machines that are expected to run StreamBase applications that call these adapters. The OSIsoft software can be obtained from OSIsoft.

When you install and configure the OSIsoft software, you establish a set of defaults for server name, user name, and password. Those defaults are used if not explicitly defined in the adapter properties.

Sample Overview

This sample demonstrates the adapters in the OSI PI adapter suite:

  • Snapshot

  • Write

  • Summaries

  • DataPipe

  • AF

This Sample's Files

This sample has the following files:

  • The sample EventFlow application, OsiPiSample.sbapp.

  • This Readme file, in plain text and HTML formats.

Running This Sample in StreamBase Studio

The steps to run this sample in Studio are as follows:

  1. In the Project Explorer view, double-click to open the OsiPiSample.sbapp module in the src/main/eventflow/packagename folder.

    If the module shows red marks in the Project Explorer view, wait a few moments for the project to load its adapter support features. If the red marks do not resolve quickly, select the project's name, right-click, and run MavenUpdate Project.

  2. Make sure each adapter's server tab uses the correct values for your PI and PI AF installations.

  3. Make sure the application is the currently active tab in the EventFlow Editor, then click the Run button. This opens the SB Test/Debug perspective and starts the application. All the adapters are configured to connect to the PI server at startup.

  4. In the Manual Input view, select the SnapshotQuery input stream, and enter a list of tag names to query.

    Click Send Data, and observe that the output stream that received the data is the PISnapshotOutput stream, with one tuple emitted for every tag name requested. Once these tuples are emitted, one more tuple follows with its tagName field set to null, to indicate the end of the list.

  5. In the Manual Input view, select the WriteData input stream, and enter a list of tags to update.

    Click Send Data, and observe that the output stream that received the data is the PIWriteOutput stream. The tuple contains the results of the write operation for every requested tag.

  6. In the Manual Input view, select the SummariesQuery input stream, and enter a list of tag names to query, and some summary types (by setting the summaryTypes field to "minimum, maximum, average", for example).

    Click Send Data, and observe that the output stream that received the data is the SummaryOutput stream, with one tuple emitted for every tag name requested. Once these tuples are emitted, one more tuple follows with its tagName field set to null, to indicate the end of the list.

  7. In the Manual Input view, select the AFCommands input stream and set the command field to QUERY and the queryBase field to a string representing the element to query.

    Click Send Data, and observe that the output stream that received the data is the AFOutput stream, with one tuple emitted for every attribute found under the element. Once these tuples are emitted, one more tuple follows with its tagName field set to null, to indicate the end of the list.

  8. In the Manual Input view, select the Subscribe input stream, and enter a list of tag names to query.

    Click Send Data, and observe that the output stream that received the data is the PIDataPipeOut stream, with one tuple emitted for every tag name requested. Once these tuples are emitted, one more tuple follows with its tagName field set to null, to indicate the end of the list.

  9. When done, press F9 or click the Stop Running Application button.

Importing This Sample into StreamBase Studio

In StreamBase Studio, import this sample with the following steps:

  • From the top menu, select FileLoad StreamBase Sample.

  • Select OSI PI from the StreamBase Messaging Adapters category.

  • Click OK.

StreamBase Studio creates a project for the OSI PI adapter sample in your current Studio workspace.

Sample Location

When you load the sample into StreamBase Studio, Studio copies the sample project's files to your Studio workspace, which is normally part of your home directory, with full access rights.

Important

Load this sample in StreamBase Studio, and thereafter use the Studio workspace copy of the sample to run and test it, even when running from the command prompt.

Using the workspace copy of the sample avoids permission problems. The default workspace location for this sample is:

studio-workspace/sample_osipi

See Default Installation Directories for the location of studio-workspace on your system.

In the default TIBCO StreamBase installation, this sample's files are initially installed in:

streambase-install-dir/sample/osipi

See Default Installation Directories for the default location of studio-workspace on your system.