topic Re: Access to context variables in Hierarchical Mapper (tHMap) in Talend Studio

Access to context variables in Hierarchical Mapper (tHMap)

Anonymous — Thu, 28 Jan 2016 12:11:15 GMT

I have a job with tHMap to transform data from JSON to XML. During filling XML I want to perform DatabaseLookup. So in Hierarchical Mapper view I added new Database. I filled database information with hardcoded (fixed) connection properties. And that's work - job locally is working fine.
But I want to provide in database information (connection properties) data from Context - for example host will be changing for different environments.
Is any way I could achieve such a thing?

Re: Access to context variables in Hierarchical Mapper (tHMap)

Anonymous — Wed, 17 Feb 2016 02:53:44 GMT

Hi,
From your description, it seems that you are looking for tContextLoad which can be used to load a context from a flow.
Please see the scenario in component reference:TalendHelpCenter:tContextLoad
Feel free to let us know if it is what you are looking for.
Best regards
Sabrina

Re: Access to context variables in Hierarchical Mapper (tHMap)

_AnonymousUser — Thu, 25 Feb 2016 19:18:06 GMT

Hello Sabrina,
how can I access the context variables from the mapping perspective? and why can't I upload anything to your website?
thanks
Rajani

Re: Access to context variables in Hierarchical Mapper (tHMap)

Anonymous — Tue, 01 Mar 2016 01:38:48 GMT

In the data mapper, use the function GetMapProperty under the Special folder. Drag it to where you want to use it and the type in the context variable name as "context.variable". You do not need the quotes.