FreertosHow-ToBeginner · 4 min read

How to Connect PLC to Database: Simple Guide

To connect a PLC to a database, use an OPC UA server or middleware software that reads PLC data and writes it to the database. The PLC communicates with the OPC UA server, which acts as a bridge to transfer data safely and reliably to the database.

📐

Syntax

Connecting a PLC to a database typically involves these parts:

PLC: The device generating data.
OPC UA Server: Middleware that reads data from the PLC.
Database Client: Software or script that writes data from OPC UA server to the database.

Each part uses its own communication protocol and configuration.

freertos

PLC -> OPC UA Server -> Database Client -> Database

💻

Example

This example shows a Python script using the opcua library to read data from an OPC UA server connected to a PLC and insert it into a SQLite database.

python

from opcua import Client
import sqlite3

# Connect to OPC UA server (replace with your server URL)
opcua_client = Client("opc.tcp://localhost:4840")
opcua_client.connect()

# Connect to SQLite database
conn = sqlite3.connect('plc_data.db')
cursor = conn.cursor()

# Create table if not exists
cursor.execute('''CREATE TABLE IF NOT EXISTS sensor_data (id INTEGER PRIMARY KEY, value REAL)''')

try:
    # Read value from OPC UA node (replace with your node id)
    node = opcua_client.get_node("ns=2;i=2")
    value = node.get_value()

    # Insert value into database
    cursor.execute('INSERT INTO sensor_data (value) VALUES (?)', (value,))
    conn.commit()
    print(f"Inserted value {value} into database.")
finally:
    opcua_client.disconnect()
    conn.close()

Output

Inserted value 23.5 into database.

⚠️

Common Pitfalls

Wrong OPC UA server URL: Make sure the URL matches your PLC's OPC UA server address.
Incorrect node IDs: Use the correct node identifiers to read data.
Database connection errors: Ensure the database is accessible and the schema matches your data.
Security settings: OPC UA servers may require certificates or authentication.

python

## Wrong way: Using incorrect node id
node = opcua_client.get_node("ns=2;i=999")  # Node does not exist
value = node.get_value()  # This will raise an error

## Right way: Use correct node id
node = opcua_client.get_node("ns=2;i=2")
value = node.get_value()

📊

Quick Reference

Steps to connect PLC to database:

Set up OPC UA server on or near the PLC.
Identify the data nodes you want to read.
Write or use middleware to read OPC UA data.
Insert or update data in your database using scripts or software.
Handle errors and secure connections properly.

✅

Key Takeaways

Use an OPC UA server as a bridge between PLC and database for reliable data transfer.

Correctly configure OPC UA server URL and node IDs to read PLC data.

Use middleware or scripts to insert PLC data into the database.

Handle security and connection errors carefully to maintain data integrity.

Test the full data flow from PLC to database to ensure it works as expected.