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

[jwilkinson1665370444]

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

[Anonymous]

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

[jwilkinson1665370444]

yes, got it. Thanks for the help