topic Re: Connect a Talend Studio job to MS Sql Server DB with SSL enabled in Talend Studio

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

s_khan — Fri, 15 Nov 2024 21:26:29 GMT

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

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

Anonymous — Wed, 06 Sep 2023 07:06:24 GMT

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