json-scada icon indicating copy to clipboard operation
json-scada copied to clipboard

A portable and scalable SCADA/IIoT-I4.0 platform centered on the MongoDB database server.

JSON:SCADA Logo

{json:scada}

A portable and scalable SCADA/IIoT-I4.0 platform centered on the MongoDB database server.

Mission Statement

To provide an easy to use, fully-featured, scalable, and portable SCADA/IIoT-I4.0 platform built by leveraging mainstream open-source IT tools.

Screenshots

screenshots

Major features

  • Standard IT tools applied to SCADA/IoT (MongoDB, PostgreSQL/TimescaleDB, Node.js, C#, Golang, Grafana, etc.).
  • MongoDB as the real-time core database, persistence layer, config store, SOE historian.
  • Event-based realtime async data processing with MongoDB Change Streams.
  • Portability and modular interoperability over Linux, Windows, Mac OSX, x86/64, ARM.
  • Windows installer available in the releases section.
  • Unlimited tags, servers, and users.
  • Horizontal scalability, from a single computer to big clusters (MongoDB-sharding), Docker containers, VMs, Kubernetes, cloud, or hybrid deployments.
  • Modular distributed architecture. Lightweight redundant data acquisition nodes can connect securely over TLS to the database server. E.g. a Raspberry PI can be a data acquisition node.
  • Extensibility of the core data model (MongoDB: NoSQL/schema-less).
  • HTML5 Web interface. UTF-8/I18N. Mobile access. Web-based configuration management.
  • Role-based access control (RBAC).
  • Various high-quality protocol drivers.
  • Integration with MQTT brokers (compatibility with Sparkplug B).
  • Live point configuration updates.
  • Inkscape-based SVG synoptic display editor.
  • PostgreSQL/TimescaleDB historian integrated with Grafana for easy creation of dashboards.
  • Easy development of custom applications with modern stacks like MEAN/MERN, etc. Extensive use of JSON from bottom up.
  • Leverage a huge ecosystem of MongoDB/PostgreSQL tools, community, services, etc.

Use cases

  • Power/Oil/Gas/Manufacturing/etc Local Station HMI.
  • SCADA Protocol Gateway.
  • SCADA Control Centers.
  • SCADA/IIoT Historian.
  • Intranet/Internet HTTPS Gateway - Visualization Server.
  • Multilevel Systems Integration (SCADA/IIoT/ERP/MES/PLC).
  • Global-Level/Cloud SCADA Systems Integration.
  • Edge processing.
  • Data concentrator for Big Data / ML processing.
  • Digital Transformation, Industry 4.0 enabler.

Architecture

architecture

Documentation

Protocols Roadmap

  • [x] IEC 60870-5-104 Server TCP/TLS
  • [x] IEC 60870-5-104 Client TCP/TLS
  • [x] IEC 60870-5-101 Server (Serial, TCP)
  • [x] IEC 60870-5-101 Client (Serial, TCP)
  • [ ] IEC 60870-5-103 Client
  • [x] DNP3 Client (TCP, UDP, TLS, Serial) - Windows x64 only!
  • [ ] DNP3 Server (TCP, UDP, TLS, Serial)
  • [x] MQTT/Sparkplug-B Client
  • [x] I104M (adapter for some OSHMI drivers)
  • [x] ICCP Client (via I104M)
  • [x] Telegraf Client (OPC-UA, MQTT, MODBUS, SNMP, ...)
  • [x] OPC UA Client
  • [x] OPC UA Server
  • [ ] OPC UA Historical Data Server
  • [ ] OPC DA Client
  • [ ] Modbus Client
  • [ ] IEC 61850 MMS Client
  • [ ] IEC 61850 GOOSE Client
  • [x] CIP Ethernet/IP (libplctag, experimental)
  • [ ] Siemens S7
  • [ ] BACNET

Features Roadmap

  • [x] Web-based Viewers
  • [x] Web-based Configuration Manager
  • [x] Excel-based Configuration
  • [x] User auth/Role-based Access Control (RBAC)
  • [x] Inkscape-based SVG Synoptic Editor
  • [x] Compiled Calculations Engine
  • [x] Customizable Change-Stream Processor (for user implemented scripts)
  • [ ] Low-latency/Interpreted Calculations Engine
  • [x] Basic Alarms Processor
  • [ ] Advanced Alarms Processor
  • [x] PostgreSQL/TimescaleDB Historian
  • [x] Grafana Integration
  • [x] Grafana Alerting Integration (w/ Events Viewer)
  • [x] Windows Installer
  • [x] Online Demo
  • [x] Docker Demo (docker-compose.yaml scripts)
  • [ ] Linux Image / VM
  • [x] Supervisor (Linux process manager) examples
  • [ ] InfluxDB Integration
  • [x] Telegraf Integration
  • [ ] Kafka Integration
  • [x] PowerBI Integration (via PostgreSQL connector)
  • [ ] PowerBI Direct Integration
  • [ ] NodeRed Integration
  • [x] Metabase Integration (via PostgreSQL/MongoDB connectors)
  • [ ] Alerta Integration (https://alerta.io/)
  • [ ] PLC4X Integration (https://plc4x.apache.org/)
  • [ ] Managed Cloud Service
  • [x] SAGE (brazilian SCADA from CEPEL) web displays visualization

Online Demo (substations simulation)

  • http://150.230.171.172

This demo provides a public IEC 60870-5-104 server port on IP address 150.230.171.172:2404 (common address = 1) for testing.

The demo data is published as regular MQTT topics to the public broker mqtt://test.mosquitto.org:1883 (about 8600 topics in JsonScadaDemoVPS/# and ACME_Utility/#).

Data is also published as Sparkplug-B to mqtt://test.mosquitto.org:1883 (about 4300 device metrics in spBv1.0/Sparkplug B Devices/+/JSON-SCADA Server/#). Data/birth messages are compressed by Eclipse Tahu Javascript libs.

Developer Contact

  • https://www.linkedin.com/in/ricardo-olsen/