I setup a connection to elasticsearch and configure it to ignore server certificate verification by checking:"Trust any SSL certificate". The test connection gives me a positive result so my connection is working. But when i create a dataset based on the this connection it fails with this message:
Failed to connect: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
It looks to me that the connection now tries to use certificate verification although i did not configured that !!!!!
Thank you for reporting this, there is a bug that shows this message on the "New Elasticsearch Dataset" for external datasets until you've filled the index name & type name parameters and click Retry. I will see that it is fixed in a future DSS version.
In the meantime, you can workaround this problem by filling the 2 parameters, or by adding the certificate to the java truststore.