0%
Follow Us
Download SIOTH®
Follow Us
Download SIOTH®
OPC Server for Databases Overview

OPC Server for Databases

  • Delivers a robust plug and play solution for connecting OPC clients to enterprise databases
  • Enables seamless data exchange between relational databases such as SQL Server, Oracle, MySQL, and MS Access
  • Integrates smoothly with SCADA, DCS, HMI systems, and data historians
  • Supports both real time and historical data access for unified monitoring and analysis
OPC Server for Databases architecture diagram: OPC DA and HDA connectivity to Oracle, SQL Server, and MySQL

OPC Server for Databases Features

Data Access Capabilities

  • OPC DA Compatibility:Full OPC Data Access specification support for real-time process data 
  • OPC HDA Integration: Historical Data Access for trend analysis and reporting 
  • Raw and Processed Data: Transfer original data or apply aggregations (interpolation, min, max, average, range, total) 
  • Bi-Directional Communication: Both read and write operations supported 

Configuration and Management

  • Graphical Interface: Intuitive configuration environment for database connections and table mapping 
  • Automatic reconnection to database servers after network glitches
  • Import of OPC Tags from CSV files
  • Export of OPC Tags into CSV files

Industrial Integration

  • OT Connectivity: Direct integration with supervisory control and data acquisition and DCS systems via standard OPC interfaces 
Frequently Asked Questions
The server natively supports Microsoft SQL Server, Oracle, MySQL, Microsoft Access, and Wonderware Historian. 
The server includes an intuitive graphical configuration interface that lets you set up database connections and map tables and columns. No scripting is required, making the setup accessible to both technical and non technical users.
The server can transfer raw historical data or apply aggregation functions including interpolation, minimum, maximum, average, range, and total. This reduces the load on client applications and provides ready to use analytical data.
By offering a standardized OPC interface to enterprise databases, the server bridges IT systems such as databases, ERP, and MES with OT systems such as SCADA, DCS, and HMI. This removes data silos and enables unified operational intelligence.
Yes. The server provides real time synchronization, automatically detecting and propagating the latest data changes to connected OPC clients.
Resources & Documentation

OPC Server for Databases Resources

Quick User Guide

Step-by-step installation and configuration guide

User Guide

Step-by-step installation and configuration guide