Data Warehousing and Data integration

Connecting to MySQL via SSH (Cloudways)

More
3 years 6 months ago #22165 by Mark
In our current version, we have a job that loads data from the SQL server to my SQL external hosted DB.

My SQL provider has been changed and requires connecting as below, however, I do not see a place to enter a connection string.
Is this something that is in the new version?
Thanks

We don't know the issue with the Cloudways direct connection to the DB method. Their website documentation claims it's a method that should work, but clearly, it doesn't - both team members tried separate tests using Cloudways documentation (after whitelisting our IP addresses) and it didn't work.

www.cloudways.com/blog/connect-to-remote-mysql-database/

Both of us were able to use a different method of connecting, which is to SSH to the server first, then connect to the database locally.

Thank you

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #22166 by Peter.Jonson
Hi Mark

Thank you for the feedback
We will investigate the issue and get back to you

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #22172 by Peter.Jonson
Good news we have found a way of connecting to MySQL via SSH.
This however would require updating I lot of internal components.

We will keep you posting

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #22174 by admin
FYI We have added support for SHH connections to the database browser.
It works with MySql, MariaDB Postgres and MongoDB

Please see the screenshots

More products to follow

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save