# Directly Connecting MySQL DB to Kibana for visualization

**URL:** <https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982>\
**Category:** Kibana\
**Created:** [July 6, 2020, 9:47am UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982 "2020-07-06T09:47:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karan\_Gupta10](https://avatars.discourse-cdn.com/v4/letter/k/b19c9b/32.png) [@Karan\_Gupta10](https://discuss.elastic.co/u/Karan_Gupta10)\
**Post date:** [July 6, 2020, 9:47am UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982/1 "2020-07-06T09:47:39Z")

</div>

Hi  
My current problem statement involves connecting to MySQL DB to fetch the data and produce Datavisualization in Kibana.

Is there a way to directly connect with MySQL DB from Kibana.

If not, then what are the other alternatives.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 6, 2020, 10:08am UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982/2 "2020-07-06T10:08:59Z")

</div>

No. You need first to index the data in elasticsearch.

You can use Logstash for this but if you want real time data, have a look at: [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.

Have also a look at this ["live coding" recording](https://www.elastic.co/fr/blog/how-to-add-powerful-search-existing-sql-applications-elasticsearch-video-tutorial).

---

<div class="post-metadata">

**Author:** ![Karan\_Gupta10](https://avatars.discourse-cdn.com/v4/letter/k/b19c9b/32.png) [@Karan\_Gupta10](https://discuss.elastic.co/u/Karan_Gupta10)\
**Post date:** [July 6, 2020, 10:29am UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982/3 "2020-07-06T10:29:38Z")

</div>

Hi David ,  
Thanks a lot for the quick response.  
I need to know how do be create a Logstash pipleine in the Elastic Cloud version.

Any help in this regard will be much appreciated.

Regards.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 6, 2020, 12:13pm UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982/4 "2020-07-06T12:13:15Z")

</div>

You can't. Logstash needs to run on its own machine.

---

<div class="post-metadata">

**Author:** ![Neha\_Wagholikar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neha_wagholikar/32/68416_2.png) [@Neha\_Wagholikar](https://discuss.elastic.co/u/Neha_Wagholikar)\
**Post date:** [July 6, 2020, 2:34pm UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982/5 "2020-07-06T14:34:30Z")

</div>

Hi,

You can try by using logstash configuration file to add input as jdbc and you can see that index in kibana and visualize it.

Example :  
input  
{  
jdbc  
{  
type =\> "sqljdbc"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://{{mssqlDnsURL}}:6201;database={{dbName}}"  
jdbc\_driver\_library =\> "/usr/bin/{{mssqlJdbcJar}}"  
jdbc\_user =\> "{{mssqlUser}}"  
jdbc\_password =\> "${MSQL\_PWD}"  
schedule =\> "\* \* \* \* \*"  
jdbc\_validate\_connection =\> true  
tags =\> ['sqljdbc']  
statement =\> "Select \* from DBAsAudit.dbo.dbaStoredAuditedEvents"  
}  
}  
filter{}  
output  
{  
if [type] == "sqljdbc"  
{  
elasticsearch {  
hosts =\> ["https://{{elasticsearchUrl}}:9200"]  
index =\> "paas-{{mssqlResourceGroupName}}-%{+YYYY.MM.dd}"  
}  
}  
}

---

<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:** [August 3, 2020, 2:34pm UTC](https://discuss.elastic.co/t/directly-connecting-mysql-db-to-kibana-for-visualization/239982/6 "2020-08-03T14:34:36Z")

</div>

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