Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-01-26 11:10 AM

Using SSL Database Connections with PostgreSQL

Hi there
I am currently evaluating different options in Talend DI Open Studio. I am facing difficulties in connecting to our Postgres server via SSL connection. After appending the SSL String( ?ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory ), the connection check passes successfully but it doesn't get saved and hence, I am unable to refresh the schema.
Could you please advise, if there is a solution to this?
Thanks
Manmeet
0683p000009MCfs.png 0683p000009MD7Q.png 0683p000009MD7V.png
Labels (2)
Labels
507 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2016-01-26 01:36 PM
Author

Hi,
The PostgreSQL connection in Talend doesn't give the option to pass additional parameters within the wizard. Please try a "General JDBC" database connection which allows you to pass additional parameters.
See TDI-5061 to vote for this feature request.
Also, take a look at this thread on the AWS forums.
507 Views
0 Likes
Anonymous
Not applicable
‎2016-01-26 04:41 PM
Author

Still a missing feature since 2012! I have voted for it but have not that much hope to get it soon. Talend is currently mostly focused on the Big Data stack.
507 Views
0 Likes
Anonymous
Not applicable
‎2018-07-02 05:24 PM
Author

Hi All,

 

I am facing difficulties in connecting to Postgres server via SSL connection.Could any one help me.

 


Capture.PNG
507 Views
0 Likes