# Continuous Data from SQL Server into Logstash

**URL:** <https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929>\
**Category:** Logstash\
**Created:** [December 7, 2018, 12:35pm UTC](https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929 "2018-12-07T12:35:29Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![mubarak\_shaik](https://avatars.discourse-cdn.com/v4/letter/m/c6cbf5/32.png) [@mubarak\_shaik](https://discuss.elastic.co/u/mubarak_shaik)\
**Post date:** [December 13, 2018, 6:16am UTC](https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929/8 "2018-12-13T06:16:02Z")

</div>

Hi @balumurari1 ,

input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:sqlserver://XXXXX;databaseName=XXXX;integratedSecurity=false;"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_user =\> "XXXX"  
jdbc\_password =\> "XXX"  
jdbc\_driver\_library =\> "/path/jre8/sqljdbc42.jar"  
statement =\> "SELECT id,name FROM sampletable where id\> :sql\_last\_value "  
tracking\_column =\> "id"  
use\_column\_value =\> true  
last\_run\_metadata\_path =\> "/path/.logstash\_jdbc\_last\_run"  
schedule =\> "\*/5 \* \* \* \* \*"  
}  
}

output {  
elasticsearch {  
hosts =\> "[http://localhost:9200](http://localhost:9200)"  
index =\> "sampleindex"  
}  
stdout{ }  
}

---

_[View the full topic](https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929)._