Tableau Connector for Elasticsearch JDBC

Plugins SQL
1

Hi Team,

I am trying to connect Elastic search in Tableau by using your “Open Distro elastic search JDBC driver”

I have given the steps which I used for JDBC driver.

Step 1 : Installed the Java Java\jdk-15 - 64 bit version

Step 2 : Downloaded the Elastic search windows installer.exe from the your portal link : Redirecting to /for-elasticsearch/

Step 3 : Place the opendistro-sql-jdbc-x.x.x.x.jar in the C:\Program Files\Tableau\Drivers

Step 4 : Created the tdc file and Name the file elasticsearch.tdc and save it to My Tableau Repository\Datasources

Step 5 : Have opened the Tableau and clicked the JDBC connection entered the URL as “jdbc:elasticsearch://localhost:9200”

Step 6 : And Select the Dialect as MySQL from the drop-down list

Step 7 : not entered the user name and pasword as it is currently running in the local host. We dont have any credentials.

Step 7 : Clicked the sign in

Got the below error.

An error occurred while communicating with Other Databases (JDBC)
The Other Databases (JDBC) connector requires Java. Please install Java version 8.
Error Code: 37CE01A3

Please help me to fix the issue

image
image622×699 13.9 KB

Regards,
Prabhu

2

Hi Team,

I have fixed the error now (Installed the JDBC driver 8 version .

But now not seeing any data here in the Tableau.

image
image1255×577 22.2 KB

3

I can get the list of fields but no luck to load the data in worksheet.

4

Hi, were you able to resolve this? I’m facing the exact problem.