Hi, I am able to establish an ssh connection to my remote host using the SSH connector node. However, when I configure the Database Reader node to connect to the database on the remote host and attempt to execute the node, the reader cannot establish a connection as it does not accept the output from the SSH connector node, and there does not seem to be a way to configure SSH within the Database Reader node. I'm sure there must be a simple way to do this. Assistance is much appreciated. Thanks.
I guess you want to tunnel your database connection through SSH? This isn't possible inside KNIME because the SSH Connector does not establish a permanent connection. You have to open the SSH connection outside KNIME and configure the port forwarding accordingly (something the SSH Connector cannot do and never will).
1 Like
Yes, port forwarding worked for me - thanks very much for your response