foratvise
Get Started
Standalone Product
New module

SQL Connectivity Module

Log OPC UA values into tables, read rows back into nodes, call stored procedures and download recipes to the PLC with read-back verification. SQL Server, PostgreSQL/TimescaleDB, MySQL/MariaDB, Oracle, SQLite and generic ODBC run through a dedicated bridge, so a slow or unreachable database never freezes the SCADA server.

Promotional Video
No install required

Capabilities

Everything you need in one module

Six Database Families, One Workspace

SQL Server, PostgreSQL/TimescaleDB, MySQL/MariaDB, Oracle, SQLite and generic ODBC from the same interface. Create, test and diagnose connections, with failover and TLS, without leaving atvise.

A Dedicated Data Bridge

The data plane runs in its own SQL Bridge service instead of the atvise script thread. Connection pools, timeouts and buffering live there, so a database that stalls cannot freeze the SCADA server. The bridge listens only on 127.0.0.1 with a bearer token.

Transactions Built From Object Types

Map OPC UA nodes to tables and procedures with six transaction types โ€” wide log, narrow log, block/arrays, bidirectional sync, stored procedure and query to nodes โ€” and six triggers: interval, cron, change with deadband, expression, edge with handshake and batch snapshot. Templates start from an Object Type.

Query Studio and Query Library

Explore the schema and run SQL through the bridge, then save named, parameterized queries. Query Nodes publish results back into the address space, and saved queries can be consumed over REST.

Recipes & Batches

Keep versioned setpoint sets and download them to the PLC with read-back verification, so what is in the controller is checked against what the recipe says.

Store & Forward With Quarantine

When the database is unreachable, rows are buffered locally in SQLite and delivered once it returns. Rows that cannot be delivered go to quarantine for review instead of being lost.

Monitoring & Diagnostics

The module publishes its own health as OPC UA diagnostic nodes, with an Overview tab for connections, active transactions, backlog and bridge latency, plus a bridge log and audit trail.

Roles, Audit & Protected Credentials

Four roles โ€” administrator, engineering, operations and readonly โ€” gate every action on the server side. Database passwords are encrypted in the bridge vault and never stored in OPC UA nodes.

Optional AI Assistant

Ask for queries against your real schema, explain errors and review proposed changes before they are applied. Choose The Marketplace, Anthropic, OpenAI, Google, OpenRouter or a local Lodestar server; provider keys stay in the bridge vault.

Technical Details

Specifications & Requirements

Min. atviseยฎ version3.14
DatabasesSQL Server, PostgreSQL/TimescaleDB, MySQL/MariaDB, Oracle, SQLite, generic ODBC
Data planeDedicated SQL Bridge service on 127.0.0.1, with connection pools, timeouts and TLS
CommunicationOPC UA session to atvise + webMI control plane
Transactions6 types, 6 triggers, templates by Object Type
ResilienceStore & Forward buffer with quarantine
Security4 roles, audit trail, database credentials encrypted in the bridge vault
LanguagesEN / ES / DE
ThemesLight / Dark / Blue
DeploymentSingle XML import in atvise Builder
Free license1 saved connection and 2 saved transactions; the Standalone SQL Table viewer is always free
License modelOne hardware-bound license per machine, validated offline

Free

Free

Evaluate the module on a real project.

  • 1 database connection
  • 2 transactions
Get the free version

Paid

$2,000 USD

or 2,000 EUR

One-time payment ยท Perpetual license

  • Unlimited version
  • No limit on connections or transactions
Contact sales

Works Great With

Related Modules

View all modules
Available

Advance Dashboard Library

Pre-built Highcharts dashboard templates for atvise SCADA

Dashboard LibraryLearn more
Available

Reporting Library

Visual report builder for atvise SCADA โ€” design, schedule and distribute industrial PDF reports

Reporting LibraryLearn more
Available

atvise PV Suite

Photovoltaic plant monitoring for atvise SCADA โ€” from the string to the grid, configured rather than coded

PV SuiteLearn more