Options for Basic Logging of Process Data to Databases and Text Files

What is data logging?

For many projects, the user simply needs to just log some data points to a database or CSV file for some basic reporting or trending purposes. Such applications typically don't have the large quantity of tags with frequent data changes that would generally require the data compression and sophistication of a full-blown historian.

For such basic logging needs, an OPC data logging solution meets the need and Software Toolbox has several options that work with TOP Server and other OPC Servers, depending on the specific requirements of the project to meet that need.

Need help deciding? Contact Us through chat on this page or by email below

ASK AN EXPERT

Log data from any OPC UA and DA server source to databases and CSV

The OPC Data Logger is a separately licensed application that also runs as a service and can log to text files, including CSV format for us in Microsoft Excel.  It also supports native database connections to MS Access, SQL Server, MySQL, Oracle and ODBC.

Take a look at the first OPC Certified Client application at the OPC Data Logger web site for more detailed information.  The Software Toolbox OPC Data Logger can connect to any OPC Server, with features including:

  • Easy-to-setup with wizard-driven configuration
  • OPC Certified for Compliance - insures interoperability
  • Native drivers for Oracle, MySQL, & SQL Server insures reliable database connectivity (i.e. no ODBC used)
  • Runs as a Windows Service
  • Automatic recovery of lost connections
  • Buffers data when connection to data storage lost
  • Test new configurations without suspending active logging
  • Automatic tag import capabilities
  • No artificial tag limits
  • No artificial OPC server connection limits
  • No database or text file connection limits
  • Extensive diagnostics and troubleshooting tools
  • Provides valuable process data to help you save money by improving your process

ODBC data logging from OPC and non-OPC data sources with Cogent DataHub

The Cogent DataHub makes logging from various data sources easy - write data from the DataHub into any ODBC-compliant database, such as Microsoft SQL Server, SQL Express, MySQL, Oracle, and many more. You can use your existing tables, or create new ones fully customized to meet your needs.

And DataHub's wide variety of data interfaces allows logging far more than just OPC systems.

Integrated ODBC logging for your TOP Server drivers 

The TOP Server ODBC DataLogger plug-in is an easy to configure application that logs data from any TOP Server driver to any ODBC-compliant database.

The component's tight integration with the TOP Server provides substantial unique benefits such as simple installation, high-efficiency performance, and easy browsing of tags in the TOP Server address-space.

Choosing the Right Solution

  • For logging from just TOP Server drivers, the TOP Server ODBC DataLogger plug-in is a good choice.
  • For logging from TOP Server and other OPC server data sources, the OPC Data Logger is recommended.
  • For logging from both OPC and other various data sources including other ODBC data sources, DDE data sources, MQTT data sources, Linux/QNX systems, and others, the Cogent DataHub is recommended.

Need help deciding? Contact Us through chat on this page or by email below

ASK AN EXPERT

Get Started Now

The demo is the full product once licensed. Once a client application connects to the  TOP Server, the TOP Server runtime will operate for 2 hours at a time. At the end of the 2 hour demo period, the demo timer must be reset by restarting the TOP Server runtime service.

Connect with Us

1-888-665-3678 (US + Canada toll free)
+1-704-849-2773 (Global)
support.softwaretoolbox.com