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.
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
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.