SQL Databases

Overview

Publisher transport persists processed events to a configured SQL database and table. The insert statement is dynamically generated from a StreamEvent, attribute names and types need to match the table definition.

This feature is idea for offline analytics, business reporting, dashboards and process testing.

Driver details

Any compliant type 4 JDBC driver

The required database JDBC driver jar file must be placed within the userlibs directory to be added to the Joule runtime classpath.

Example

sqlPublisher:
  jdbcDriver: org.postgresql.Driver
  host: jdbc:postgresql://localhost:5740
  database: testdb
  table: s1mme
  includeTimestamps: true
  properties:
    ssl: true
    user: postgres
    password: postgres

Attributes schema

Configuration parameters available for the InfluxDB publisher transport. The parameters are organized by order of importance, ranked from high to low.

Attribute	Description	Data Type	Required
jdbcDriver	Full jdbc namespace	String
host	JDBC url	String
database	Database name	String
table	Target loading table	String
includeTimestamps	Bucket where event measurements are persisted	Boolean Default: False
properties	Database specific properties.	Properties map
batchSize	Insert batch size	Integer Default: 1024
timeout	Timeout to send queued events to be inserted into database	Long Default: 5000ms
autocommit	Sets connection's auto-commit mode to the given state. true to enable auto-commit mode; false to disable it	Boolean Default: false

Supported databases

All relational databases that support type 4 JDBC driver implementation.