Hey Friends! First time deploying a job to Talend Cloud to run in a remote engine, inside our network. The server it's executing on - is confirmed to have all appropriate ports & connectivity to the source & destination servers.
We've established connections, they work individually.
The job is defined with tDBConnection or tMSSQLConnection components using context.connection_SQLEDW_database etc.
I've tried with & without passing entire context - and keep running into the same error "The syntax of the connection URL 'jdbc:jtds:sqlserver://;appName=BI_TALEND_REPOSITORY;' is invalid."
It's like the "subjobs" in the tRunJob component don't know what connection to use once they're in the cloud.
How do you solve this?
the first tRunJob runs a subjob - that has four tRunJobs within it. Each of those four have the context variables for the cloud connections specified.
The job runs fine within the Talend Cloud application on our development server.
The root job must have (in the contexte view) have all context variables used in the child jobs who could change depending of the environnement / config in the TMC
The tRunJob must have the "Transmit whole context" enabled
With this configuration, if the network and the values transmit in context are OK, it should work
The root job must have (in the contexte view) have all context variables used in the child jobs who could change depending of the environnement / config in the TMC
The tRunJob must have the "Transmit whole context" enabled
With this configuration, if the network and the values transmit in context are OK, it should work
