Logstash data pipeline from Elastic to SQL Server

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.

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. I have not done it, but what you are suggesting seems completely doable.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.