SCADA Tutorial #12 | Database Management, Data Logging and SQL Integration
đź“Ś In this lesson of the Wise SCADA training series, we take an in-depth look at Database Management, which plays a critical role in recording, storing, and analyzing historical data in industrial automation systems.
You will learn how to choose the most suitable database type for your projects (SQLite, MySQL, or Microsoft SQL Server), how to configure database connections, and how to apply data retention and optimization settings to ensure high performance and long-term stability.
The lesson also demonstrates how data can be recorded periodically (time-based) or event-driven (trigger-based), how database connection health can be monitored via Tags, and how licensing and system limits affect database usage in real-world SCADA projects.
🔊 Multi-Language Audio Available! This Wise SCADA training video includes multiple audio tracks. Click the Settings (⚙️) icon and select “Audio Track” to choose your preferred language.
đź“Ś What You Will Learn in This Lesson
✅ Database Selection – Differences and use cases of SQLite, MySQL, and Microsoft SQL Server
✅ Connection Settings – Server connection, authentication, and database creation
✅ Table Management – Column creation, Tag mapping, and structure synchronization (Check Table)
✅ Status Monitoring – Tracking database connection health (Connected / Fault) via Tags
✅ Data Retention Strategies – Performance optimization using Row Limit and Day Limit
✅ Logging Methods – Periodic logging and Trigger-based data recording
✅ Licensing and Limits – Capacity and logging limitations of database systems
- 00:00 – Introduction and Database Management Panel
- 00:29 – SQLite Database and Its Advantages
- 01:49 – MySQL Database Connection
- 02:02 – Microsoft SQL Server Connection
- 03:38 – Checking Database Structure (Check Table)
- 04:07 – Default Database and Alarm Logs
- 04:33 – Monitoring Connection Status (Connected & Fault Tags)
- 05:47 – Adding Columns and Historical Tag Settings
- 08:40 – Logging Period, Row Limit, and Day Limit (Retention)
- 10:00 – Data Logging with Triggers
- 11:20 – Database Limits and Licensing Information