OSIsoft PI System JDBC Connection

With the OSIsoft PI System JDBC Connection shared resource, you can create a connection between the plug-in and the PI Data Archive server. This shared resource is used for the JDBC Query activity.

General

In the General panel of OSIsoft PI System JDBC Connection Editor, you can specify the package that stores the OSIsoft PI System JDBC Connection shared resource, and the name and description of the shared resource.

The following table lists the fields in the General panel:
Field Module Property? Description
Package No The name of the package where the new shared resource is added.
Name No The name to be displayed as the label for the shared resource in the process.
Description No A short description of the shared resource.

Configuration

In the Configuration panel of OSIsoft PI System JDBC Connection Editor, you can specify information of the PI JDBC server that the plug-in connects to.

The following table lists the fields in the Configuration panel:
Field Module Property? Description
Host Yes The server selected for connection.
Server Yes The IP address or name of the machine where the PI Data Archive server is installed.
User Name Yes The user name used to log on to the PI Data Archive server.

If the host machine belongs to a certain domain, you can enter Domain/User Name in this field.

Password Yes The password required for connection.
Test Connection No When you finish the configuration, click this button to test whether the parameters are set correctly.