Databases & Time-Series Storage

Integration guides for relational, time-series, and search databases such as PostgreSQL, InfluxDB, and Elasticsearch.

These guides describe how to persist shop floor data in relational databases, time-series databases, and search engines, and how to feed query results back into MQTT topics. The following guides are available:

Guide	Connector	Description
Microsoft SQL Server	MSSQL	Write production events and poll query results.
PostgreSQL	SQL	Write production events and poll query results.
MariaDB	SQL	Write machine state changes and poll aggregated summaries.
TimescaleDB	SQL	Write time-series data into hypertables and poll aggregates.
QuestDB	HTTP/REST	Stream time-series data using InfluxDB Line Protocol over HTTP.
ClickHouse	HTTP/REST	Stream data into MergeTree tables over the HTTP interface.
InfluxDB	InfluxDB	Deploy InfluxDB as a service and store OPC UA data.
Elasticsearch	MQTT	Ship data to Elasticsearch using the Filebeat MQTT input.