Advance Dashboard Library
Pre-built Highcharts dashboard templates for atvise SCADA
Capabilities
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.
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.
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.
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.
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.
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.
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.
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.
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
Free
Free
Evaluate the module on a real project.
Works Great With
Pre-built Highcharts dashboard templates for atvise SCADA
Visual report builder for atvise SCADA โ design, schedule and distribute industrial PDF reports
Photovoltaic plant monitoring for atvise SCADA โ from the string to the grid, configured rather than coded