Home : Hach WIMS SCADA & LIMS Interfaces
Q12932 - INFO: Hach WIMS SCADA & LIMS Interfaces

Interfaces

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.  

Download SqlConsole for testing queries.  

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

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

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

Direct: When the network environment that Hach WIMS will reside in is directly connected to the SCADA/LIMS system data source.

Indirect: When the network environment that Hach WIMS 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 Hach WIMS 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)
  Ovation SCADA Direct Ovation Historian 6/1/2016 (PDF Manual) (Intro: Q13663) (Config: Q13663) 1.0.3 (Q13667) (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 11/23/2021 (Help.CHM) (Intro: Q12495) (Config: Q12495) 8.0.0 (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 05/22/2018 (Help.CHM) (Intro: Q12109) (Config: Q12109) 1.2.2 (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 12/2/2015 (PDF Manual) (Intro: Q12499) (Config: Q12499) 1.1.1 (Q12515) (wims_12499.msi)
  Proficy Historian Direct iHistorian (https://www.ge.com/digital/products/historian) 4/19/2022 (Help.CHM) (Intro: Q11924) (Config: Q11924) 8.0.3 (Q12064)

Q11924.zip
Instructions

    Indirect iHistorian (http://www.ge-ip.com/products/2420) 12/2/2015 (PDF Manual) (Intro: Q12447) (Config: Q12447) 1.1.0 (Q12460) (wims_12447.msi)
Generic Generic Direct Plantscape Vista, Plantscape SCADA, CitectSCADA, Ignition, and others using Narrow Format OLEDB Source 5/19/2022 (Help.CHM) (Intro: Q12160) (Config: Q12160) 8.0.2 (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 12/28/2021 (Help.CHM) 8.0.2 (Q14635) Q14632.zip
    Direct Reads Comma Separated Value (text) files in either narrow or wide SCADA format 4/22/2022 (Help.CHM) (Intro: Q12933) (Config: Q12933) 8.0.2 (Q12936)

Q12933.zip
Instructions

    Direct Imports SCADA data from wide formated OLEDB database tables 12/14/2021 (Help.CHM) (Intro: Q13207) (Config: Q13207) 8.0.0 (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) 4/22/2022

Help.CHM
Introduction Source Config
Variable Config

8.0.2 Release Notes Q14522.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/4/2015 (PDF Manual) (Intro: Q12580) (Config: Q12580) 1.0.8 (Q12594) (wims_12580.msi)
    Indirect TrendWorx32, TrendWorx HMI (http://www.iconics.com/) 12/4/2015 (PDF Manual) (Intro: Q12708) (Config: Q12708) 1.0.9 (Q12963) (wims_12708.msi)
Direct Iconics Hyper HistorianTM 11/30/2021

Help.CHM
Introduction Source Config
Variable Config

8.0.0 Release Notes

Q14397.zip
Instructions

Invensys Foxboro AIM*Historian Direct Invesys/Foxboro AIM*Historian, AIMStar Historian 12/4/2015 (Help.CHM)
(Intro: Q12408) (Config: Q12408)
1.0.8 (Q12414)

Q12408.zip
Instructions

Invensys WonderWare Historian Direct Industrial SQL (InSQL) http://global.wonderware.com/EN/Pages/WonderwareHistorian.aspx 4/20/2022 (Help.CHM)
(Intro: Q12180) (Config: Q12180)
8.0.2 (Q12196)

Q12180.zip
Instructions

    Indirect Industrial SQL (InSQL) http://global.wonderware.com/EN/Pages/WonderwareHistorian.aspx 12/4/2015 (PDF Manual) (Intro: Q12705) (Config: Q12705) 1.1.0 (Q12778) (wims_12705.msi)
  InTouch HMI Direct Wonderware HistData DDE 02/21/2018 (PDF Manual) (Intro: Q12097) (Config: Q12097) 1.2.1 (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
OSISoft PI Historian Direct

http://www.osisoft.com/

Also works for Rockwell FactoryTalk Historian SE

4/20/2022 (Help.CHM) (Intro: Q12233) (Config: Q12233) 8.0.2 (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/11/2020

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

1.1.6 (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/ 12/8/2015 (PDF Manual) (Intro: Q12240) (Config: Q12240) 1.0.9 (Q12249) (wims_12240.msi)
Trihedral VTS HMI Direct Visual Tag System (http://trihedral.com/) 1/10/2022 (Help.CHM) (Intro: Q12363) (Config: Q12363) 8.0.1 (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 (AKA ACO Compliance & Operations) 4/26/2022 (Help.CHM) 8.0.5 (Q14648) (Q14648.zip)
ATL Sample Master® LIMS Direct Accelerated Technology Laboratories Inc. (http://www.atlab.com) 11/3/2015 (Help.CHM)
(Intro: Q12367) (Config: Q12367)
1.1.7 (Q12397) Q12367.zip
Instructions
doForms doForms Web Service Direct doForms Web Service 11/30/2021

(Help.CHM)

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

8.0.0 (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 4/22/2022 (Help.CHM)
(Intro: Q13618) (Config: Q13618)
8.0.1 (Q13622) Q13618.zip
Instructions
    Direct Reads labortory results from Excel (.XLS) files 11/4/2015 (PDF Manual) (Intro: Q13940) (Config: Q13940) 1.0.3 (Q13943) (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/13/2021 (Help.CHM) (Intro: Q12211) (Config: Q12211) 8.0.1 (Q12211) Q12211.zip
Instructions
Promium Element LIMS Direct Promium LIMS (http://www.promium.com/) 5/31/2016 (PDF Manual) (Intro: Q13297) (Config: Q13297) 1.0.4 (Q13301) (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) 11/6/2015 (Help.CHM) (Intro: Q12309) (Config: Q12309) 1.1.4 (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/20/2022 (Help.CHM) (Intro: Q12351) (Config: Q12351) 8.0.3 (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 11/23/2021 (Help.CHM) (Intro: Q12669) (Config: Q12669) 8.0.0 (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 5/19/2022 10:20 AM.
Last Modified by Steve Fifer.
Article has been viewed 47015 times.
Rated 6 out of 10 based on 56 votes.
Print Article
Email Article