Telog Instruments

Telogers Enterprise System Applications and Solutions

OverviewWastewater Collection
Water Distribution
Functions/BenefitsTelogers Enterprise SystemCrystal Reports OptionGIS ModuleMapping OptionNOAA ModuleEnterprise to SCADA Interface

Wastewater Collection:

Flow
Level
Surcharge
Tank Level
Rainfall
Water Quality

Water Distribution:

Level
PRV
Pump Runtime
Water Hammer
Water Pressure

Use the instruments you need, and let Enterprise sort it out	Interface directly with all of your remote monitoring assets. Enterprise collects the data and integrates it with the common database.
One software package, one vendor	All data in one common database View data Get reports Analyze information Store information No compatibility issues
You'll always know what's going on	Telog RTUs automatically forward alarms to Enterprise Enterprise alerts you by pager, mobile text or e-mail Acknowledgement processing
More information in real-time with no human intervention	Enterprise configures itself automatically No user involvement Enterprise calls field units for data No more tedious "dialing up" for your technicians
Choose your communication technology for each site	Phone Cellular Radio Satellite Ethernet
Historical Data at your fingertips	No need for a separate historian program. Enterprise makes stored data available smoothly and easily Use import tool in Enterprise to consolidate earlier data from other applications SQL server-based: No limit to data storage
Get data as often as you want, when you want	Weekly Daily Hourly Every minute In response to site condition alarms
See your data instantly on a dedicated web site	No more running to the command center View your information on a password-protected website Use the most common web browsers Take charge of issues faster, with real-time information Control which data are visible by username and password
Because not all data are the same, Enterprise collects a variety of data types	Periodic trend data Statisticlly compressed data Time-stamped event data Transient data Computed data Correct or repair collected data using Enterprise tools Maintain an audit trail of each edit Keep the original in the database
Share data with other systems	Modeling Billing SCADA/HMI GIS Other historians
Quality-test your data automatically	Timely notification of potential field problems Enormous savings in data review time
Schedule maintenance as needed	Monitor site environment conditions Monitor equipment battery status Automatic quality control of measurements Schedule site visits when necessary
Multiple time zones? No problem	Time-stamp data from each site with the correct time for its time zone. Telog RTUs have their internal clocks synchronized with the Enterprise server's clock Time-based accuracy of all Enterprise data

For an overview of the Telog Enterprise System, watch the video below:

To see the Teloger Enterprise System in action click on the demo icon below:

For an overview of the Crystal Reports option watch the video below:

Several Telog customers have requested more advanced report generation for Telogers Enterprise. In response to this request, Enterprise v. 5 includes a runtime copy of Crystal Reports® application software. Telog Enterprise users are able to run Crystal Reports’ .rpt files natively from within the Telog Enterprise Client (TEC), whether the files are created by Telog or by users with their own copy of Crystal Reports®. When users create a new report, they can add it to the new Crystal Reports folder in the TEC. Existing Report Templates. Telogers Enterprise Software version 5.0 adds the Crystal Reports folder to the standard database view. This folder is where you can choose one of our predetermined report templates, such as Site Daily Flow and Group Monthly Summary among others. These options give you the power to literally choose a report template, select the desired site, fill in pertinent information (time span, recording interval, etc.) and refresh the report to view. Creating reports can be just that easy. If you own the full version of Crystal Reports you are able to create custom reports to your specifications and import those reports into Enterprise. Contract Telog to create custom reports to use with your Crystal Reports program. Our experts will work with you to generate custom reports to the exact specifications you need. Custom reports from Telog can also be imported directly into Enterprise. This service will become extremely valuable as customers find the need to provide specialized reports to various stakeholders in a clean and concise format.
	Regardless of whether you are working with predefined templates or using custom reports directly from Telog, you can also establish specific report generation as an Enterprise job. The job feature will allow our software to automatically complete several different types of tasks such as: Uploading reports as site documents in .pdf format Saving a report as a .pdf on a daily/weekly/monthly basis Emailing reports to shareholders Printing reports on a user defined timetable Creating jobs in Enterprise is designed to save you time by eliminating the need to repeat tasks. Implementing Crystal Reports jobs provides the flexibility to produce reports to any specified group of people in a clean format, all done automatically. The power of Telogers Enterprise combined with the functionality of Crystal Reports will translate into saved time, ease of use, and ultimately increased productivity.

For an overview of the GIS module for Telog Enterprise watch the video below:

ESRI’s GIS server is an excellent tool for representing spatial data. Telog’s Enterprise server is an excellent tool for working with temporal data. Telog’s GIS module combines the power of both these tools in one location. The GIS Module is a key element of Telog’s new EIMS (Environmental Information Management System) suite of modules. This module is designed to link directly with the geo-data stored in a customer’s ESRI GIS server so users can view their Telog Enterprise sites located on their own maps.

Beta users of Telog’s GIS module have been very enthusiastic about the capabilities available within the GIS module. It’s now easy to visually correlate Telog RTU sites with the pipes they’re monitoring. Using ESRI’s Silverlight viewer along with software developed by Telog, users have a rich feature set at their disposal. A few of the module’s features are: Being able to create spatial groupings on the fly, live status information for all Enterprise sites, displaying both geo-data and Enterprise site attributes, automatically zooming to groups, a powerful search tool plus several more convenient features.

This new module requires a connection to an ESRI GIS server (most Telog customers with an Enterprise license also have a license for an ESRI GIS server). The module works with both the Telog Web Module and the Telog Enterprise Client. It will also be available for Telog Data Hosting (DMS) customers as well as Enterprise licensees.

Here’s a typical scenario which will demonstrate some of the GIS module features. An ops supervisor receives an alarm message on their cell phone stating there was a dramatic pressure drop on a 24” main at 6th Ave near Elm St. Five more pressure alarms are quickly received (all the alarms were generated by Telog RTUs monitoring these sites). A quick check using the GIS module shows six sites glowing red. By selecting those sites and right clicking a new Enterprise group can be formed. By using the Zoom to group feature, the extent of GIS display is now limited to the boundaries of the six sites. From this view it’s clear that all the sites are on mains connected to the same 24” line; making it obvious that all the alarms were probably caused by one event rather than six separate problems. Once crews have been dispatched it’s then easy to monitor the status of all the sites during the repair with a quick scan of the GIS module.

This is just one simple example of using the GIS module and it describes only a small part of the module’s uses. The primary point to remember is that Telog’s GIS substantially extends the geo-data investment which most water authorities have already made, by combining it with Telog Enterprise’s powerful tool set. This combination gives users an exciting new level of analytic and presentation capabilities that wasn’t possible until now.

For an overview of the mapping feature watch the video below:
Image 1	As we continue to upgrade and add new features to our current software packages, we are very excited about a new mapping feature that is included in the newest release of Telog Web Module Version 5 (TWM5). This innovative feature combines the ease of use that users will be familiar with when it comes to online mapping programs with our powerful Telog Web Module software. Many things will seem familiar when it comes to setting up user accounts, defining system reports, and linking various types of data from Enterprise to the web. Navigating in TWM5 is very user friendly.
A zooming feature is present that gives users the power to zoom directly to street level or out as far as a global view. This will be a powerful tool as users will be able to define the exact coordinates of a site using longitude and latitude and monitor the status of each site. We have included a color guide that lets users know immediately the status of each site. The colors are defined as follows: Green – Normal Red – Alarmed Yellow – Late Orange – Low Battery Gray – Unknown Different types of maps are available including Google Maps® (licensing may be required) and open source maps. In addition, we can implement users’ custom maps as long they conform to standard GIS formats (e.g. - WMS).	Image 2
	Another defining characteristic is the fact that when viewing from far away, locations with multiple sites will cluster together as shown in image 1. However, as the user zooms closer, the sites will separate into their specific defined areas. In addition, it is possible for the user to click on a site and go directly from the map to the actual data from that site as viewed in image 2. Users will now have the power to view their sites and the status of each site from anywhere that they can access the Internet. TWM5 combines the desire to view and share data with the ability to monitor sites into one powerful, easy to use software package.

Telog Instruments is pleased to offer this feature which can be purchased as an add-on to your Telogers Enterprise Software.

The National Oceanic and Atmospheric Administration (NOAA) provides daily weather observations as well as current and historical tidal data through the Center for Operational Oceanographic Products and Services (CO-OPS). Through this feature, you can retrieve this data and store it within the Enterprise database. You can then incorporate this information into reports to detect correlations between changes in their data and changes in the surrounding environment.

Though NOAA data is available to the public, this new module streamlines the entire process of retrieving the data. Instead of manually querying NOAA’s web server and storing the data, Enterprise provides you with a complete list of stations and the measurements currently available for each station. Simply choose a station and the desired measurements, and Enterprise will retrieve that data and store it automatically in the user’s Enterprise database.

To display this information, the Telog module stores the metadata for each of the sites, including the station identification code, station name, site location, as well as the currently available measurements for each station. The location includes the state and county in which the station resides, as well as latitude and longitude coordinates when provided. This metadata can be automatically updated using a scheduled Enterprise job. This means that instead of taking time to search through weather and tide data, you can let Enterprise do the work for you and have NOAA data readily available for any daily, weekly, or monthly timestamp you choose.

The module also provides the ability to select the date range of the data you want to retrieve. You will have the option of retrieving predetermined or custom date ranges or restrict the retrieval to new data only. This is done by determining the most recent data point in the Enterprise database and retrieving any missing data between that data point and the current time. This allows you to create an automated job that will consistently retrieve up-to-date information while minimizing any missing data due to system downtime.

With all of this information in one location, Enterprise makes it easier for you to make informed decisions based on the interaction of environmental conditions and your own systems. The ability to have up to date weather and tidal data on hand at any time will not only assist you in keeping your system running efficiently, but will also help you plan for the future.

Telog Enterprise & SCADA Interface

Overview
This document gives a conceptual view of how Telog Enterprise remote data acquisition systems can interface a HMI/SCADA system. Four methods for transferring data from Enterprise to a HMI/SCADA system are described in this document plus one for transferring data from a HMI/SCADA system to Enterprise; all are low cost and relatively simple to implement.
Telog Enterprise data are stored in a Microsoft SQL database - MS SQL Server 2005, 2008, 2012, MS SQL Express 2005, 2008 or 2012. All data from the Telog remote RTUs are first brought into the SQL database and then shared through Enterprise via the Telog Web Module, Enterprise Client or third party software via one of the methods below.

SQL Queries
Our most popular automated method of data transfer is via SQL queries. This method is the most flexible and allows users to extract precisely the data they need. Telog provides all the necessary information to successfully query an Enterprise database. Telog provides the database schema, sample database and sample query for customers choosing this method of data transfer. Our customers simply setup SQL queries for their HMI/SCADA database which transfer the desired data from the Telog Enterprise database to their HMI/SCADA system using the information Telog provided.

ModBus Interface
Enterprise software will respond to ModBus queries using the Telog ModBus Emulator (TME). If the HMI/SCADA software can communicate using ModBus over an Ethernet (MBE) connection then you can poll the Telog TME. The TME will emulate ModBus tags and registers for each Telog recorder channel in your Telog System. The TME will maintain the most recent readings for each of the recorders and store them in the appropriate registers. To the SCADA software it will appear as though it is talking directly to the remote units.

OPC
The OPC driver uses industry standard OPC protocol; it allows SCADA software to collect Telog RTU data from the Enterprise database. In this method, an Enterprise OPC Server makes data available to the HMI/SCADA system application. These data are updated during each communication with a remote recorder. OPC is a more flexible interface protocol than the TME but less so than SQL queries.

Export Feature
Telog Enterprise software has an export feature which enables users to manually export data into CSV files. Data are selected using the Enterprise Client application or Telog Web Module. One chooses the desired measurements and timeframe and then employs an export feature which converts the chosen SQL data to CSV format and stores in a user named file. These data can then be imported into the SCADA database using its CSV import capabilities. The data export can be invoked manually or scheduled for automatic exportation.

Importing SCADA Data into Enterprise Telog’s SCADA Module
The Telog SCADA Module allows data that are captured by a SCADA system to be imported and stored within Telog Enterprise. Because most organizations are concerned about maintaining the security of their SCADA system, data transfers from SCADA to Enterprise are strictly on a push basis. Typically Telog customers have a firewall between their SCADA system and their Enterprise software. That firewall is configured such that communications can’t be initiated from outside the firewall. Telog’s SCADA Module will never initiate SCADA data transfer; it waits for data to be pushed to it from the SCADA system. This design helps maintain the security of the SCADA system by blocking attempts to access the system that are initiated from outside the firewall.

Because of the security architecture, there are two main components to the Module. One component is software which resides within the SCADA network that collects and pushes the data to the firewall. The other component is software that waits on the other side of the firewall for the pushed data; when those data appear the software then imports the data into the Enterprise database.

Telogers Enterprise System

One Solution From a Single Supplier

Telogers Enterprise System Applications and Solutions

Wastewater Collection:

Water Distribution:

Telog Enterprise & SCADA Interface

Products

Solutions

Support

Contact