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

What Is OPC UA Server for Databases?

  • Direct OPC UA access to enterprise and operational databases
  • Native connectivity to SQL Server, Oracle, MySQL, Microsoft Access, and Wonderware Historian
  • Support for any ODBC- or OLEDB-compliant database
  • Secure, standards-based communication via OPC UA
  • Real-time and historical data exposure to SCADA, DCS, HMI, and historian systems
  • Fast deployment with no custom development required
OPC UA Server for Databases architecture diagram: SQL database linked to OPC UA clients and control systems

OPC UA Server for Databases Features

SQL like Database Connectivity

  • Multi-database support: Connect simultaneously to Microsoft SQL Server, Oracle, MySQL, Microsoft Access, and Wonderware Historian 
  • ODBC/OLEDB compatibility: Integrate with SQL like database supporting standard database drivers 
  • Flexible architecture: Handle multiple database connections into the same OPC UA interface  

Data Access & Management

  • Real-time data access: Read latest database values instantly through OPC UA nodes 
  • Historical data retrieval: Access archived data for trend analysis, reporting, and compliance 
  • Bidirectional communication: Both read and write capabilities for full data synchronization 
  • Table mapping: Graphically configure database tables and columns as OPC UA address space 

Security

  • OPC UA security framework: Built-in encryption, digital signatures, and certificate-based authentication 
  • UA TCP & HTTPS protocols supportUser authentication 
  • Event logging: Track all data access and modifications for traceability requirements 

Configuration & Administration

  • Intuitive graphical interface: Configure servers, databases, and tag mappings without coding 
  • CSV import/export: Bulk manage thousands of OPC tags efficiently 

Frequently Asked Questions

The server natively supports Microsoft SQL Server, Oracle Database, MySQL, Microsoft Access, and Wonderware Historian. It also integrates with any database supporting ODBC or OLEDB drivers, including PostgreSQL, IBM DB2, SAP HANA, and more.

Yes. You can connect to multiple databases at the same time, even if they are different types, and expose them through a single OPC UA address space.

Yes. It works with cloud-hosted databases such as Azure SQL Database, Amazon RDS, Oracle Cloud, and Google Cloud SQL, supporting both on-premises and hybrid deployments.

The server supports full bidirectional communication. You can read and write into OPC UA tags using your OPC UA Client application. The write access control will depend on the user configured to access the databases.

ODBC provides basic database access but lacks OPC UA features such as standardized data modeling, subscription-based updates, built-in security, and native SCADA/HMI compatibility. This solution combines ODBC flexibility with OPC UA industrial capabilities.

It leverages OPC UA’s security framework, including certificate-based authentication, encryption, message signing, role-based access control, and detailed audit logging.

The server maintains OPC UA connectivity, keeps the last collected values with its related quality status until the database connection is restored.

Most deployments can be completed in 1 hour. Simple setups can be operational in under 15 minutes, while more complex multi-database environments typically take 1 to 2 days.

Resources & Documentation

OPC UA Server for Databases Resources

Product Datasheet

Comprehensive technical specifications and features overview

User Guide

Step-by-step installation and configuration guide

Related Blogs

See the OPC product in action with real-world examples

Demo Video

See it in action