# SQL and elasticsearch

**URL:** <https://discuss.elastic.co/t/sql-and-elasticsearch/124886>\
**Category:** Logstash\
**Created:** [March 21, 2018, 1:55am UTC](https://discuss.elastic.co/t/sql-and-elasticsearch/124886 "2018-03-21T01:55:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kanthimathi](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@kanthimathi](https://discuss.elastic.co/u/kanthimathi)\
**Post date:** [March 21, 2018, 1:55am UTC](https://discuss.elastic.co/t/sql-and-elasticsearch/124886/1 "2018-03-21T01:55:20Z")

</div>

Hi all,

Planning to find out the possibilities of implementing elastic search to connect with databases and use kibana as a visualization tool. As we already use elastic search for logging I am aware of the visualizations available and the deployment options available. For this purpose, we used filebeat and metricbeat.

Our requirement is to create dashboards from databases such as SQL, MongoDB, S3, REST API and stripe. I did check the input plugin available in the logstash and made sure the options available. Now I would like to know few things.

1. When we use logstash to ship SQL into ES and use kibana for visualization, will it work same as what we did for logging?

2. how will the data be indexed? i.e. When there are tables in SQL how will it appear in ES? I went through few post and found that there is no JOIN option available if that is the case how can we merge them?

3. Is there any option to connect mongoDB with elasticsearch?

Thanks,  
Kanthi.

---

<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:** [March 21, 2018, 8:54pm UTC](https://discuss.elastic.co/t/sql-and-elasticsearch/124886/2 "2018-03-21T20:54:05Z")

</div>

> When we use logstash to ship SQL into ES and use kibana for visualization, will it work same as what we did for logging?

Probably yes, but I'm not sure what you're getting at.

> how will the data be indexed? i.e. When there are tables in SQL how will it appear in ES? I went through few post and found that there is no JOIN option available if that is the case how can we merge them?

It depends. There's no single true way of transferring normalized relational data to denormalized documents in Elasticsearch.

---

<div class="post-metadata">

**Author:** ![kanthimathi](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@kanthimathi](https://discuss.elastic.co/u/kanthimathi)\
**Post date:** [March 21, 2018, 8:57pm UTC](https://discuss.elastic.co/t/sql-and-elasticsearch/124886/3 "2018-03-21T20:57:33Z")

</div>

Thanks for your reply @magnusbaeck 🙂

We would like to try kibana instead of other BI tool we currently use. Would like to know how it works and the possibilities of that

---

<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:** [April 18, 2018, 8:58pm UTC](https://discuss.elastic.co/t/sql-and-elasticsearch/124886/4 "2018-04-18T20:58:08Z")

</div>

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