Store telemetry data in Firebird, an open-source relational database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
firebirdsql.org
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Yes | string | Firebird server hostname or IP. |
| User | Yes | string | Database user. |
| Password | Yes | string | User password. |
| Database | Yes | string | Database path/name. |
Example Configuration
Server=192.168.1.100
Database=/var/firebird/proxus.fdb
User=SYSDBA
Password=*****Data Schema
CREATE TABLE ProxusDeviceData (
OID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
DEVICE_ID INT NOT NULL,
DEVICE_NAME VARCHAR(255),
"KEY" VARCHAR(255) NOT NULL,
"VALUE" BLOB SUB_TYPE TEXT NOT NULL,
DATA_TYPE VARCHAR(64) NOT NULL,
TIME TIMESTAMP NOT NULL
);
CREATE INDEX IDX_DEVICE_TIME ON ProxusDeviceData(DEVICE_ID, TIME);