topic Re: Use more than one context on a job in Talend Studio

Use more than one context on a job

rahma123 — Mon, 22 Oct 2018 11:07:53 GMT

Hello,

I have 2 components TOracleInput and TOracleOutput from 2 different databases. So, i create a context group with 2 contexts one for the source and the second for the destination.

Here, when i execute the job, it takes always the default context

I create an other group of context which contain the destination but i can't use 2 groups of context on the same job

How can i resolve this problem ?

Your help please

Re: Use more than one context on a job

Anonymous — Mon, 22 Oct 2018 11:15:55 GMT

Contexts are environment specific (Prod, DEV, TEST, etc). As such a context is set for the whole job. You have Contexts, Context Groups and Context Variables. You want to set up a Context Group for your source and target, and add Context Variables to these. Then use your Source Context Variables for your source and your Target Context Variables for your target.

Re: Use more than one context on a job

rahma123 — Mon, 22 Oct 2018 11:34:34 GMT

Yes. I wil give you more details.

I created a context group: GRH_CONTEXT which contains 2 contexts whith same variables and different values

After i create two connections:

* SERVER_CNX : source connection

* ODS_CNX: target connection

Here it takes always the default context

Re: Use more than one context on a job

Anonymous — Mon, 22 Oct 2018 11:46:40 GMT

You've created two Contexts, not two Context Groups. This is not how Contexts work. For the moment, forget Context Groups (they are just methods for grouping Context Variables), you need to create Context Variables for both connections.

I'll give you a scenario why this works. Your environment has a source and target database, correct? Is that your only environment or your development environment? Is it replicated in a Test environment and also in a Production environment? If so, you would need 3 Contexts (Dev, Test, Prod). Then you can set values for your Source and Target databases for each of those environments.

Re: Use more than one context on a job

rahma123 — Mon, 22 Oct 2018 12:13:21 GMT

Okay

Thank you very much

It works now