topic Re: Accessing My SQL via VPN in Talend Studio

Accessing My SQL via VPN

JSey — Sat, 16 Nov 2024 03:26:06 GMT

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.

Re: Accessing My SQL via VPN

srota25 — Tue, 28 Jan 2020 20:41:55 GMT

In tDBConnection give the details of the DB server

Re: Accessing My SQL via VPN

JSey — Tue, 28 Jan 2020 20:54:15 GMT

Thanks! I'll give that a try.

Re: Accessing My SQL via VPN

vapukov — Tue, 28 Jan 2020 22:53:31 GMT

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)