Fluent::Plugin::Mssql22

Installation

RubyGems

gem install tiny_tds connection_pool fluent-plugin-mssql22

Bundler

Add following line to your Gemfile:

gem 'fluent-plugin-mssql22'
gem 'tiny_tds'
gem 'connection_pool'

And then execute:

bundle

Configuration

• query : A single SQL statement using placeholder (?{key})
• poolsize : Size of connection pool
• session_options : Session SET options. separated by semicolons (;)

• (TinyTds Configuration ↓)
• username
• password
• host
• port
• database
• timeout
• login_timeout
• dataserver (..next version)

Example

<match metric.**>
  @type mssql22
  username "put"
  password "put!@#$"
  host "192.168.100.185"
  port 14434
  database "Metrics"
  query "EXEC USP_AddMetrics @Name='?{name}',@Data='?{data}';"
  poolsize 20
  session_options "SET ANSI_NULLS ON;SET ANSI_PADDING ON;SET ANSI_WARNINGS ON;SET ARITHABORT ON;"
  timeout 10
  login_timeout 10

  <buffer>
    @type memory
    total_limit_size 128MB
    flush_interval 1s
    flush_at_shutdown true
    flush_thread_count 20
    retry_forever true
  </buffer>
</match>