How to enable HTTPS connection from Jaspersoft® ETL Studio

Issue:

When specifying a https connection url in Jaspersoft® ETL Studio, we are unable to successfully make the connection.

What are the steps that are required to enable HTTPS connection in ETL Studio ?

Solution:

1> Download the rootca certificate (eg. Digicert.crt) from the server to the Studio client windows machine

2> Copy the rootca certificate to %JAVA_HOME%\jre\lib\security

3> Import the rootca certificate into the java truststore by running keytool :

keytool -import -trustcacerts -alias root -file Digicert.crt -keystore cacerts

4> Edit the Studio_home/JETL-win-x86_64.ini file and add the following Java flags:
-Djavax.net.ssl.trustStore=<complete path to truststore file cacerts>
-Djavax.net.ssl.trustStorePassword=changeit

5> Restart Studio and test the HTTPS connection

Additional Notes:

Should the following SSL error occur upon testing the connection  :

sun.security.validator.ValidatorException: PKIX path building failed: 
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Then refer to the following article for solution:

How to solve PKIX error when Studio connects to Talend Cloud:

https://community.talend.com/s/article/How-to-solve-PKIX-error-when-Studio-connects-to-Talend-Cloud-Lw4Aw?language=en_US

If further SSL debugging is required, the following article describes steps to collect debug traces for Studio connection:

How to collect debug traces for Studio connection to Talend Cloud SSL:

https://community.talend.com/s/article/How-to-collect-debug-traces-for-Studio-connection-to-Talend-Cloud-SSL-d1n43