topic Re: Dynamic calling to oracle databases on different servers in Talend Studio

Dynamic calling to oracle databases on different servers

Anonymous — Mon, 08 Apr 2019 20:55:02 GMT

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.

Re: Dynamic calling to oracle databases on different servers

Anonymous — Tue, 09 Apr 2019 05:52:01 GMT

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 🙂

Re: Dynamic calling to oracle databases on different servers

Anonymous — Tue, 09 Apr 2019 07:28:39 GMT

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

Re: Dynamic calling to oracle databases on different servers

Anonymous — Tue, 09 Apr 2019 07:36:22 GMT

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

Re: Dynamic calling to oracle databases on different servers

Anonymous — Tue, 09 Apr 2019 14:29:20 GMT

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.

Re: Dynamic calling to oracle databases on different servers

Anonymous — Tue, 09 Apr 2019 18:43:23 GMT

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-the-command-line/td-p/66042

https://community.talend.com/t5/Design-and-Development/resolved-passing-context-from-command-line-to-sub-jobs/td-p/100501

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 🙂