Joule
Search
K
Comment on page

SQL Databases

Publisher transport persists processed events to a configured SQL database and table. The insert statement is dynamicallty generated fom 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 JDBC Type 4 driver
Database specific JDBC driver jar file placed within the userLibs directory.

Example configuration

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

Core Attributes

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.
Last modified 8mo ago