Using the Hach WIMS WonderWare Historian (InSQL) Collector to convert Historical data into OPSDATAXML files.

The Hach WIMS Indirect Server-Side Interface to WonderWare Historian (InSQL) does not communicate directly with the WonderWare Historian. Instead, a collector will connect to the database and convert the SCADA source data into OPSDATAXML files. The Hach WIMS Indirect Server-Side Interface to WonderWare Historian (InSQL) will then import data in these files into the Hach WIMS Client.

In the default installation, the Interface, Collector and WonderWare Historian (InSQL) reside on the same machine. You may also configure the Collector and WonderWare Historian (InSQL) to be on the same machine but have the Interface on another machine. In the indirect configuration, make sure that the Collector's OPSDATAXML files are in a location that the Interface can access (i.e. a shared network drive).

To start the Collector from the Interface click on Configuration/Collector Configuration.

From here you can either configure the Collector or start it. Click on Collector Configuration Settings to configure the collector.

If you choose to start the Collector before it has been configured, you will be presented with a warning message indicating that it has not been configured yet. You can dismiss the message and proceed to configure the Collector.

The Collector will not start collecting data until it has been configured. In the configuration screen you have two tabs of configuration settings. The "General Settings" tab contains information on how you want the Collector to run.

The "Source Connection" tab allows you to configure the connection to your WonderWare Historian (InSQL). Enter the database owner or schema for the WonderWare Historian instance and choose a table to gather data from the historian. Click Test Connection to ensure a good connection. When there is a good connection, click on Refresh Settings and Tags button to load values for the Tag Picker tab.

The "Tag Picker" tab allows you select the tags you want to import into Hach WIMS.

To select tags from another table FIRST press Apply Settings. Go back to "Source Connection" tab and select another table as shown below.

Click the Refresh Settings & Tags button. Now return to the Tag Picker tab and select more tags.

Notice we are collecting EFF_FLOW from v_AnalogHistory table and ONOFF digital data from v_DiscreteHistory table.

When you launch the Collector it will either start as a Windows Tray Application (default) or in NT Service View and Control mode. The standard screen is below.

If the status bar shows "RUNNING" then the Collector is scheduled to run and collect data from the WonderWare Historian (InSQL) . If the status is "PAUSED" you need to configure the connection to WonderWare Historian (InSQL) and click the Start button. If no Tags have been defined yet, then the Collector will not run. If you start the Collector and it does not appear on the screen then you can find it in the Windows System Tray (by default the Collector is hidden when it is started unless errors occur during startup). You can double click on it's icon in the System Tray to make it visible.

If you click on the Configure button when the Collector is running as a Windows Tray Application you are presented with a Proxy Setting screen before being able to configure the Collector's settings.

The proxy screen contains needed information on how you plan to run the Collector. For a standard installation just leave the settings the way that they are

When the Collector is installed to run as a service you are presented with the following screen when starting the application.

From here you can see if the Service is running, configure it, stop it, start it, and view the activity log files.