Creating an OSIsoft PI System Connection

After creating a project, add an OSIsoft PI System Connection shared resource to create a connection between the plug-in and the PI Data Archive server or PI AF server or both.

According to the type of the activity, create one of the following connections:
  • For the JDBC Query activity and JDBC Tag Definition activity create an OSIsoft PI System JDBC connection.
  • For the AF type activities, such as the AF TagDefinition, AF TagEventListener, AF TagValues, AF AssetsHierarchy, and AF AttributeEventListener activities; create an OSIsoft PI System AF connection.
    Note: The OSIsoft PI System AF Connection shared resource is available only in the Windows operating system.
In this tutorial, the JDBC Query activity is used as the example, therefore, an OSIsoft PI System JDBC connection must be created. The OSIsoft PI System AF connection can be created in the same way.

Prerequisites

Ensure that you have created a project. For more information, see Creating a Project.

Procedure

  1. Expand the project in the Project Explorer view.
  2. Right-click the Resources folder and click New > OSIsoft PI System JDBC Connection to open the OSIsoft PI System JDBC Connection Resource dialog box.
  3. Specify the resource folder, package name, and resource name of the connection if you do not want to use the default configurations. Click Finish to open OSIsoft PI System JDBC Connection Editor.



  4. In the Configuration panel, configure the shared resource.

    For detailed information about the configuration parameters, see OSIsoft PI System JDBC Connection.

  5. Click Test Connection to validate the connection.