I am trying to connect Elastic search data with Tableau by using Dremio tool.
Step 1 :I have successful installed the Dremio connector on my system.
Step 2 : when I am trying to do DNS configuration facing the following error as mentioned in the screenshot.
Please help me to fix the issue. Our Elastic search data currently in Local host.
FAILED!
[Dremio][Connector] (20) Failure occurred while trying to connect to local=localhost:9200. (Details: [30004]Connection failed with error: Cannot decode handshake.)
You have to first connect to Dremio, so in the driver settings, instead of 9200, try 31010 (Default ODBC port) and once you are inside Tableau, you can query all the data sources added to Dremio
Have you configured SSL for the JDBC/ODBC server on Dremio? If so, then yes you would have to change the SSL options to enable encryption and point to your trust store.
Also, have you tried with “Authentication Type = Plain” and entering your credentials?
As suggested, I have changed the port from 9200 to 31010 but getting the following error.
FAILED!
[Dremio][Connector] (20) Failure occurred while trying to connect to local=localhost:31010. (Details: [30001]Connection failure. Host:localhost port:31010. Error: No connection could be made because the target machine actively refused it.)
[Dremio][Connector] (20) Failure occurred while trying to connect to local=localhost:31010. (Details: [30001]Connection failure. Host:localhost port:31010. Error: No connection could be made because the target machine actively refused it.)
