# Tableau Connector with Elastic JDBC driver

**URL:** <https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344>\
**Category:** Elasticsearch\
**Created:** [September 11, 2020, 2:31pm UTC](https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344 "2020-09-11T14:31:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![otorih](https://avatars.discourse-cdn.com/v4/letter/o/c68b51/32.png) [@otorih](https://discuss.elastic.co/u/otorih)\
**Post date:** [September 11, 2020, 2:31pm UTC](https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344/1 "2020-09-11T14:31:26Z")

</div>

Hello,

I couldn't find any satisfying solution on google and after double-checking that this hasn't already been answered here, I decided to write that post to seek for some help.

I am currently trying to connect Tableau to ElasticSearch, so that I can analyze data and create a dashboard in an efficient manner.

Software version :

- Tableau 2020.3
- ElasticSearch 7.9.0

I came across that recent post ( 27th August 2020) from the tableau blog, showcasing the new extension gallery where the ElasticSearch connector can be found.

> **[Additional Tableau Connectors now available through the Extension Gallery](https://www.tableau.com/about/blog/2020/8/additional-tableau-connectors-now-available-through-extension-gallery)**
>
> Tableau now offers partner-built data connectors through the Extension Gallery. Learn more about these new connector extensions and the Tableau Developer program.

Description:  
"_The Tableau Connector works in tandem with the Elastic JDBC driver to facilitate the query of Elasticsearch. It gives users a simple way to query Elasticsearch data from Tableau. After providing basic connection and authentication information, users can easily select Elasticsearch indices for use in Tableau Desktop and Tableau Server_"

Using this connector seems much simpler and cleaner than the previous solution suggested years ago: [https://github.com/mradamlacey/elasticsearch-tableau-connector](https://github.com/mradamlacey/elasticsearch-tableau-connector).

Installation was indeed really easy, with a clear explanation of each step.

Once I have established the SSH tunnel between my laptop and the VM where ElasticSearch server is hosted, I launch Tableau and select the connector "ElasticSearch by Elastic JDBC connector"

 ![Step 1 - Selecting the connector](https://us1.discourse-cdn.com/elastic/original/3X/f/6/f61e09a89e3e586c04f937fed17166b772fc03e2.png)

I then fill the requested areas, the server address being the localhost address I would use to check ES on my browser (the port being the listening post used for the SSH tunnel)

 ![Step 2- filling the requested areas](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3afcf0404813d4c55371a1bdaecdd6bac4bf9b57.png)

If the connection between ES and Tableau works (or at least seems to), I can't see any of the data or table I should be seeing.

 ![Step 3 - connection established but no data to query](https://us1.discourse-cdn.com/elastic/original/3X/2/d/2d9153e83edf723510e3904d4526ab18adb3c5da.png)

Is there anything I am missing or doing wrong?

We found an "alternative" by using the connector between Tableau and Google's BigQuery (which worked without any issue, all the relevant data and table being visible). However, we really would like to connect ES directly to Tableau, for ease of use.

If any member participating in the development of that connector could give me a few pieces of advice, it would be greatly appreciated!  
Thanks for your help.

---

<div class="post-metadata">

**Author:** ![bogdan.pintea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bogdan.pintea/32/45740_2.png) [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)\
**Post date:** [September 14, 2020, 4:28pm UTC](https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344/2 "2020-09-14T16:28:54Z")

</div>

There's nothing special about tunnelling the connection so that should work.  
I assume the log-in user has the right permissions to access indices on your cluster?  
Might be worth checking Tableau's logs for anything relevant: `%userprofile%\Documents\My Tableau Repository\Logs` on a Windows OS.

---

<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:** [October 12, 2020, 4:28pm UTC](https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344/3 "2020-10-12T16:28:57Z")

</div>

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