Connect to remote host with SSH

I'm not sure if this is helpful but FME has a SystemCaller transformer which lets you run commands from the Command Line. You might indeed be able to use a python caller. If you can have a python script perform the same process outside of FME then you should be able to stick the code it inside of FME. Take advantage of the FeatureReader to read in the results of the external process if you want to bring the data back into FME. A good example of using an external tool to process data can be seen inside the LASTools custom transformers. This doesn't involve SSH to a remote server but might give you help on the other parts of the problem.

This can certainly be done using sshtunnel or asyncssh libraries. To get these to work you may need to temporarily modify the Python sys.path to allow you to use the updated version of cryptography that what FME has by default. If you stash the list before you change it, you can restore it after the PythonCaller finishes. If you are running remote bash commands, probably best to keep it all in the one PythonCaller too.

Hi,

In the same topic, this idea talk about ssh connexion for database : https://community.safe.com/s/bridea/a0rDm000000D9J0IAK/write-to-remote-mysql-database-through-ssh

I've added a comment to include all kind of database, not just MySQL.

You can vote for this idea if you want.