title: Logstash SQL Server Data Import
body: <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>input {
    jdbc {
      jdbc_driver_library =&gt; "sqljdbc4.jar"
      jdbc_driver_class =&gt; "com.microsoft.sqlserver.jdbc.SQLServerDriver"
      jdbc_connection_string =&gt; "jdbc:sqlserver://192.168.2.126\\SQLEXPRESS2014:1433;databaseName=test
   jdbc_password =&gt; "sa@sa2015"
      schedule =&gt; "0 0-59 0-23 * * *"
      statement =&gt; "SELECT ID , Name, City, State,ShopName FROM dbo.Shops"
   jdbc_paging_enabled =&gt; "true"
      jdbc_page_size =&gt; "50000"
    }
  }
  filter {
  }
  output {
    stdout { codec =&gt; rubydebug }
      elasticsearch { 
          protocol =&gt; "http"
    index =&gt; "shops"
    document_id =&gt; "%{id}"
      }
  }</code></pre>
  </div>
  </div>
  </p>
  
  <p>I want to import data in ElasticSearch using Logstash using JDBC SQL Server as input but I am getting error class path is not correct.</p>
  
  <p>Anybody know how to connect using Logstash for correct location for sqljdbc FILE WITH CONFIG FILE</p>