Connect to a POSTGRES database using a .pem file (SSH Tunnel -RSA Private Key)

[SouzaManu]

I need to connect to a POSTGRESQL database that has an SSH tunnel to be authenticated!
I received the .pem file with the RSA PRIVATE KEY, however I don’t know exactly how to set this up in the “POSTGRESQL CONNECTOR” node. I saw some topics here in the forum referring to JDBC PARAMETERS, however, I was not successful!!

Tks

[ScottF]

Hi @SouzaManu and welcome to the forum.

Currently we don’t tunneling database connections through SSH, although we have a ticket for it in our system (AP-12466). I will add a +1 from you on that ticket.

[ScottF]

If anyone else has a need for this feature, there’s a topic on Feedback & Ideas that you can vote on:

Tunnel Database connection through SSH

Hi, Is there any update in the newer version of Knime to tunnel DB connections through SSH within Knime? We are currently using putty to open the SSH tunnel and would like to avoid it using with Knime. Is there a way to replicate settings similar to Standard TCP/IP over SSh settings of MySQL workbench? @ScottF : Any inputs? [image] Thanks

[SouzaManu]

Hi @ScottF

Thanks for the feedback!
Can you tell me if there are alternatives for access? Some manual model with scripts to ensure the maintenance of database access by Knime…
tks