passing different connections in oracle connection component

[yashwanth1]

HI Team,

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

[Anonymous]

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

[yashwanth1]

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.

[Anonymous]

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 pa...

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

Best regards

Sabrina

[yashwanth1]

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

[jlolling_kloeckner]

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.

[jlolling_kloeckner]

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

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

[Covid19]

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.

[yashwanth1]

ok Thank You

[yashwanth1]

how did you pass context group dynamically can you elaborate it