topic Re: PostgreSQL custom Connection String not saving in Talend Studio

PostgreSQL custom Connection String not saving

harryESI — Mon, 28 Jan 2019 16:03:10 GMT

Using the Talend open studio for Data Integration 7.1.1.20181026_1147

When I add a customer DB Connection String like the following. I can hit the Test Connection button and it successfully connects. I can save the connection, but once I reopen it, the Connection string reverted to the default string. Also after I save with the right connection string, I can't even get schemas..

jdbc:postgresql://SomeDBServer:5432/DBName?ssl=true&sslmode=verify-ca&sslcert=C:/Users/MyUser/Desktop/ssl/pgSQL_DBName.cert.der&sslkey=C:/Users/MyUser/Desktop/ssl/pgSQL_DBName.pk8&sslrootcert=C:/Users/MyUser/Desktop/ssl/pgSQL_DBName.ca.cert.der&sslpassword=changeit&currentSchema=SchemaName

I believe this is a bug, but is there a workaround for this to save? I can't write up an ETL job b/c of this issue. B/c when I want to pull in a table schema - I am not able to.

Re: PostgreSQL custom Connection String not saving

vapukov — Mon, 28 Jan 2019 20:17:27 GMT

Hi,

it is not a bug, it is wrong design (with the same result for us) - opposite to MySQL or MS SQL, Talend does not support "JDBC additional string" for PostgreSQL at all

as a bypass - you could define a generic JDBC connection with PostgreSQL driver and PostgreSQL mapping

Re: PostgreSQL custom Connection String not saving

harryESI — Wed, 30 Jan 2019 22:34:44 GMT

Thanks vapukov!

That worked.

For those who want a step by step:

1. Create Connection by right clicking on Metadata/DB Connections-> CreateConnection

2. Enter Name, description, purpose then click ->Next

3. For 7.1 version, select DB Type: JDBC

4. JDBC Url: enter your DB Connection String

5. Drivers: Click + to add a line. Click on the line then click on the ellipsis button (...) at the far right. That opens up a separate dialog module. Select the Platform radio button. And select your driver from the drop down. I selected PostgreSQL-42.2.5.jar and clicked OK.

6. Fill out userid and password.

7. Mapping File: Select Mapping Postgres

8. Click Test Connection.

9. Click Finish.