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.
Any compliant JDBC Type 4 driver
Database specific JDBC driver jar file placed within the userLibs directory.
sqlPublisher:
jdbcDriver: org.postgresql.Driver
host: jdbc:postgresql://localhost:5740
database: testdb
table: s1mme
includeTimestamps: true
properties:
ssl: true
user: postgres
password: postgres
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 |
All relational databases that support type 4 JDBC driver implementation.
Last modified 8mo ago