topic Re: Deploy a job on remote engine which uses database on a localhost in Talend Studio

Deploy a job on remote engine which uses database on a localhost

jwilkinson1665370444 — Fri, 15 Nov 2024 22:21:14 GMT

Hi all,

I developed a job using a local version of Postgres hosted on my Mac. When I post this job to TMC, although the job runs successfully, nothing happens.

I am assuming this is because the remote engine does not know what localhost means. Is there any way to run a job which uses a database running on my local to run on remote engine.

Thanks.

Attaching the connection details of my Postgres database

Re: Deploy a job on remote engine which uses database on a localhost

Anonymous — Thu, 17 Nov 2022 03:08:47 GMT

It's impossible to use a db running on your local computer to run on the remote engine due to network issue.

It's suggested to install the db on a server vm which has the internet access.

then, You can define a job context variable (e.g. db_host) in 2 contexts: Default, Remote

and setup 'localhost' for the Default and the ip for remote like

then use the variable context.db_host for the Host in tDBConnection component

and setup the context to 'remote' while posting the job to TMC

Re: Deploy a job on remote engine which uses database on a localhost

jwilkinson1665370444 — Mon, 28 Nov 2022 05:36:27 GMT

yes, got it. Thanks for the help