https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345075#M112650 Jeremie,<BR /><BR />just using the tMySQL connection does not open the one. You have to also use say tMySQLInput for it to happen.<BR /><BR />Thomas Fri, 26 Feb 2016 08:07:59 GMT Anonymous 2016-02-26T08:07:59Z https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345074#M112649 <P>Hi,</P> <P align="left">Currently we wish to execute jobs in the Talend Cloud.<BR />Our data DB MySql are on another space and the DB is not secure ( only use our private cloud Amazon) .<BR />The solution was to place a Amazon ELB to IP redirection not secure DB to outer IP SSL.<BR />Certificates are operational and the only external IP is available from the IP office.<BR />All are validate by DevOps.<BR /><BR />We used the component Talend to conduct local testing ( IP Office ) before white list other external IP .<BR /><BR />tSetKeyStore uses local TrustStore and KeyStore with the password .<BR />tMysqlConnection points to the external IP ( <A href="http://mysql-ssl.mydomain.com" target="_blank" rel="noopener nofollow noopener noreferrer">mysql-ssl.mydomain.com</A> ) and port 43306 Secure .<BR />We have added the additional parameters UseSSL = true &amp; noDatetimeStringSync = true.<BR /><BR />Despite all this we do not have to connect to the DB .<BR /><BR /><BR />Regards<BR />Jeremie<BR /><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH8o.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147827iCBDCB922F5764310/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH8o.png" alt="0683p000009MH8o.png" /></span></P> Thu, 25 Feb 2016 22:33:47 GMT https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345074#M112649 Anonymous 2016-02-25T22:33:47Z https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345075#M112650 Jeremie,<BR /><BR />just using the tMySQL connection does not open the one. You have to also use say tMySQLInput for it to happen.<BR /><BR />Thomas Fri, 26 Feb 2016 08:07:59 GMT https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345075#M112650 Anonymous 2016-02-26T08:07:59Z https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345076#M112651 Thanks Thomas,<BR />but if the tMySQL connection failed, the related tMySQLInput can't be run.<BR />Regards<BR />Jeremie Fri, 26 Feb 2016 20:21:34 GMT https://community.qlik.com/t5/Talend-Studio/SSL-with-tSetKeyStore-to-DB-no-secure/m-p/2345076#M112651 Anonymous 2016-02-26T20:21:34Z