The Hach WIMS Indirect Server-Side Interface to Iconics TrendWorx Logger imports data from the Iconics TrendWorx Logger database into Hach WIMS Client.

The interface connects to the Logger database using a standard OLE DB driver to MS SQL or Oracle database. The interface does not have to connect to both the Logger database and the Hach WIMS Client. Since this is an indirect interface, the Collector will create XML files, which are then transported from the TrendWorx Logger computer to the Hach WIMS computer.

The Collector looks up Group names from the TWX_MASTER_GROUPS table and the associated SCADA Tag. It writes every data point from the TrendWorx Logger database into XML files. The Interface matches the Group and Tag names in the XML files, with what is in the Hach WIMS client variable description on the interface tab. The Group and Tag names are seperated by two ampersands - "@@".

NOTE: The Iconics TrendWorx Logger is an add-on and not the Iconics Historian. To connect to Iconics Historian, use Hach WIMS Direct Server-Side Interface to OPC HDA (Q12260). Only use this interface if you must pull data from the Iconics TrendWorx Logger add-on. The Iconics Logger is just a snapshot of data, not all data is available. After reviewing an example of live data from a customer, we found that there were data holes that cannot be filled in by the interface. The date range of the Iconics Logger changes, and can be anything from a couple days to a few months, from what we have seen. The data availability depends on how often the live data is transferred to the Iconics Logger database. More information about TrendWorx Historian and Logger can be found at their website: http://www.iconics.com/.