Configuring the PI System OLEDB Provider Connection

The PI System OLEDB Provider connection provides the functionality to retrieve the tag names, tag definitions, and tag data from the PI System Server data source. This connection also retrieves tag data by applying aggregates and grouping on the fields of a tag from the PI System Server data source for a specified duration. The supported aggregates are: Average (Time Weighted), Count, Minimum, Maximum, and Sum.

Ensure that the required version of the PI System OLEDB Provider is installed on the computer where the Intelligence Data Adapter Service is configured. For information on the required versions, see the Global Customer Support web site.

For more information about PI System OLEDB Provider, refer to the OSIsoft Documentation.

To configure the PI System OLEDB Provider connection

1. In the Data Adapter Type box, select PI System OLEDB Provider.

2. In the Data Source Configuration section, do the following:

   

   1. In the Data Source time zone list, click the time zone of the database that the external data source system is referencing.

      The default time zone is the time zone of your computer. You can select the (UTC) Coordinated Universal Time option if the external data source system being referenced uses UTC for its time fields.

      You can click the Automatically adjust time for Daylight Savings check box if the time zone that you select is affected by daylight saving time (DST). For more information, see Time Zone for a Data Source.

   2. In the Server Name box, type the name of the PI System Server.

   3. In the Authentication box, do one of the following:

      • Click the default Windows Authentication mode if you want to authenticate using the Windows account credentials of the currently logged on user.

      • Click the PI Server Authentication mode if you want to authenticate using the specified PI System Server account credentials for authentication.

   4. In the Tag Name Filter box, type the filter criteria to retrieve tags for a specific PI System Server data source. You need to type the filter similar to an SQL "LIKE" clause. For example, to retrieve tags that contain "ABC" in their names, you need to type "'%ABC%".

   5. Under Advanced (Optional) Properties, do the following:

      • In the PI Properties box, type the PI additional connection string properties. The format for PI properties is Keyword1 = Value1; Keyword2 = Value2.

      • In the Extended Properties box, type the PI connection string extended properties. The format for Extended properties is Keyword1 = Value1; Keyword2 = Value2.

      For more information about properties, refer to the OSIsoft Documentation.

3. Click Connect. If the connection succeeds, the Getting schema notification message appears. It can take few minutes to retrieve the schema from the data source.

4. Click Done and then click Save.