Tableau Connector for Elasticsearch connecting string details

Prabhu.292 · October 13, 2020, 1:26pm

Hi Team,

By using this link : https://extensiongallery.tableau.com/connectors/180?version=2019.4&per-page=50&loginRedirected

Using this above link from the Tableau gallery I have installed the JDBC driver and it is successfully showing in the Tableau and our Elastic search is currently running in the Server.

I have only the Host name and the Port number.

But it is asking the user name and password. How to go about this?

Please check the screenshot.

Regards,

Prabhu.292 · October 14, 2020, 9:17am

Any leads on this? please

Christian_Dahlqvist · October 15, 2020, 3:37pm

It would help if you provided some additional information, e.g. which version you are running and what you configuration look like. If there are any error messages that would help too.

Prabhu.292 · October 15, 2020, 4:18pm

Elastic Search Version : 7.4.0

Elastic search JDBC driver version : x-pack-sql-jdbc-7.9.2.jar

My problem when I connect the JDBC driver ( Elasticserach by elastic) named in the Tableau desktop which is asking me to enter the Server Ip address and the port number.

Currently my Elastic search is running on my local machine.

I entered the Username and password as admin &admin.

Below is the error.

An error occurred while communicating with Elasticsearch by Elastic
Bad Connection: Tableau could not connect to the data source.
Error Code: 76E4F4AA
current license is non-compliant for [jdbc]
Connector Class: elasticsearch-jdbc, Version: 1.0.0

Regards,
Prabhu

Christian_Dahlqvist · October 15, 2020, 4:31pm

The JDBC client requires a commercial Platinum license (or a trial license). Do you have this in place?

Prabhu.292 · October 15, 2020, 4:40pm

I am using Trial version

Christian_Dahlqvist · October 15, 2020, 4:42pm

I suspect you might need to use the same Elasticsearch version as the JDBC plugin but can not find it in the support matrix.

Prabhu.292 · October 15, 2020, 4:50pm

Okay I will use install the same version 7.4.0 JDBC plugin.

By the way, May I know what is the default user name and password for the Elastic search.

I didn't configured any Authentication

Christian_Dahlqvist · October 15, 2020, 5:02pm

I do not think there is any.

Prabhu.292 · October 15, 2020, 5:08pm

Okay thanks.

I have used same veriosn 7.4.0 JDBC plugin. But not working again

FTLJ · November 8, 2020, 12:34pm

Did you input JDBC URL about keystore & truststore information in Additional Settings field?

system · December 6, 2020, 12:34pm

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