Software Toolbox Technical Blog

3 min read

OPC Data Logger Features to Be Excited About in the V3.7.0.1 Release

Aug 15, 2019 2:00:00 PM


As you are probably aware, OPC Data Logger is an OPC lab-certified solution for dynamic, event driven logging of process data to standard SQL/ODBC databases, including Microsoft Azure SQL, or text/CSV files.  As part of the continuous improvements process for OPC Data Logger, we have regular product releases that provide updates to existing features and new functionality.

In this blog post, I'll cover some flexible new features that you may not be aware of from our most recent releases of the OPC Data Logger available now in V3.7.0.1.

Our most recent releases for the OPC Data Logger have focuses on new features and functionality targeted at improving your text logging and MySQL logging experience.  Let's take look at some of those key updates:

1. Only Log A Text File Header Once

Prior to the current version, the header line that the OPC Data Logger would insert when logging to a text file would occur every time the text file was opened or, if disabled, a header wouldn't be logged at all.  Rather than an all or nothing approach, users have been asking for an option to only log the text file header a single time (i.e. once at the top), since the header wouldn't be changing for the underlying data.

So, for our users of the Text File Logger in OPC Data Logger, the default option in a Text File Logger is now to log only a single header per text file.  This corresponds to the Text File Logger properties under the "Header" section called "Log Single Header Per File" which is checked by default.

Screenshot -  Log Single Header Per File setting

This makes a text log much easier to manage since there will no longer be unnecessary headers included throughout the file.

2. Improved Text File Spanning Capabilities

We've also greatly improved the file name syntax formatting options available for use when spanning text files when appending a date/time to the file name.  Formats such as "yyyy_MM_dd_HH_mm_ss" that are available by default can be supplemented by entering your own custom formats including the ability to include seconds and/or milliseconds in the file name and to use 24 hour time mode.

Screenshot - Text File Spanning Date/Time in File Name

This increases the granularity of possible file names when spanning files, minimizing any risk of overwritten text log files.

3. OPC Data Logger Now Supports MS Server 2019

OPC Data Logger Supports Server 2019

To keep OPC Data Logger compatible with the latest Microsoft technology, OPC Data Logger is now officially supported on Microsoft Server 2019 operating systems.

This ensures that OPC Data Logger users who prefer to adopt newer operating systems early can install OPC Data Logger without any concerns about compatibility.

4. Enhanced MySQL Support including MySQL V8

OPC Data Logger supports MySQL V8

And last, but not least, we have improved support for our MySQL users and OPC Data Logger.  OPC Data Logger now officially supports MySQL Version 8.  Additionally, if you're using stored procedures in MySQL, OPC Data Logger now supports improved mapping of SPROC input parameters, regardless of how the procedure is written.

We've also added increased security for MySQL by including SHA256 password encryption support for access to MySQL databases from OPC Data Logger.  All of these enhancements will improve your experience when logging to MySQL - if you're using the MySQL Logger in OPC Data Logger, there's no better time to migrate to the latest version.


If you haven't subscribed to our blog, I would encourage you to sign up to receive updates on posts like this regarding new releases, how-tos and other useful information on Software Toolbox solutions and topics.

Want to try out the latest OPC Data Logger for yourself?  Download the free trial.

Download Latest OPC Data Logger Free Trial

Marc Holbach
Written by Marc Holbach

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

See all