Creating a Metadata Db Connection using existing Context variables

[chris_r_pope]

Hi,
I'm trying to create a Metadata Db Connection using existing Context Variables, however there doesn't seem to be a way of linking a Context to the Db Connection without actually using the generate option on the Db Connection screen to create an entirely new one.
Has anyone found a way to do this?
I'm using 'Talend Enterprise Data Integration Cluster edition' v5.1.2.r90681
Thanks in advance

[Anonymous]

Hi,
You can refer to the scenario firstly in the component reference tContextLoad to see if it is what you needed?
Best regards
Sabrina

[chris_r_pope]

Hi Sabrina,
Thanks for the quick response.
That's not exactly what I need.
What I want to be able to do is to create a Metadata Db Connection and in Step 2 of this be able to use existing context variables to define the Database Connection (See Attached Image).
If I used the context load scenario as you have suggested I would still have to try to define the Metadata database connection as shown.
Regards
Chris

[Anonymous]

Hi,
So far, Talend cannot support for your requirement, because we cannot choose and change the context from repository.
As your screenshot shown, we just support for "Export as a context" to mask the DB information. Exporting Metadata as context
That means you have to achieve it in DB component( as the article provided to you in previous post) not repository.
Best regards
Sabrina

[alevy]

You can do it but only by editing the metadata's .item file directly...

[_AnonymousUser]

Hi
it seems possible in v5.0.0
First, create a Metadata/connection , then export it as a context
then, update your context values in the context tab
In the job, in you component, use the Property type "Referential" and select your "Connection" name
Cheers

[umut_gulac]

I have the version 6.2.1 ; but I do not have a Property type "Referential" ; where is it hidden ?

[Anonymous]

Hi,

I have the version 6.2.1 ; but I do not have a Property type "Referential" ; where is it hidden ?

Here are two types property: Built-in and Repository.
Best regards
Sabrina

[Anonymous]

Hi All

I am currently evaluating version 7.1 of the TOS for Data Integration and the situation appears not to have changed.

Am I correct in assuming that if we wish to use context variables to define (say) metadata connections then for each job we would need to 

1. Select the repository context required in the Contexts tab
2. Change or set the property type to "Built-In" in the Component tab
3. Use Ctrl-Space to select the required context variable for the component parameters

Is there a way to overcome this repetitive and error prone process? 

I note the DQ module allows switching of contexts for repository items but no such option appears to exist for Data Integration.

[Anonymous]

Hello @ColinLye 

There are two ways of applying repository context variables to a Job.

You can drop a context group onto a job, this way, the group is applied as a whole.

For more information, please refer to this documentation:TalendHelpCenter: Dropping a context group onto a Job.

Best regards

Sabrina