Easy to Build Reports from Automation Data

Easy to Build Reports from Automation Data

Data are worthless without the ability to put it into a context and present it in a simple way to decision makers—no matter where in the company they reside. Enter Ocean Data Systems (ODS) and its product Dream Report.

Note: Dream Report obviously is an advertiser on this blog. However, I’m not a trade magazine, so writing about advertisers isn’t mandatory. I’ve known the Marketing VP for almost 20 years, and he has always represented quality products. I pass this along not as a reviewer but because I think it’s useful.

Ocean Data Systems (ODS) announced that Dream Report version 4.82 is posted and available for download. Along with a broad array of Customer Software Change Requests (SCRs), this release delivers on a theme of Partner Connectivity. Dream Report is now the official solution for the Aveva – ClearSCADA solution and version 4.82 includes drivers to access historical values, historical messages and real-time values. This release also includes new connectivity for the OSIsoft – PI Historian and Asset Framework. Enhanced connectivity is also delivered for the Aveva – Wonderware Online InSight product and the Dream Report – Advanced ODBC Driver for time series data in SQL Databases.

General features and benefits improvements include an enhanced Automatic Statistic Table to add flexibility for ad-hoc analysis, new access to Table Footer data delivering the ability to enhance report calculations using table footer results and support for .xlsm (Excel File Format) to support macros.

“Each new ‘Purpose Built’ Driver added to Dream Report enables Dream Report to ideally support a new market segment and lets those customers benefit from Dream Report – Compliance Reports, Performance Dashboards and Ad-hoc Analysis,” explained Roy Kok, VP Sales and Marketing for Ocean Data Systems. “We always include enhancements that benefit our entire installed base and this release is no different. The Dream Report release notes, in the documentation directory, will detail all changes.”

Founded in 2004, Ocean Data Systems develops software solutions for industrial compliance and performance; reports, dashboards, and ad-hoc analysis and troubleshooting. Dream Report delivers both local and Internet connectivity to all major HMI/SCADA, Historian and business data sources through either proprietary or industry standard drivers. Dream Report’s markets include process, hybrid and discrete; with special functionality for Life Sciences (Pharmaceutical and Biotech), Water, Wastewater, Heat Treat, Building Automation, Energy Management and Manufacturing Operations.

These are the main features of Dream Report:

1- DATA COLLECTION
Dream Report integrates a robust communication kernel to collect data and alarms from multiple real time and historian sources. It uses OPC, OLE, and ODBC standards to connect and collect Data from different suppliers. Moreover, ODS develops custom drivers to leverage native history from SCADA systems, DCS, RTU and more….

2- DATA LOGGING
Dream Report integrates a powerful historian module to log clean and accurate data in any standard database such as SQL Server, Oracle, MySQL, Access…
This unique feature position Dream Report not only as a reporting tool, but also as the ideal solution of field Data integration for enterprise applications.

3- DATA EXTRACTION & ANALYSIS
Dream Report integrates a user friendly object library to extract Data statistics and analysis to be displayed in multiple views like tables, Bars, Pies, Charts and more…

4- REPORT DESIGN
Dream Report’s studio integrates an intuitive graphical editor to create and save state of the art reports as templates.

5- REPORT GENERATION & DISTRIBUTION
Dream Report enables to generate reports manually and automatically. The automatic mode enables to execute report on event and on schedule. When ready, reports can be automatically printed, emailed, stored and published over the web.

Industrial Networks—Multi-Purpose Safe Area Modbus Scanner

Industrial Networks—Multi-Purpose Safe Area Modbus Scanner

Precision Digital Modbus ScannerI’m not a Modbus scanner expert, but this new industrial networks product came to me from a friend I trust. Looks interesting.

Precision Digital Corp., global supplier of digital panel meters and control instrumentation celebrating its 40th year in business, announced the Vantageview PD6730X Modbus Scanner. The PD6730X is a rugged, NEMA 4X/IP65 Modbus master, slave, or snooper (sniffer). The multi-purpose PD6730X is designed for accurate display of and quick access to information, locally or remotely, in wet or dirty environments.

It can accept up to 16 individually programmed process variables (PVs) from multiple devices; four math channels allow for calculations on multiple PVs. The SafeTouch through-window buttons allow operation without removing the cover. The pulse input accepts a wide range of flow transmitter signals, including mV input from a magnetic flowmeter, as well as high frequency signals. The PD6730X includes backlighting, two open collector outputs, and an analog output as standard.

“The versatile Vantageview PD6730X is loaded with features that plant operators can appreciate,” said Jeffrey Peters, President, Precision Digital. “It is simple to program using our free ScanView EX software, displays critical information about the process, and can be seen from wide angles and a distance. The PD6730X is designed for readability and ease of use, from large character and Feet & Inches displays to automatic rate conversions and data logging. Plus, it integrates easily into existing Modbus networks.”

The PD6730X Decimal Display models feature an upper display that is 0.7 inches high and shows five digits of information; the Feet & Inches models feature a level display that reads up to 399 feet, 11 and 15/16 inches and contains a 20-segment tank level indicator. The lower display for both models is 0.4 inches high, with seven alphanumeric characters, for Process Variables, Custom Units, or Tags. The bright LCD display is easily read under varying lighting conditions and from viewing angles of up to +/- 40 degrees (twice that of competitive models); it can also be rotated in 90-fdegree increments for increased readability.

Four sensors in the PD6730X operate as through-window buttons for programming and operation without removing the cover in wet or dirty areas.

These SafeTouch buttons include an energy saving mode to save power, extend battery life, and prevent unintended triggers.

The PD6730X provides flexible power options, including battery, DC with battery backup, DC only, output-loop, or output loop with battery backup. Its element-resistant enclosure provides three threaded conduit holes and integrated pipe or wall mounting holes. Operating temperatures range from -40 to 75 degrees C.

Mitsubishi Growing An Integrated Automation and Manufacturing Platform

Mitsubishi Electric Automation has been somewhat quietly building out a version of the connected manufacturing enterprise for several years. Known for machine control and motion control, it first made a splash by partnering with ILS Technology to develop [email protected] This is connecting technology moving data from the control system to enterprise databases.

It recently announced an “[email protected] Alliance Program” that included several connectivity companies. It’s latest announcement is that eWON, which offers industrial VPN routers and Ethernet modems for remote access to PLCs and machines, is the newest member.

eWON devices allow original equipment manufacturers, systems integrators and end users to support their systems remotely. Consequently, eWON’s participation in the [email protected] Alliance Program gives Mitsubishi Electric’s customers greater options for anywhere, anytime access to their systems. eWON access options include remote HMI capability to monitor the machines using a built-in web server, data logging capabilities and alarming features.

As with all [email protected] Alliance Program products, Mitsubishi Electric has thoroughly tested the eWON solutions to ensure ease of implementation and compatibility with its own products. No programming of Mitsubishi Electric hardware is required to use eWON devices, other than setting the correct IP addresses.

“With the addition of eWON to our [email protected] Alliance Program, OEMs, systems integrators and end users can remotely access their systems across the globe,” said Robert Miller, senior manager, strategic collaborations and partnerships, Mitsubishi Electric Automation, Inc. “This eliminates the need for an engineer’s on-site presence to access a system, saving both time and money.”

Mitsubishi Electric’s [email protected] Alliance Program is a third-party referencing program with other automation hardware and software vendors that allows customers to select solutions that best solve their automation challenges. Through pre-engineered integration, the latest technologies are easier to use and more cost effective. Complete documentation, including quick start guides, sample programs and maintenance screens when required, are available for each solution, drastically reducing the time necessary to implement and maintain the solutions.

eWON joins third-party hardware and software vendors Balluff, COGNEX, LEM®, MDT Software, eWON, Kepware Technologies, Ocean Data Systems – Dream Report, CC-Link Partner Association and Powerit Solutions in the Mitsubishi Electric Automation [email protected] Alliance Program.

Rockwell Automation to Acquire vMonitor for Connecting the Digital Oilfield

Rockwell Automation to Acquire vMonitor for Connecting the Digital Oilfield

The Manufacturing ConnectionHere is an interesting acquisition. It shows Rockwell’s continuing commitment to developing solutions in the process / production industry. It also partially answers a question that came to mind when I saw a press release that CEO Keith Nosbusch was speaking at a world Internet of Things conference. This fits.

Rockwell Automation Inc. announced that it has agreed to purchase vMonitor, a global technology provider of wireless solutions in the oil and gas industry.

(from the press release—superlatives theirs, I don’t know the company but I presume I’ll learn more in Houston week after next) VMonitor is a pioneer in digital oilfield implementation and remote operations worldwide. It delivers innovative monitoring and control solutions for wellhead and upstream applications that combine cutting-edge wireless instrumentation and communication with visualization software to help customers make more informed decisions and improve production.

VMonitor has the world’s largest installed base of wireless wellhead monitoring systems for natural and artificially lifted wells with more than 6,000 well sites for major oil and gas companies around the world.

“Strategically, vMonitor’s world-class digital oilfield technology and services, combined with our comprehensive portfolio of solutions, strengthen our ability to deliver end-to-end projects for the oil and gas sector,” said Terry Gebert, vice president and general manager, Rockwell Automation Global Solutions.

“Equally important, vMonitor’s capabilities will accelerate our development of similar process solutions and remote-monitoring services for water/wastewater, mining and other industries globally,” said Gebert.

“Our customers will benefit from the Rockwell Automation global solutions capabilities and complementary product lines to ensure we can collectively provide a seamless integrated solution,” said Rashed Saif Al Suwaidi, chairman of vMonitor. “Our employees will also join an innovative, fast-growing technology leader serving the worldwide oil and gas industry.” VMonitor has about 120 employees at offices located in Houston, Mumbai, India, Abu Dhabi, United Arab Emirates and other Middle East locations.

The company’s technologies include an all-wireless portfolio of wellhead sensors and transmitters, remote terminal units, gateways and modems, as well as turnkey monitoring, and control systems and services. These offerings cover a broad range of applications from oil and gas wells, pipelines, pumping and lift stations, to refineries and tank farms.

The acquisition is expected to close within two months. VMonitor will then become part of the Rockwell Automation Control Products and Solutions operating segment.

Automation: New HMIs Are Rugged with Modular Expansion and Protocol Conversion

Automation: New HMIs Are Rugged with Modular Expansion and Protocol Conversion

Automation, HMI

Red Lion Graphite HMI Family

Red Lion Controls, the global suppliers of products in communication, monitoring and control for industrial automation and networking, has released its newest generation of Human Machine Interfaces (HMI) – the Graphite series of advanced operator interface panels. “With all cast-aluminum construction, the Graphite series provides the industry’s first rugged HMI solution to combine a wide range of versatile plug-in modules with protocol conversion, data logging and web-based monitoring and control.”

Red Lion’s Graphite series allows customers to easily connect, monitor and control their process in industries that include manufacturing, oil and gas, and water/wastewater. The series’ range of plug-in modules enables customers to easily create a solution for today, with an option to expand to meet changing business requirements. Further, organizations will realize a reduction in development and commissioning times over traditional systems that use an HMI paired with separate I/O, PLCs and other controllers.

“We have used just about everyone’s HMIs, and Graphite is by far the best in terms of appearance and functionality,” said Pierre de Giorgio, president at BlueBay Automation. “It is the most feature-rich HMI that we have ever used, the graphics and resolution are amazing, and with Red Lion’s Crimson 3.0 software, the move to Graphite is seamless.”

Graphite HMIs are available in eight different models, in sizes ranging from 7” to 15”, with sleek bezels that provide a relatively large display given their overall dimension. Both the 7” and 10” HMIs are available as sunlight visible models. Combined with Graphite’s rugged packaging, these models are ideal for harsh outdoor environments.

Offering a built-in web server, Graphite HMIs enable users to monitor and control their application via PCs, tablets or smartphones. SMS text-messaging and email alerts provide early warning of process issues, which helps to avoid costly downtime. In addition, its built-in protocol converter allows programmers to select 13 or more simultaneous protocols from a list of over 250 to seamlessly integrate disparate devices such as PLCs, drives, barcode readers and panel meters.

“The HMI has become the nexus of the machine, and Red Lion’s new Graphite series offers the highest level of protocol support to simplify even the most complex multi-vendor environments,” said Jeff Thornton, director of product management at Red Lion Controls. “By logging performance data and critical events, customers can implement process improvements or perform fault-finding activities.”

The new HMIs are supported by Red Lion’s Crimson 3.0 software, which is included at no extra cost. Crimson 3.0 makes it fast and easy to configure protocols, define data tags, set up sophisticated applications and create an attractive user interface. Designed for ease of use, Crimson allows customers to cost-effectively standardize on one HMI for all of their machines, regardless of the PLC or drive manufacturer used.