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?
Question
Write to remote MySQL database through ssh
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+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
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.
+18- 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.