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 activities namely, JDBC Query and JDBC TagDefinition 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. |