topic Re: Use of Implicit tContextLoad in Talend Studio

Use of Implicit tContextLoad

terceroulloa — Tue, 21 Jun 2016 20:26:55 GMT

To load a context I used tFileInputDelimited and tContextLoad.
It also worked using "Implicit tContextLoad from file".
But can't make it work using a database as a source. Tried both ways, tContextLoad and Implicit tContextLoad.
Using Implicit tContextLoad, I have two problems:
- How do I fill Query condition field? Is it obligatory?
- In the components that use this context, is it ok (Port field as example): context.port?
My database is like:
"key" "value"
"database" "dbname"
"host" "hostname"
"password" "password+"
"port" "3306"
"username" "root"
Thanks, Rober

Re: Use of Implicit tContextLoad

Anonymous — Wed, 22 Jun 2016 03:29:22 GMT

Hi
You can load the value of context variables from any data source. From database, the query should be:
"select key, value from your_table_name"
The job looks like:
tMysqlInput--main--tContextLoad
|
onsubjobok
|
other business processing
Regards
Shong

Re: Use of Implicit tContextLoad

terceroulloa — Wed, 22 Jun 2016 13:49:16 GMT

Ok, thanks.
But in the Contexts Tab I have a filename (File type) field, which worked when using a file. Leaving it like this works, but should I remove that value? Or change it?
Rober