This Hach WIMS interface is used to pull summary values from an Emerson Ovation Process Historian and store the values in the Hach WIMS Database.  It was developed using the User Defined Functions (UDF) available in Emerson Ovation Process Historian version 3.3. This interface uses the SyncReadProcessed aggregates against the ProcessedData tables in the Historian. The aggregates provide access to interval style processed data through SQL queries. The interface uses the PointsNameOnly query syntax option as it loops through each variable in Hach WIMS and processes them each individually.

In order for this interface to connect to the Ovation Process Historian, it requires the Ovation Process Historian OLE DB Provider (driver) as shown below, and connectivity (network connection) to the Emerson Ovation Process Historian.  Install the Ovation Process Historian Client Interface which includes the Emerson OLE DB provider (Installed by Emerson integrator).

NOTE: To see if the driver is installed, simply create a file with a .udl extension and double click on it.  The Data Link Properties (shown above) will be displayed.