Dynamic calling to oracle databases on different servers

[Anonymous]

hi ,

I have tDBInput stage and I am trying to parameterize Property type so that I can assign the repository for oracle servers.

I have defined two context groups for oracle and now need to use both as parameter in same job. Please help me out to parameterize this variable _property_ when we select property type as Repository in tDBInput component.

[Anonymous]

Hi,

     If you are using variables from two contexts in same group, then its no longer two separate contexts. You will have to create a new context where these values can be handled through two separate variables. I would say, that will be an easier method.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi
Thanks, I have two oracle server for which I have created two separate context variables. Now I need to call these context group as variable in tDBInput stage in property variable when we select property type as Repository.

I can not combine these two oracle server details in one context group, as both connections are not required one single run but only one connection is require.

Basically looking for one job/component which can take these connection details on run , instead of creating multiple jobs/ components

[Anonymous]

Hi @nthampi 

Thanks, I have two oracle server for which I have created two separate context variables. Now I need to call these context group as variable in tDBInput stage in property variable when we select property type as Repository.

I can not combine these two oracle server details in one context group, as both connections are not required one single run but only one connection is require.

Basically looking for one job component which can take these connection details on run , instead of creating multiple jobs components

[Anonymous]

Hi @nthampi 

I have two oracle server and two context group so those can not be combined in one job or component.

hence want to check if we can parameterise context group in variable _property_ when we select property type as Repository in tDBInput component.

[Anonymous]

Hi,

   Context variables are transmitted during run time. If you want to transmit them during run time, it is possible by below method.

https://community.talend.com/t5/Design-and-Development/resolved-Passing-variable-context-value-from-...

https://community.talend.com/t5/Design-and-Development/resolved-passing-context-from-command-line-to...

Now the onus of sending the right parameter fall on the calling program since context variables are getting populated during run time.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂