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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.