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.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.