Combine Information of two Databases with one Config

Elastic Stack Logstash
1

Hello there,

i use two databases. A relational and non relational one.
I want to combine (join) the Information of the two databases with logstash.

For instance i want the value of a sensor from the non relational database. and the information where the sensor is located in the relational database.

So i select from the non relational database and join the result with the relational database.

Is this possible with logstash?

Thanks to all =)

2

Nothing's impossible, but Logstash isn't very good with this kind of joining.

3

I solved the problem.

I stored the information of the relational database in Elasticsearch.

If i import the data from the non relational database, i use the elasticsearch-filter-plugin to join fields to the incoming data. =)