topic Re: How to change the Oracle Connection type dynamically? in Talend Studio

How to change the Oracle Connection type dynamically?

Anonymous — Sat, 16 Nov 2024 10:14:20 GMT

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.

Re: How to change the Oracle Connection type dynamically?

Anonymous — Wed, 23 Nov 2016 03:29:57 GMT

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

Re: How to change the Oracle Connection type dynamically?

vapukov — Wed, 23 Nov 2016 04:22:17 GMT

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

Re: How to change the Oracle Connection type dynamically?

Anonymous — Wed, 23 Nov 2016 08:50:26 GMT

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