I am able to write to a local MySQL database, but I would like to write to a remote MySQL database through an ssh connection. I don't see that the Add Database Connection interface allows this. Is there a way to do this?
Open
Support database connections over SSH
+5
+18- Contributor
@asadamjad Could you rewrite the title of your idea to include all type of database ?
For example : "Support database connexion over SSH"
Thank you really much
FME must support connexion over ssh for all database connexion. It's really common to use this kind of security even if the performance are a little bit worst...
We have many customers' PostgreSQL instances that require a connexion over SSH and this function could be really helpfull.
it can be resolved using a SSH tunnel from your local machine to the server. For doing that, you can use the following command line on cmd:
ssh -i dev_key -L 5432:localhost:5432 username@ServerIP -N
+18- Contributor
Hi,
Thanks for your answer !
Unfortunetly, not in my case, I need tu create the ssh tunnel inside the fme process not outside because some workspaces are run as planned tasks (or cronjob).
Creating a ssh tunnel on the machine implies scripting thing outside the workspace and is not really easy to handle.
You can use the systemcaller transformer to stay inside the workspace but the ssh tunnel will be open for every programm on the machine which can result in security breach.
In fact there is some workarround but all of them are complicated or causes security threats :-(