How use implicit context load using database?

[Harich]

Hi ,

I been using talend since few days i came across context variables using explicitly and loading path and values from file implicitly but im not able to do from database as implicit context. can any one please resolve it. Is there any prerequisite before using it.

[Anonymous · Accepted solution]

Hi

First of all, you should create a table in DB, the table has two fields: key and value, the stored data looks like:

key value

varName1 value1

varName2 value2

...

In the job, use a tDBInput component to query data from the table, on the schema, define two columns: key and value.

the query on tDBInput:

"select key, value from tableName"

and link tDBInput to tContextLoad:

tDBinput--main--tContextLoad

|onsubjobok

other subjob

Regards

Shong

[Harich]

Thank you it really helped me without Confusion.