topic passing different connections in oracle connection component in Talend Studio

passing different connections in oracle connection component

yashwanth1 — Fri, 15 Nov 2024 22:47:39 GMT

HI Team,

Can you tell me how can i pass multiple connection parameters in oracle connection component.

Re: passing different connections in oracle connection component

Anonymous — Sat, 25 Jun 2022 00:34:42 GMT

You'll need to give a bit more information for this. What is it you are trying to achieve?

Re: passing different connections in oracle connection component

yashwanth1 — Mon, 27 Jun 2022 08:22:59 GMT

I need to pass 2 hosts in the same connection component.

it has to be that if one fails connecting ,it should go for another host.

Re: passing different connections in oracle connection component

Anonymous — Tue, 28 Jun 2022 05:18:46 GMT

Hello,

We would assume that you want to have 2 DBs and one will be the primary and one will be the secondary for fail over purposes? It seems Oracle(RAC) provide some Backup, Failover solution available with their DB licensing.

With talend solution, we are able to use using different context group for different environments Via Context Variable.

Here is a scenario about: TalendHelpCenter: Reading data from different MySQL databases using dynamically loaded connection parameters

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

Re: passing different connections in oracle connection component

yashwanth1 — Tue, 28 Jun 2022 07:17:19 GMT

so there is no option in talend to pass two hosts in the connection component if either one fails.

Re: passing different connections in oracle connection component

jlolling_kloeckner — Tue, 28 Jun 2022 07:55:46 GMT

It is possible. You nned to setup context variables for the comnnection and before using the component you setup these variables.

One way to do that is using tContextLoad.

Re: passing different connections in oracle connection component

jlolling_kloeckner — Tue, 28 Jun 2022 07:57:30 GMT

You can deal with a failed connection attempt with the trigger OnComponentError.

Actually the better way is using a load balancer for Oracle.

Re: passing different connections in oracle connection component

InfoCraft — Tue, 28 Jun 2022 14:43:12 GMT

Hi @yash wanth,

You can reset the context variables according to the component ok/ko

((String)globalMap.get("tDBConnection_1_ERROR_MESSAGE")) ==null?connection_1:connection2

Kind regards,

😷19.

Re: passing different connections in oracle connection component

yashwanth1 — Wed, 29 Jun 2022 06:44:06 GMT

ok Thank You

Re: passing different connections in oracle connection component

yashwanth1 — Thu, 30 Jun 2022 10:28:35 GMT

how did you pass context group dynamically can you elaborate it

Re: passing different connections in oracle connection component

InfoCraft — Mon, 11 Jul 2022 08:44:32 GMT

Hi @yash wanth,

Please find all the details here.

Kind regards,

😷19.