MS Access Based Desktop Solution

Reliable Desktop Data Management

Merlin Workstation is written in Microsoft Access. It can be used as a simple desktop application, or integrated into a MS SQL Server enterprise database.

Merlin Workstation collects instrumentation readings from just about any comma-delimited data source, inserts them into a backend database, checks readings against alarm levels, applies scale factors, then displays instrument status in a project tree. Colored icons make alarms and warnings easily visible to keep users aware of critical developments.

Flexible data collection, combined with powerful graphing to automatically generate plots for Internet display, delivers a comprehensive solution for managing and sharing resource information from an unlimited number of data acquisition systems.

  • Flexible data collection from dataloggers or spreadsheets 

  • Inventories all measurements and sensors

  • Unique drill-down into details for each measurement

  • Creates backup copies of raw data

  • Applies QA/QC filters automatically or manually

  • Applies scale factors over specific date ranges

  • Alarms any data stream with minimum and maximum thresholds

  • Creates and exports jpg graphics and ‘csv’ files

  • Synchronizes multiple databases over the Internet

  • Logs all transactions

Rapid Event Detection for Distributed Monitoring Systems

Designed for Speed and Efficiency

Merlin Enterprise (ME) starts with the same capabilities as Merlin Workstation, but adds multi-threaded, parallel web services to facilitate fast and efficient processing of field data into a SQL Server database,while ensuring data redundancy and integrity. This proprietary approach anticipates the definitions that must be used by any database to group, sort and ultimately analyze the data. Application of this important principle in Merlin makes data collection, presentation and transfer to enterprise databases virtually automatic.

The data types ME can import include almost any comma-delimited file with column headers, data from OPC servers and public data scraped from databases such as Caifornia Department of Water Resources CDEC database.  Reports are automatically generated based on the type of data collected by monitoring stations, so no programming of any sort is required to enjoy rich graphical displays of your data.

 

Add Projects, Stations and Sensors

Add additional monitoring sites with any combination of sensors in minutes. Once the monitoring equipment is installed, the data flows into Merlin Enterprise and the new elements are added to the existing database automatically. A user only needs to define the engineering units (if different from defaults) and add custom names if desired. Data will flow seamlessly from the controller to the database and display. This streamlined approach is based on a rock-solid and rigorous data management solution that is infinitely scalable.

125 Hangar Way, 
Suite 290 
Watsonville, CA. 95076
phone: 831-687-0186

    fax: 866-335-2084
info@eyasco.com

© 2020 Eyasco, Inc. 125 Hangar Way, Suite 290 Watsonville, CA 95076  831-687-0186