fluent-plugin-mssql-lookup
Fluentd filter plugin that resolves additional fields via a database lookup
In order to communicate with the SQL Server database, we use FreeTDS. Consequently this will need to be installed in order to use the plugin. This repository also contains Dockerfile that adds FreeTDS to the standard image provided here.
A prebuilt version of this Docker image is available at http://quay.io/datasoft-computing/fluentd
Requirements
| fluent-plugin-mssql-lookup | fluentd | ruby |
|---|---|---|
| 1.x.x | >= 0.14.0, < 2 | >= 2.1 |
Installation
RubyGems
$ gem install fluent-plugin-mssql-lookup
Bundler
Add following line to your Gemfile:
gem "fluent-plugin-mssql-lookup"And then execute:
$ bundle
Config parameters
db_user
The user name to use to connect to the database
db_user myuser
db_password
The password to use to connect to the database
db_password mypassword
db_host
The database server host name or ip address
db_host mydbserver
db_name
The name of the database to connect to
db_name mydb
db_port
The database port to connect to (default 1433)
db_port 1433
lookup_sql
The SQL to execute to populate the lookup list
lookup_sql "SELECT ID, Field1, Field2 FROM mytable"
lookup_key
The field within the lookup list that will be used to join to the event key field
lookup_key ID
lookup_interval
The recurring interval (in seconds) at which to refresh the lookup list (default 600)
lookup_interval 1200
key
The key field in the event
key id
Copyright
- Copyright(c) 2019 Datasoft Computing Ltd
- License
- Apache License, Version 2.0