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?
+11- Safer
Hi @nsadowy,
I can't say I'm an expert in this topic, but I did notice some discussion in the past about it from these Q&A questions here:
- Is it possible to connect to SQL Server database over SSH using FME
- Connect to remote host with SSH
- Deploy FME Server to Azure
Some of these are more relevant to Azure SQL Server so perhaps not quite what you're looking for, but some of the answers lead to some other resources as well. Please take a look and let me know if you have any further questions, and I'd be happy to try and find out more on it if you do!
Thanks. I found most of those articles through my own searches. I just ended up setting up a firewall rule w/ IP addresses. Not my preference. Not as secure, but functional. Disappointed that they didn't think of this when they created that writer.
+11- Safer
nsadowy wrote:
Thanks. I found most of those articles through my own searches. I just ended up setting up a firewall rule w/ IP addresses. Not my preference. Not as secure, but functional. Disappointed that they didn't think of this when they created that writer.
+14- Contributor
Hi @nsadowy and @jovitaatsafe ,
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.