LGH File Inspector for AVEVA InTouch (formerly Wonderware) enables easy, scalable, fast access to local daily historical data files (*.lgh files) logged by AVEVA InTouch applications without the limitations imposed by other solutions. There are many advanced features in the product and options for automating queries to run without user interaction to generate reports, exports, and more.
Software Toolbox Technical Blog
Video Blog: Automating LGH File Inspector Queries
1 min read
By Zachary Parham on Jul 27, 2023 2:00:00 PM
Video Tutorial - Logging Dynamic JSON Data to SQL or MES
2 min read
By Rodrigo Restrepo on May 4, 2023 2:00:00 PM
JSON (JavaScript Object Notation) is a file format that has become fairly common in the industrial automation industry for storing data or information (including such things as configuration files). But also as one of the most common data formats used by RESTful APIs and web services, which are commonly used for providing a range of useful information including energy prices and weather data.
Sometimes, of course, depending on the application, some or all components of JSON packet might be variable or dynamic in nature, which can make it difficult for off-the-shelf industrial software solutions to properly parse the information from those packets.
In this post, I will cover step-by-step how to leverage the scripting capabilities of the OPC Router to access and parse JSON packets either from a JSON file saved to a specific file directory or from a RESTful web service after which that data can be used with any of the other connectors that OPC Router supports. For this example, we log the data to a SQL database.
Video Tutorial: Real-Time Collection for Siemens S7 TCP/IP Ethernet
2 min read
By Lauren Conrad on Nov 17, 2022 2:00:00 PM
If you're reading this, you likely have at least one Siemens S7 PLC on your network being used in your industrial process and need to integrate data from that process. And if you're still using traditional Siemens variable-type addressing to access your S7 controllers, you need traditional S7 TCP/IP protocol connectivity.
In this video blog, I'll show you how to get started using our Siemens TCP/IP Ethernet driver to connect and gather real-time process data from Siemens S7 PLCs for AVEVA software applications and other clients.
Video Tutorial: Real-Time Collection for Modbus Devices
1 min read
By Lauren Conrad on Oct 13, 2022 2:00:00 PM
Modbus is one of the most widely used protocols around the world, implemented as the communications protocol by many different vendors for integration with other systems. If you're reading this, you likely have at least one Modbus device (whether it's a PLC, RTU or other device) being used in your industrial process and need to integrate data from that process.
In this video blog, I'll show you how to get started using our Modbus TCP Ethernet driver and it's flexible settings to connect and gather real-time process data from pretty much any Modbus Ethernet capable device for HMI, SCADA, MES and other client applications.
Video Tutorial - Email Reports / Alerts from OPC & Other Data Sources
2 min read
By John Gonzalez on Sep 29, 2022 2:00:00 PM
It's important for any enterprise to have actionable data in the timeliest fashion for making decisions. Minimizing downtime and increasing performance are important to the profitability of any company and knowledge at the point of action is key.
To that end, automating notifications or reports based on the latest process data from your various systems can ensure you're never in the dark when it comes to your processes.
In this post, I will cover step-by-step how to easily automate email notifications and reports for OPC and data sources with the OPC Router for giving you and other decision makers the knowledge you need to make informed decision as quickly as possible.
Video Tutorial: Real-Time Collection for AB Logix Family Controllers
1 min read
By Lauren Conrad on Sep 22, 2022 2:00:00 PM
Allen-Bradley's Logix family of PLCs and PACs is one of the most popular controllers across many automated industries. If you're reading this, you likely have at least one Logix controller being used in your industrial process and need to integrate data from that process.
In this video blog, I'll show you how to get started using our ControlLogix Ethernet driver to connect and gather real-time process data from Logix controllers for HMI, SCADA, MES and other client applications.
Video Tutorial: Using DataHub Advanced MQTT Parsing
4 min read
By Win Worrall on Aug 25, 2022 2:00:00 PM
Cogent DataHub® is a gateway that enables a wide range of connectivity interfaces for different data sources such as OPC UA, OPC DA, ODBC, DDE and so much more. Included in those available interfaces is the ability to act as both an MQTT client and broker even including Sparkplug B support for enabling MQTT integration with many other types of systems that don't natively support MQTT.
A key facet of the MQTT specification that can sometimes be complex for our users and cause issues with compatibility between DataHub and other MQTT clients and brokers is how to handle the formatting of MQTT messages. As you may or may not know, while MQTT does specify how to construct a message header for routing by an MQTT broker, it does NOT specify the actual message content. This tends to be a challenge when MQTT clients from different developers need to work together, since they need to be using the same format for the message content.
In this video blog, I'll show you how to use DataHub V10's Advanced MQTT Parser capability to specify flexible formats that will work with virtually any other vendor's MQTT clients and brokers.
Video Tutorial: Real-Time Collection for Siemens S7 Plus Ethernet
2 min read
By Kevin Rutherford on May 26, 2022 2:00:00 PM
If you're reading this, you likely have at least one Siemens S7 PLC on your network being used in your industrial process and need to integrate data from that process. And, like many of our Siemens users, you're likely interested in accessing symbolic references (versus the traditional Siemens variable addresses) supported by newer S7 controllers.
In this video blog, I'll show you how to get started using our Siemens S7 Plus Ethernet driver (part of the Siemens S7 Plus Suite) to connect and gather real-time process data from Siemens S7-1500 and S7-1200 PLC symbolic variables/tagnames for AVEVA Wonderware applications.
About this Blog
We're engineers like you, so this blog focuses on "How to" appnotes, videos, tech team tips, product update announcements, user case studies, and other technical updates. Subscribe to updates below. Your feedback and questions on posts are always welcomed - just use the area at the bottom of any post.
Subscribe to our Blog
Recent Posts
Posts by Topic
- Device Integration (208)
- Wonderware (181)
- OPC UA (124)
- OPC (106)
- DataHub (78)
- TOP Server (74)
- Technical Support (73)
- Video Tutorials (64)
- OmniServer (60)
- OPC DA (44)
- Protocols (44)
- AVEVA (33)
- Automation 101 (28)
- Security (26)
- OPC Router (24)
- OmniServer Did You Know (24)
- Tunneling (22)
- connectivity (22)
- DCOM (17)
- Developer Tools (16)
- OPC Data Client (16)
- IT/OT (14)
- MQTT (14)
- OPC Tunnel (13)
- CSV (12)
- LGH (12)
- OPC Data Logger (12)
- DataHub V9 (11)
- OPC Gateway (11)
- drivers (11)
- Database (10)
- Exploring OPC UA (10)
- software (10)
- reporting (9)
- Dream Report (8)
- OPC Integration (8)
- SQL (8)
- Troubleshooting (8)
- AVEVA OPC UA Client (7)
- Alarming (7)
- ODBC (7)
- OPC Router Basic Training (7)
- Siemens (7)
- Case Studies (6)
- Data Logging (6)
- DataHub Training (6)
- EFM (6)
- OPC Server (6)
- ProtocolDesign (6)
- REST (6)
- SuiteLink (6)
- xml (6)
- Bridging (5)
- DataHub V10 (5)
- Email (5)
- Flow (5)
- Google IoT (5)
- OPC Alarms and Events (5)
- OPC Conversion (5)
- Redundancy (5)
- Development (4)
- Earth Day (4)
- Industrial Decisions (4)
- Integrating XML Data (4)
- Modbus (4)
- OPC Bridge (4)
- OmniServer User Stories (4)
- SLIK-DA (4)
- Sustainability (4)
- web service (4)
- Amazon IoT (3)
- Azure IoT (3)
- Business Intelligence (3)
- Developing OPC Clients (3)
- Email Alert (3)
- Error Detection (3)
- Historian (3)
- IT & Infrastructure (3)
- Logging (3)
- OPC Redundancy (3)
- SMS (3)
- Wedges (3)
- Windows (3)
- Azure SQL (2)
- Control System Redundancy (2)
- ControlLogix (2)
- DCOM Horror Stories (2)
- DDE (2)
- Email Notification (2)
- Excel (2)
- Flow-Cal (2)
- Ignition (2)
- InTouch (2)
- LGH User Stories (2)
- OPC Toolkit Benefits (2)
- OSIsoft (2)
- Oil & Gas (2)
- Omron (2)
- PGAS (2)
- Process Alert (2)
- Scripting (2)
- Building Automation (1)
- CRC (1)
- Camera (1)
- Conditional Logging (1)
- Customization (1)
- DNP (1)
- ERP (1)
- How to Develop Custom OPC Clients (1)
- InfluxDB (1)
- Kinesis (1)
- LRC (1)
- Linux (1)
- Mining/Metals (1)
- Mitsubishi (1)
- MySQL (1)
- OPC Data Logger User Stories (1)
- Omni Flow (1)
- Power & Utilities (1)
- Predictive Analytics (1)
- Predictive Maintenance (1)
- Process Alerts (1)
- QNX (1)
- Rockwell (1)
- S7-1500 (1)
- Sparkplug B (1)
- Tunnel Performance (1)
- WITS (1)
- Water & Wastewater (1)
- aggregation (1)
- error handling (1)
- json (1)
- non-Windows (1)