I have 2 separate MSSQL databases and would like to extract data from them, combine it and send it to ES for indexing.
Can Logstash connect to more than 1 MSSQL database, retrieve certain data from them then combine the retrieved datasets into 1 document and send it to ES for indexing?
logstash can certainly connect to more than one database. It is possible you would want to use an aggregate filter to combine events, or perhaps use data from one database to enrich documents from the other using either a jdbc_streaming or jdbc_static filter.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.