Hello, what you're going to want to do is configure the metadata to connect to your test environment, from there you press the "Export as context" button to convert the connection parameters into context variables for the metadata values. See the attached screen shots for what this will look like.
Hi kleinmat - after converting your DB connections to contexts or a context group, your new contexts are stored in the Talend repository. Next, you use the contexts on your DB input and output drums... To do this, you'd type those values in your DB properties (see screenshot - property set to built-in).
For your port in particular, make sure the data type of the context.port variable is integer...
Hi kleinmat. No it will work. But if you drag and drop your connection to a job I guess you will not get automatically the context var group also added to you job, this must be done manually - but that is not a big deal.