Database Export

Export FabConnect data to external databases.

Database Export

FabConnect can export data to external databases for analytics and reporting.

Supported Databases

PostgreSQL
MySQL
InfluxDB (time-series)
TimescaleDB
ClickHouse

Configuration

yaml

exports:
  - name: analytics-db
    type: postgres
    connection: postgres://user:pass@host:5432/analytics
    tables:
      - events
      - metrics
      - alarms
    batch_size: 1000
    interval: 60s

Schema

sql

CREATE TABLE events (
  id UUID PRIMARY KEY,
  equipment_id VARCHAR(50),
  event_type VARCHAR(50),
  data JSONB,
  created_at TIMESTAMPTZ
);

CREATE TABLE metrics (
  time TIMESTAMPTZ,
  equipment_id VARCHAR(50),
  metric_name VARCHAR(50),
  value DOUBLE PRECISION
);