How to change the Oracle Connection type dynamically?

[Anonymous]

Hi Team,

We have 2 different environments like QA and PROD of Oracle. But Connections types are different one is Oracle SID and another is Oracle Service Name. How can we change drop-down value dynamically in tOracleInput while running the job in different environments? 
Is there any way with context variables? Or Do we need to create separate jobs for each environment?

Please help on this.

[Anonymous]

Hi,
Here is a component tContextLoad which  can be used to load a context from a flow. It can be used for your DB connection parameter. But not for oracle connection type.
Please take a look at the related scenario in component reference: TalendHelpCenter:tContextLoad
Best regards
Sabrina

[vapukov]

Hi Sabrina,

the question - different, but interesting
idea next - if You check suggested by You page - it very easy to change any settings for tMySQLInput, excluding:
- version of MySQL
- connection name if use existing connection

so: 
- we can create to context environment (or any other triggers parameters), and create 2 connections - 1 with Service name, second with SID. - we can simple create to flow in same Job - if environment Office1 - use connection1 and go in this direction, if environment office 2 - use other

But no any described (if possible) ways tell component tOracleInput (or any other) - take connection name from context variable
     

[Anonymous]

Hi,
So far, it is not possible to use context value in connection type or DB version.
You can use tcontextload to  load a context for your DB connection parameter(Host, port, Database...).
Best regards
Sabrina