# Join multiple input with different input types

**URL:** <https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123>\
**Category:** Logstash\
**Created:** [January 14, 2019, 10:24am UTC](https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123 "2019-01-14T10:24:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaire](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaire/32/38866_2.png) [@chaire](https://discuss.elastic.co/u/chaire)\
**Post date:** [January 14, 2019, 10:24am UTC](https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123/1 "2019-01-14T10:24:48Z")

</div>

I'm using Logstash along with Filebeat, Elasticsearch, and Kibana. I have 2 inputs to join, one is a filelog (Apache file) and another one is database file (sql).  
I can't find any documentation that explains how to use 2 inputs and join them and make centralized visualization in the Kibana.  
So, can I ask here what are the steps to follow?

Thank you for the guidance.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [January 14, 2019, 10:39am UTC](https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123/2 "2019-01-14T10:39:15Z")

</div>

How do you want to join them? Are you adding data to the apache log based on data in the SQL database?

---

<div class="post-metadata">

**Author:** ![chaire](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaire/32/38866_2.png) [@chaire](https://discuss.elastic.co/u/chaire)\
**Post date:** [January 16, 2019, 3:33am UTC](https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123/3 "2019-01-16T03:33:20Z")

</div>

Yes, pretty much like that.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [January 16, 2019, 6:09am UTC](https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123/4 "2019-01-16T06:09:08Z")

</div>

The try reading the apache logs using Filebeat or a file input and enrich then based on data in a relational database using the [jdbc\_streaming](https://www.elastic.co/guide/en/logstash/current/plugins-filters-jdbc_streaming.html) and/or [jdbc\_static](https://www.elastic.co/guide/en/logstash/current/plugins-filters-jdbc_static.html) filters.

---

<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:** [February 13, 2019, 6:09am UTC](https://discuss.elastic.co/t/join-multiple-input-with-different-input-types/164123/5 "2019-02-13T06:09:10Z")

</div>

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