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 : https://opendistro.github.io/for-elasticsearch/downloads.html
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