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.
