Module for writing data to a database. Currently supports database vendors PostgreSql, MSSQL, Oracle and DB2 out of the box, MySQL and MariaDB on request. Additional database vendors can easily be added, please contact [email protected] with your request.

Parameters

• Database Connection ****DB connection defined in Administrator -> Connections
• Database table – table to update
• Update type –
  • Insert – inserts new records
  • Update – updates existing records using keys defined in field mapping
  • Replace – creates if not existing, update if existing
  • Delete – deletes record
• Field mapping – dynamically configured mapping between database table and Collector data. Each key column is indicated with checkbox.

Parameter setup example