# Logstash data pipeline from Elastic to SQL Server
**URL:** https://discuss.elastic.co/t/logstash-data-pipeline-from-elastic-to-sql-server/123589
**Category:** Logstash
**Created:** [March 12, 2018, 4:04pm UTC](https://discuss.elastic.co/t/logstash-data-pipeline-from-elastic-to-sql-server/123589 "2018-03-12T16:04:26Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@jruzicka](https://discuss.elastic.co/u/jruzicka)
#### Post date: [March 12, 2018, 4:04pm UTC](https://discuss.elastic.co/t/logstash-data-pipeline-from-elastic-to-sql-server/123589/1 "2018-03-12T16:04:26Z")
We have a series of reports running in SSRS. There is data we are only sending to Elastic that I'd like to reference in SSRS. What I'd like to do is create a pipeline that can query elastic and output specific fields to a SQL Server table so that we can easily reference from SSRS. Any examples of this or best practices? Most of what I find is the other way, using jdbc as an input plugin with Logstash, not output.
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [March 12, 2018, 4:37pm UTC](https://discuss.elastic.co/t/logstash-data-pipeline-from-elastic-to-sql-server/123589/2 "2018-03-12T16:37:30Z")
The jdbc output is a third-party plugin, not one from elastic, which might explain why it is not discussed here much. It can be found at [https://github.com/theangryangel/logstash-output-jdbc](https://github.com/theangryangel/logstash-output-jdbc). I have not done it, but what you are suggesting seems completely doable.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 9, 2018, 4:37pm UTC](https://discuss.elastic.co/t/logstash-data-pipeline-from-elastic-to-sql-server/123589/3 "2018-04-09T16:37:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.