Home : Products : Hach WIMS : Interfaces : Hach WIMS Platform SCADA & Lab Data Interfaces
Q12932 - INFO: Hach WIMS Platform SCADA & Lab Data Interfaces

Interfaces

Interfaces allows any WIMS Platform solution to automatically import data from external data sources such as SCADA, Historians, LIMS, or Lab EDDs.  Interfaces run in the background as Windows services on a scheduled basis (once every x minutes, every hour, or once/day), connect to the source data, summarize/clean the data, and writes the data to the WIMS Platform database. 

Each interface can be configured to support:

 

Download WIMS_Interface_prerequisites.msi to install the prerequisites for the interface.  This is only required if you are installing on a PC with no WIMS Component already installed.  

See Lab Automation in WIMS for information on interfacing to Lab Instruments.

Download SqlConsole for testing queries.  

Download Office2016.dll for WIMS Client new menu system.  Put in WIMS Client folder.

 

Do I need a Direct or Indirect interface to my SCADA or LIMS system?

Direct: When the network environment that WIMS/Rio will reside can be directly connected to the SCADA/LIMS system data source.

Indirect: When the network environment that WIMS/Rio will reside in is not directly connected; for example:

• Physically disconnected networks
• Blocked by firewall policies
• Blocked by Network permissions
• Separate domains
Note: All Indirect Interfaces will also work in a direct connection environment.

 

SCADA/HISTORIAN INTERFACES
Connect to the SCADA/Historian data, summarize (i.e. calculate the average, min, max, total, first, last, etc...) the requested tags and store the summaries in the WIMS/Rio database. SCADA Interfaces include:
Vendor Name Vendor Product Interface Type Also known As and other information Updated On Hach Docs Version Release Notes Download Link
Dorsett Controls SCADA Dorsett Controls Direct Imports data from Dorsett Controls SCADA 4/6/2022 (Help.CHM) 8.0.0 (Q14709) Q14704.zip
Emerson Ovation Indirect Ovation Process Historian 12/1/2015 (PDF Manual) (Intro: Q12992) (Config: Q12992) 1.0.7 (Q13001) (wims_12992.msi)
EDS EDS SCADA Direct 2/2/2024 (Help.chm) 8.0.2 (Q14754) (Q14743.zip)
  Ovation SCADA Direct Ovation Historian 8/8/2023 (Help.chm) (Intro: Q13663) (Config: Q13663) 8.0.0 (Q13667)

Q13663.zip

(wims_13663.msi)

Fischer & Porter ALG Direct Imports from text data files 11/9/2015 (PDF Manual) (Intro: Q12080) (Config: Q12080) 1.0.9 (Q12088) (wims_Q12080.msi)
FlexSystems FlexOps Direct FlexSystems Data Collection Solutions (http://www.flexops.net) 11/9/2015 (PDF Manual) (Intro: Q12527) (Config: Q12527) 1.0.8 (Q12531) (wims_Q12527.msi)
GE Cimplicity SQL Indirect Proficy HMI/SCADA Cimplicity 5/10/2024 (Help.CHM) (Intro: Q12495) (Config: Q12495) 8.0.1 (Q12506)

Q12495.zip

(wims_12495.msi)

  Proficy FIX or iFIX HMI Direct Intellution FIX, iFIX, FIX32, Advanced Historian, Classic Historian (h04, h08, and h24 files) http://www.ge-ip.com/products/3311 06/8/2022 (Help.CHM) (Intro: Q12109) (Config: Q12109) 8.0.0 (Q12136)

Q12109.zip
Instructions

    Indirect Intellution FIX, iFIX, FIX32, Advanced Historian, Classic Historian (h04, h08, and h24 files) http://www.ge-ip.com/products/3311 10/25/2023 (Help.CHM) (Intro: Q12499) (Config: Q12499) 8.0.0 (Q12515)

Q12499.zip

(wims_12499.msi)

  Proficy Historian Direct iHistorian, Intellution Historian (https://www.ge.com/digital/applications/proficy-historian) 5/20/2024 (Help.CHM) (Intro: Q11924) (Config: Q11924) 8.0.5 (Q12064)

Q11924.zip
Instructions

    Indirect iHistorian 12/14/2022 (Help.CHM) (Intro: Q12447) (Config: Q12447) 8.0.0 (Q12460)

(Q12447.zip)

(wims_12447.msi)

Generic Generic Direct Plantscape Vista, Plantscape SCADA, CitectSCADA, Ignition, and others using Narrow Format OLEDB Source 2/22/2024 (Help.CHM) (Intro: Q12160) (Config: Q12160) 8.0.4 (Q12200)

Q12160.zip
Instructions

Generic Generic Direct Custom Narrow Format OLEDB Source 12/01/2021 (Help.CHM) 8.0.0 (Q14609)

Q14606.zip

Ignition Direct Ignition Narrow Format OLEDB Source 11/14/2024 (Help.CHM) 8.0.4 (Q14635) Q14632.zip
    Direct Reads Comma Separated Value (text) files in either narrow or wide SCADA format 5/1/2024 (Help.CHM) (Intro: Q12933) (Config: Q12933) 8.0.4 (Q12936)

Q12933.zip
Instructions

    Direct Imports SCADA data from wide formated OLEDB database tables 8/2/2024 (Help.CHM) (Intro: Q13207) (Config: Q13207) 8.0.3 (Q13212)

Q13207.zip(wims_13207.msi)

    Direct SCADA CSV Interface 5/2/2022 (Help.CHM) (Intro: Q14107) (Config: Q14107) 8.0.3 (Q14114)

Q14107.zip
Instructions

Hach SC100/1000 Indirect Hach ProcessLink OPC DA Server 12/3/2015 (PDF Manual) (Intro: Q12374) (Config: Q12374) 1.1.0 (Q12474) (wims_12374.msi)
Hach Claros IM Direct

Hach Claros Instrument Management (MSM)

For use with older versions of WIMS (Prior to 8.1.8)

Licensing Issues

5/9/2023

Help.CHM
Introduction Source Config
Variable Config

8.0.4 Release Notes Q14522.zip
Instructions
AQI/Hach Claros IM Direct Hach Claros Instrument Management (MSM) After Collect 3/11/2024

Help.CHM
Introduction Source Config
Variable Config

8.0.6 Release Notes Q14725.zip
Instructions
  SC1000 Indirect Hach SC1000 via Modbus TCP 12/3/2015 (PDF Manual) (Intro: Q12677) (Config: Q12677) 1.0.8 (Q12769) (wims_12677.msi)
  Watereye Direct http://www.watereye.com 12/3/2015 (PDF Manual) (Intro: Q12075) (Config: Q12075) 1.1.0 (Q12093) (wims_12075.msi)
Honeywell PlantScape Indirect PlantScape Vista, PlantScape SCADA 12/4/2015 (PDF Manual) (Intro: Q12973) (Config: Q12973) 1.0.8 (Q12979) (wims_12973.msi)
Iconics TrendWorx Logger Direct TrendWorx32, TrendWorx HMI (http://www.iconics.com/) 12/2/2022 (Help.CHM) (Intro: Q12580) (Config: Q12580) 8.0.0 (Q12594)

Q12580.zip

(wims_12580.msi)

    Indirect TrendWorx32, TrendWorx HMI (http://www.iconics.com/) 12/1/2022 (Help.CHM) (Intro: Q12708) (Config: Q12708) 8.0.0 (Q12963)

(Q12708.zip)

(wims_12708.msi)

Direct Iconics Hyper HistorianTM 5/9/2024

Help.CHM
Introduction Source Config
Variable Config

8.0.1 Release Notes

Q14397.zip
Instructions

Invensys Foxboro AIM*Historian Direct Invesys/Foxboro AIM*Historian, AIMStar Historian 10/26/2022 (Help.CHM)
(Intro: Q12408) (Config: Q12408)
8.0.0 (Q12414)

Q12408.zip
Instructions

AVEVA WonderWare Historian Direct Industrial SQL (InSQL), Wonderware Historian, Invensys Historian  4/20/2022 (Help.CHM)
(Intro: Q12180) (Config: Q12180)
8.0.2 (Q12196)

Q12180.zip
Instructions

    Indirect Industrial SQL (InSQL) 5/28/2024 (Help.CHM) (Intro: Q12705) (Config: Q12705) 8.0.0 (Q12778)

Q12705.zip

(wims_12705.msi)

  InTouch HMI Direct Wonderware HistData DDE 12/14/2022 (Help.CHM) (Intro: Q12097) (Config: Q12097) 8.0.0 (Q12124)

Q12097.zip
Instructions

    Indirect Wonderware HistData DDE 12/7/2015 (PDF Manual) (Intro: Q12706) (Config: Q12706) 1.0.9 (Q12800) (wims_12706.msi)
Mettler Toledo OverDrive Direct MT O-Drive (http://us.mt.com/) 12/7/2015 (PDF Manual) (Intro: Q12695) (Config: Q12695) 1.0.7 (Q12713) (wims_12695.msi)
National Instruments Lookout SCADA CSV Direct NI Lookout CSV (http://www.ni.com/) 12/7/2015 (PDF Manual) (Intro: Q12839) (Config: Q12839) 1.0.7 (Q12843) (wims_12839.msi)
OPC-Type OPC DA Indirect Follows standards from - http://www.opcfoundation.org/ 1/19/2022 (Help.chm) (Intro: Q12373) (Config: Q12373) 8.0.0 (Q12432) (Q12373.zip)
  OPC HDA Direct Emerson Delta V, and others - follows standards from - http://www.opcfoundation.org/ 11/23/2021 (Help.CHM) (Intro: Q12260) (Config: Q12260) 8.0.0 (Q12269) Q12260.zip
Instructions
AVEVA/OSISoft PI Historian Direct

https://www.aveva.com/en/products/aveva-pi-system/

Also works for Rockwell FactoryTalk Historian SE

5/9/2024 (Help.CHM) (Intro: Q12233) (Config: Q12233) 8.0.8 (Q12236)

Q12233.zip
Instructions

Raco Catalyst Indirect Raco Dialers http://www.racoman.com/catalyst.html 12/7/2015 (PDF Manual) (Intro: Q12542) (Config: Q12542) 1.1.0 (Q12551) (wims_12542.msi)
Rockwell Automation FactoryTalk View SE Indirect RS View SE 12/13/2021 (Help.CHM) (Intro: Q14246) (Config: Q14246) 8.0.1 (Q14252) (Q14246.zip)
  RsBIZWARE Direct RSBizWare, Factory Talk Historian Classic 12/7/2015 (PDF Manual) (Intro: Q12084) (Config: Q12084) 1.1.1 (Q12098) (wims_12084.msi)
  RSView32 Direct DBase IV file database using wide and narrow file names, data is in wide format 3/20/2024

(Help.CHM)(Intro: Q12107) (Config: Q12107)

8.0.0 (Q12186) Q12107.zip
    Indirect DBase IV file database using wide and narrow file names, data is in wide format 12/7/2015 (PDF Manual) (Intro: Q12535) (Config: Q12535) 1.1.1 (Q12901) (wims_12535.msi)
FactoryTalk Historian SE Direct FactoryTalk Historian SE uses OSI PI from OSISoft.  Use the PI Historian Interface listed above.
Schneider Electric CitectSCADA Reports Indirect Citect SCADA Reports Historian (http://www2.schneider-electric.com/) 12/8/2015 (PDF Manual) (Intro: Q12616) (Config: Q12616) 1.1.1 (Q12627) (wims_12616.msi)
  ClearSCADA Direct Control Microsystems, Clear SCADA 11/30/2021 (Help.chm) (Intro: Q13575) (Config: Q13575) 8.0.0 (Q13579)

Q13575.zip
Instructions

  Telvent SCADA Direct Telvent Canada, http://www.telvent.com/ 6/21/2022

(Help.chm)

(PDF Manual) (Intro: Q12240) (Config: Q12240)

8.0.0 (Q12249)

(Q12240.zip)

(wims_12240.msi)

Trihedral VTS HMI Direct Visual Tag System (http://trihedral.com/) 12/14/2023 (Help.CHM) (Intro: Q12363) (Config: Q12363) 8.0.2 (Q12403)

Q12363.zip
Instructions


LIMS INTERFACES
imports approved results from Laboratory Information Management Systems based on user specified Locations (Sampling Points) and Tests (Analytes).
Vendor Name Vendor Product Interface Type Also known As and other information Updated On Hach Docs Version Release Notes Download Link
Aquatic Informatics Rio Direct Aquatic Rio 10/15/2024 (Help.CHM) 8.1.9 (Q14648) (Q14648.zip)
Rio Sync WIMS Rio Sync 7/24/2024 Intro: Q14763
Config: Q14770
24.2.7 Q14768 Installer
ATL Sample Master® LIMS Direct Accelerated Technology Laboratories Inc. (http://www.atlab.com) 7/12/2023 (Help.CHM)
(Intro: Q12367) (Config: Q12367)
8.0.0 (Q12397) Q12367.zip
Instructions
doForms doForms Web Service Direct doForms Web Service 3/31/2023

(Help.CHM)

(PDF Manual) (Intro: Q14162) (Config: Q14162)

8.0.2 (Q14165)

Q14162.zip
Instructions

Eurofins Scientific Eaton Analytics Direct MWH Labs, Montgomery Watson Labs (http://www.eatonanalytical.com/) 11/4/2015 (PDF Manual) (Intro: Q12263) (Config: Q12263) 1.0.7 (Q12334) (wims_Q12263.msi)
Generic Generic Direct Can be used with any LIMS database that has a Sample and Results table. Tested with: StarLIMS, ATL Samplemaster, ATL Titan, EDORS LIMS,Matrix Gemini LIMS, and Thermo Scientific SampleManager 5/28/2024 (Help.CHM)
(Intro: Q13618) (Config: Q13618)
8.0.2 (Q13622) Q13618.zip
Instructions
    Direct Reads labortory results from Excel (.XLS) files 2/28/2024

(Help.chm)

(PDF Manual) (Intro: Q13940) (Config: Q13940)

8.0.1 (Q13943)

(Q13940.zip)

(wims_Q13940.msi)

    Direct Reads data results from Excel (.XLS/XLSX) files 1/12/2022 (Help.CHM) (Intro: Q14211) (Config: Q14211) 8.0.1 (Q14214) (Q14211.zip)
Hach Claros Collect Direct Imports data results from the Hach Claros Cloud 1/12/2021

Help.CHM
Introduction Source Config
Variable Config

8.0.1 Release Notes Q14412.zip
Instructions
Perkin Elmer Labworks Direct PE Labworks http://www.perkinelmer.com/labworks 12/12/2023 (Help.CHM) (Intro: Q12211) (Config: Q12211) 8.0.2 (Q12211) Q12211.zip
Instructions
Promium Element LIMS Direct Promium LIMS (http://www.promium.com/) 1/8/2024 (Help.chm) (Intro: Q13297) (Config: Q13297) 8.0.0 (Q13301)

Q13297.zip

(wims_13297.msi)

Telecation, OPS System Aspen Direct Aspen Direct 11/6/2015 (PDF Manual) (Intro: Q12310) (Config: Q12310) 1.1.0 (Q12324) (wims_12310.msi)
Tribal Software Tribal LIMS Direct Tribal SQL (http://www.tribalsoftware.com) 12/7/2023 (Help.CHM) (Intro: Q12309) (Config: Q12309) 8.0.2 (Q12347)

Q12309.zip
Instructions

120 Water Audit

120Water Direct 120 Water Audit (http://www.120water.com) 12/01/2021 (Help.CHM) 8.0.0 (Q14581) Q14578.zip
MISCELLANEOUS INTERFACES and TOOLS
Vendor Name Vendor Product Interface Type Also known As and other information Updated On Hach Docs Version Release Notes Download Link
Automation Solutions, Inc. AuditMatic Direct Auditing Data Entry Software 11/6/2015 (PDF Manual) (Intro: Q14051) (Config: Q14051) 1.0.7 (Q14080) (wims_Q14051.msi)
Generic Generic Direct Free LIMS text file import utility 4/30/2024 (Help.CHM) (Intro: Q12351) (Config: Q12351) 8.0.8 (Q12359) Q12351.zip
Instructions
Utility Cloud Utility Cloud Direct https://utilitycloud.us 12/01/2021

Help.CHM
Introduction
Source Config
Variable Config

8.0.0 Q14489 Q14486.zip
Instructions
Hach Dispatcher Miscellaneous Utility to move data XML files 10/24/2012 (Intro: Q12497)   2.0.9 (Q12652) (wims_12497.msi)
    Miscellaneous Interface used for importing data from Dispatcher Cache database table 11/6/2015 (PDF Manual) (Intro: Q13627) (Config: Q13627) 1.1.0 (Q13631) (wims_Q13627.msi)
  Hach WIMS Client Miscellaneous Hybrid interface - WIMS to WIMS 10/23/2024 (Help.CHM) (Intro: Q12669) (Config: Q12669) 8.0.3 (Q12673) Q12669.zip
Instructions
  UDG1000 Miscellaneous Hach UDG1000 11/30/2021 (Help.CHM) (Intro: Q14088) (Config: Q14088) 8.0.0 (Q14130)

(Q14088.zip)

SL1000 PPA Miscellaneous Import data collected on your Hach SL 1000 Portable Parallel Analyzer™ (PPA) 2/15/2022

(Help.CHM)Introduction
Source Config
Variable Config

8.0.2 Q14431 Q14428.zip
Instructions
ESRI Survey 123 Direct Import data collected in ESRI Survey 123 12/02/2021 (Help.CHM) 8.0.0 Q14620

Q14620.zip



© Copyright 2013 - 2018 HACH Company

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 3/11/2010 1:53 PM.
Last Modified on 11/14/2024 11:58 AM.
Last Modified by Scott Dorner.
Article has been viewed 60048 times.
Rated 6 out of 10 based on 56 votes.
Print Article
Email Article