Videos – Data Logging

Data Historian

Data logging for IIoT data to SQL Server, Oracle, Access, mySQL, SQL Azure, MongoDB, MariaDB, SQLite, PostegreSQL, Cassandra, and CSV files.

Getting Started Data Logging

How to setup data logging for all Open Automation Software logging types.

  • 00:00 – Introduction
  • 01:30 – Getting Started
  • 03:00 – Continuous Logging
  • 04:15 – SQL Server
  • 06:25 – Save Changes
  • 07:00 – Continuous Narrow Logging
  • 09:30 – Event Driven
  • 11:20 – Handshake Confirmation
  • 12:45 – High Speed Logging
  • 15:00 – Log to Stored Procedure
  • 15:25 – Triggers
  • 16:30 – Event Narrow Logging
  • 18:00 – Timestamps
  • 20:30 – Snapshot Logging
  • 21:45 – Specific Time of Day Logging
  • 22:50 – Data Change Row Logging
  • 25:15 – Data Change Narrow Logging
  • 26:45 – Networking
  • 31:55 – Store and Forward
  • 37:30 – Disable Store and Forward
  • 40:15 – Update Records
  • 40:50 – Dynamic Server, Database, and Table
  • 41:10 – Automatic Deletion
  • 41:40 – CSV File Logging
  • 45:30 – Programmatic Interface
  • 46:45 – CSV Export / Import
  • 48:20 – One Click Automation
  • 52:20 – Transaction Logging
  • 54:25 – System Errors
  • 56:00 – Contact Us
  • 56:50 – Read Database Data

10 Things Your Data Historian Should Do

How to implement data logging automated features for local and networked data logging demonstrating data buffering.

Data Accuracy

See how OAS transfers all values over a network with 100 nanoseconds resolution and log with store and forward to MS SQL Server.

OAS Performance

See 100,000 Open Automation Software tags running on a Raspberry Pi 4 all updating once per second and logged to a SQL Server database over a network.

One Click Database

Automatically setup data logging to SQL Server of all data from Kepware OPC Server in one step.

Log Buffered PLC Data

Log high speed buffered data from a controller at 1 millisecond per sample.

Logging Data from ControlLogix at High Speed

Quick demonstration of logging high speed data from an Allen Bradley ControlLogix processor to SQL Server.

Update Records

How to setup Data Logging to update existing records based on dynamic query Tag.

High Speed Data Logging

How to log data with 100 nanosecond resolution for up to 1,000,000 records per second to SQL Server from a .NET application.

Store and Forward

How to setup data logging so there is no data loss on a network or database engine failure.