Video Tutorial: Conditional Logging to Database from Non-Standard Devices

Posted by Kevin Rutherford on May 31, 2018 2:00:00 PM

OmniServer Wedges are included with OmniServer Professional Edition.  Wedges are built-in components providing additional useful capabilities that expand the functionality of OmniServer beyond its core connectivity and data parsing abilities for non-standard devices.

The OmniServer Database Wedge allows you to log your device data to any ODBC-compliant database, including SQL, with a highly configurable format and flexible conditions.  And this ability is built into OmniServer, eliminating the need for separate external components or applications.

In this video blog, I'll show you how to get started using the OmniServer Database Wedge to easily log process data based on specified conditions, making it possible to monitor trends in your process and easily report on your process data or troubleshoot any issues that are discovered.

Watch this video to learn how to get started using the OmniServer Database Wedge, including basic setup, for logging to an ODBC-compliant database based on the condition of process data from your non-standard devices.

Just to summarize, in this video, I've shown you:

  1. How to configure OmniServer Database Wedge properties:
    1. General properties including the Initial Mode, Notification and Last Error system items.
    2. Trigger condition and settings for your OmniServer Database Wedge (i.e. the logic which determines when to log your data to database).
    3. Optional Reset properties for writing back to an OmniServer item when the Trigger condition is true.
    4. Database properties
      1. Define the database name and log-in credentials
      2. Specify the table to log to.
      3. Specify whether to append or overwrite data to the table.
    5. Data properties
      1. Define the columns, the actual data and the data types to log.
  2. The resulting table displayed in MS SQL based on the how-to configuration.

Don't forget to subscribe to our blog to find out about the latest updates to TOP Server.

Ready to log data to a database from your own devices using OmniServer Professional?

Log Process Data from Non-Standard Devices to DB w/ Free Trial

Topics: Wonderware, Device Integration, ODBC, Data Logging, OmniServer, SQL, Video Tutorials, Wedges

Join Our Journey

Working in industrial automation since 1996, the Software Toolbox team has seen a lot. The level of automation system sophistication of our integrators and users has evolved, each driven by the demands of their market and clients.  Everyone's learning continues as technological change accelerates.

This blog is about sharing from these journeys.  From tips on implementing software, successes our clients have experienced, or new ideas and things to consider in your journey, we'll be sharing them here.

Subscribe to Our Blog

Recent Posts

Posts by Topic