Connect a Talend Studio job to MS Sql Server DB with SSL enabled

[s_khan]

Good Morning All,

I hope someone can help point me in the right direction.

We have a Sql Server DB that requires SSl connections.

We are trying to figure out what we need to add to a Talend Studio job to make it possible to connect to the SSL database.

Has anyone run across this and have a recommendation? Any help will be appreciated.

Thank you very much

Sal

[Anonymous]

Hello,

Please try to use the following connection string;

jdbc:sqlserver://servername;instancename=XXXX;integratedSecurity=true;DatabaseName=XXX;sslProtocol=TLSv1.2 and add additional parameter "trustServerCertificate=true" in the tDBConnection component.

Feel free to let us know if it works.

Best regards

Sabrina