Advanced OPC Data Logger

Trust In Confidence!

For Windows 2000 - Windows 10 (2019) (incl. Server, x86 and x64). Latest version: 3.7.0 build 1020. .


How to log OPC data to a SQL database

This guide shows how to log OPC UA or OPC DA data into a database in three easy steps. Reading a value from the OPC Data Access server or writing a data value can be achieved without any programming.

  1. Install the OPC Data Logger software.
  2. Add an OPC group and the necessary OPC tags.

    OPC group settings

    Fig.1. OPC group settings

    OPC DA or OPC UA tag selection

    Fig.2. OPC DA or OPC UA tag selection

  3. Configure the database connector that can work with MS SQL Server, MySQL, Oracle, MS Access, and other databases.

    SQL database connector

    Fig.3. SQL database connector

How to map OPC server data to a SQL database

  1. Go to the data export plugin settings.
  2. Import a table description from your SQL database.

    SQL database table

    Fig.4. SQL database table

  3. Link an OPC tag to a column in the dialog window.

    SQL database mapping

    Fig.4. SQL database mapping

What data types supported

The program support all major data types of OPC DA or OPC UA interfaces:

  • Signed and unsigned integers (1, 2, 4, and 8 bytes).
  • Float (single and double precision).
  • Boolean.
  • Strings (UTF8 and ASCII).
  • Date and timestamps.
  • Other minor data types.

Supported databases

The OPC Data Logger software supports all popular databases.

  • Microsoft SQL Server (you can use stored procedures, custom SQL queries, high data transfer speed).
  • MySQL (supports stored procedures, custom SQL queries, high performance).
  • Oracle (allows using stored procedures, custom SQL queries, high data transfer speed).
  • Microsoft Access.
  • PostgreSQL (allows using stored procedures, custom SQL queries, high performance).
  • Firebird.
  • OLEDB-compatible databases.
  • ODBC-compatible databases.

Operating System Compatibility

Windows Server 2019, Windows 10, Windows Server 2016, Windows 7, Windows Server 2012, and older operating systems down to Windows XP SP3.

OPC Compatibility

  • OPC Data Access 2.05a
  • OPC Data Access 2.00
  • OPC Data Access 1.0a
  • OPC Data Access 3.00
  • OPC UA Data Access

Do I need third-party components?

You should install runtime components for OPC DA that provide client access to an OPC server. Please, visit the opcfoundation.org

Microsoft SQL Server - client tools for the SQL Server database. All modern OS already includes database drivers for this database.

MySQL - The computer with the OPC software should contain "libmysql.dll." Usually, it comes with the MySQL database.

Related articles:

OPC and DCOM Configuration on Windows 2008 and Windows 7

OPC and DCOM Configuration on Windows Server 2012 and Windows 8