You can translate the question and the replies:

VDP SSL connection with Talend

Hi Team, We are trying to extract the data from denodo views using Talend. While we are creating the a connection in Talend , we are getting the below error. Our VDP server is SSL enabled. We are able to connect from my machine and machine is enable with SSL to VDP server. Error -- connection error:Cannot trust the server to establish a SSL connection -- configuration in Talend jdbc:vdb://10.82.5.207:9999/admin?ssl=true; Driver:denodo-vdp-jdbcdriver.jar Driver class name :com.denodo.vdp.jdbc.Driver Please help us
user
25-02-2020 10:07:18 -0500

1 Answer

Hi, The error *“Cannot trust the server to establish a SSL connection”* means that you have enabled SSL in the VDP Server, but haven’t imported the certificate file(public key) into the truststore of the external client, in your case, Talend. I believe the steps mentioned below would help in rectifying the error: * Make sure SSL is enabled for external clients by setting the property ‘javax.net.ssl.trustStore’ to point to the truststore of the Denodo server. For detailed information, You may refer to [Enabling SSL/TLS for External Clients](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/enabling_ssl_for_external_clients) under the Post-installation tasks section of the Denodo Platform Installation Guide. * You have to import the public key file into the truststore of the external client(Talend). For detailed information, You may refer to [Obtaining and Installing an SSL/TLS Certificate](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/obtaining_and_installing_an_ssl_certificate) under the Post-installation tasks section of the Denodo Platform Installation Guide. Hope this helps!
Denodo Team
26-02-2020 07:39:43 -0500
You must sign in to add an answer. If you do not have an account, you can register here