Five Stars

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

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.

 

 

 

2 REPLIES
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

Vertica_Connection.PNGSQL_Server_Connctions.PNG

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.