topic Re: Vertica Connections creation for SSL &Load balance enabled(Additional JDBC parameter. in Talend Studio

Vertica Connections creation for SSL &Load balance enabled(Additional JDBC parameter.

Anonymous — Sat, 16 Nov 2024 09:23:18 GMT

While creating DB connection in metadata, Talend is throwing an error and it says invalid credentials. As our Vertica DB is SSL enabled and with load balance option, i need to set up additional parameters(SSL=TRUE&ConnectionLoadBalance=TRUE) . how to set up this in Talend metadata data connection.

I have tried to give the above values in additional parameter its throwing an error. (invalid credentials) ; but same setup is working in other client tools like DBeaver/DBViz etc.

Re: Vertica Connections creation for SSL &Load balance enabled(Additional JDBC parameter.

Anonymous — Wed, 23 Aug 2017 08:43:04 GMT

Hi,

Have you tried to add additional param like encrypt=true;trustServerCertificate=true;ssl=require to see if it works?

Here is a jira issue about connecting to SQL Server via SSL

https://jira.talendforge.org/browse/TDI-31776

http://jtds.sourceforge.net/faq.html

Best regards

Sabrina

Re: Vertica Connections creation for SSL &Load balance enabled(Additional JDBC parameter.

Anonymous — Thu, 24 Aug 2017 03:21:48 GMT

Talend Studio is not generating the connection string with additional parameter values for DB type =Vertica. But it is generating the expected value for other DB type.

Please see the pic 1 For sql server ;the additional parameter value is getting added in the string connection.

From pic2, its not getting added for Vertica.