topic Re: tDBInput using tDBConnection dynamically in Talend Studio

tDBInput using tDBConnection dynamically

decimatum — Fri, 15 Nov 2024 22:36:44 GMT

Hi, I am trying to use database connections dynamically for example

I have 3 tDBConnections

In my tDBInput, I want to use a context variable to select which tDBConnection to be used.

For example, context.tDBConnection = "tDBConnection_1"

Is there a way to do so?

jzhao — Tue, 30 Aug 2022 04:36:06 GMT

Hello,

You can use the Dynamic setting in some Database components:

Regards.

decimatum — Tue, 30 Aug 2022 04:57:21 GMT

hm. I tried this. but it did not work.

for example , set context.connectionid = "tDBConnection_2" as a string. but does not work.

may i know how you set the context.connectionid?

jzhao — Tue, 30 Aug 2022 05:00:11 GMT

it's in Contexts view.

jzhao — Tue, 30 Aug 2022 05:13:53 GMT

Just recheck the generated code, when using the dynamic setting in the DB component, need to use a workaround: the dynamic setting should be set:

" + context.connectionid + "

can't set the value directly.

decimatum — Tue, 30 Aug 2022 05:18:39 GMT

Thanks! it works now. " + context.connectionid + " is the solution.