topic Re: Creating a Metadata Db Connection using existing Context variables in Talend Studio

Creating a Metadata Db Connection using existing Context variables

chris_r_pope — Fri, 05 Jul 2013 09:11:59 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

Anonymous — Fri, 05 Jul 2013 09:22:48 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

chris_r_pope — Fri, 05 Jul 2013 09:36:54 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

Anonymous — Fri, 05 Jul 2013 10:19:19 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

alevy — Sun, 07 Jul 2013 14:13:43 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

_AnonymousUser — Thu, 02 Apr 2015 21:15:00 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

umut_gulac — Thu, 10 Nov 2016 22:25:54 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

Anonymous — Fri, 11 Nov 2016 08:16:20 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

Anonymous — Mon, 25 Mar 2019 12:09:35 GMT

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

Select the repository context required in the Contexts tab
Change or set the property type to "Built-In" in the Component tab
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.

Re: Creating a Metadata Db Connection using existing Context variables

Anonymous — Wed, 27 Mar 2019 03:12:16 GMT

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

Re: Creating a Metadata Db Connection using existing Context variables

Anonymous — Fri, 29 Mar 2019 10:57:22 GMT

Hi Sabrina

Thanks for the quick reply.

I am sticking to using repository connections for the time being whilst testing and prototyping. Once a solution moves into the product, development lifecycle I will change all connections to "built in" and substitute in the context variables.

Just a shame the repository connections have to have hard coded parameters.