Skip to main content

Prerequisites

Verify Driver

To verify the OLE DB Provider exists on the machine,

  1. On the Windows desktop, create a new text document.

  2. Rename the text document to Test.udl.

  3. Double click the file to open.

    image20.png

  4. On the Provider tab, verify that the iHistorian OLE DB Provider is listed.

Verify Data Storage

From the Proficy Historian program group, select Historian Administrator.

  1. At the top click the Tags link.

  2. Click Search Historian Tag Database.

  3. Leave the Search window blank and click OK. All the available tags are now listed.

    image21.png

  4. Right click a tag in the list and choose Last 10 Values.

This displays the last 10 values logged to the historian for the selected tag.

Verify Data Retrieval

The Historian Interactive SQL application can be used to verify data retrieval. To open, from the Proficy Historian program group, select Historian Interactive SQL.

  1. Connect to the historian.

    image22.png

  2. Queries can be entered at the top of the window. Enter the following query:

    SELECT *FROM ihTags

  3. Click the image23.png button to execute the query

This should list all tags configured in the historian.

In this section: