Accessing My SQL via VPN

[JSey]

Hi

I'm building an integration script, and the source is a My SQL database that is off-site.  Currently, there is no external access and we can only access it via VPN.  How can Talend access the db?  Thank you for your help.

[srota25]

In tDBConnection give the details of the DB server

[JSey]

Thanks!  I'll give that a try.

[vapukov]

Hi,

if Talend and database server located in different networks with VPN access, there is no direct settings to establish VPN connection on-the-fly 

Talend expects VPN connection Up and Live before the job starts.

but depending on your VPN client you can use tSystem component to establish a VPN connection by executing bash/PowerShell/cmd script at the begin section fo your job.

as an example - https://superuser.com/questions/1098652/connect-to-a-vpn-using-command-line 

P.S.

the same true and for ssh tunneling (when your database listen only localhost)