# Combine Information of two Databases with one Config

**URL:** <https://discuss.elastic.co/t/combine-information-of-two-databases-with-one-config/62719>\
**Category:** Logstash\
**Created:** [October 11, 2016, 2:00pm UTC](https://discuss.elastic.co/t/combine-information-of-two-databases-with-one-config/62719 "2016-10-11T14:00:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![TWalter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/twalter/32/41239_2.png) [@TWalter](https://discuss.elastic.co/u/TWalter)\
**Post date:** [October 11, 2016, 2:00pm UTC](https://discuss.elastic.co/t/combine-information-of-two-databases-with-one-config/62719/1 "2016-10-11T14:00:40Z")

</div>

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 =)

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 11, 2016, 8:37pm UTC](https://discuss.elastic.co/t/combine-information-of-two-databases-with-one-config/62719/2 "2016-10-11T20:37:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![TWalter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/twalter/32/41239_2.png) [@TWalter](https://discuss.elastic.co/u/TWalter)\
**Post date:** [October 18, 2016, 8:50am UTC](https://discuss.elastic.co/t/combine-information-of-two-databases-with-one-config/62719/3 "2016-10-18T08:50:01Z")

</div>

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. =)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:33am UTC](https://discuss.elastic.co/t/combine-information-of-two-databases-with-one-config/62719/4 "2017-07-06T04:33:45Z")

</div>