OPS SQL Interfaces

OPS SQL interfaces automatically pull data from SCADA systems, Historians, LIMS, Data Loggers, and instruments allowing you to bring all of your data together simply and accurately. No more entering data in multiple locations, simply import all of your data directly into OPS SQL. Interfaces currently available for OPS SQL® include:

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 OPS database. SCADA Interfaces include:

  • Intellution's The Fix, iFix, and Dynamics classic historian files
  • Intellution's iHistorian, Proficy Historian
  • Wonderware's InTouch®
  • Wonderware's Industrial SQL (InSQL)®
  • Rockwell's RSView32®
  • Rockwell's RSViewSE®
  • Rockwell's RSBizWare Historian®
  • OSIsoft's Pi Historian
  • Foxboro's AIM*Historian
  • GE's Cimplicity
  • Citect SCADAReports
  • Aspen InfoPlus.21®(IP21)
  • Generic CSV files

LIMS INTERFACES connect to the LIMS database, apply data qualifier rules and transfer results into the OPS Database. You specify whether to transfer "Approved" data or transfer the data status (i.e. Approved/Unapproved). The unapproved data is clearly marked in OPS and unapproved data will only show up on internal reports. Using this approach allows operations to see the data but still allows the lab to control the reporting of the data. LIMS Interfaces include:

  • Telecation's Aspen LIMSTM
  • PerkinElmer LABWORKS
  • LabVantage SapphireTM
  • ATL Samplemaster®
  • Tribal© LIMS
  • LabSoft® LIMS
  • Common Lab EDI's for transfer from commercial labs

INSTRUMENT, DATA LOGGER, and WEB INTERFACES automatically gather data from multiple sources, no more double data entry.

  • USGS National Water Information System for the Web (NWISWeb)- River and Lake Elevation and flow
  • RACO Catalyst Data Logger
  • YSI DO Meters (models 5100, 53)
  • Hach OPC DataLogger software (for transfer of Turbidity, temperature data...)
  • Mettler Toledo Scale

  • Custom Interfaces Available - Please call for quote
    		•
    Click below for more information about: