topic Re: How can I make a job parametric? in Talend Studio

How can I make a job parametric?

Baris1601965481 — Tue, 06 Oct 2020 06:41:41 GMT

Hi,

I am new in Talend.

I want to give date parameter to job.

I want to use like this.

select * from SOURCE_TABLE_1

where DATE > $PARAMETER

It will be the same job but ıt will run after the selected date.

Thank you.

Re: How can I make a job parametric?

manodwhb — Tue, 06 Oct 2020 11:20:16 GMT

@Barış Emeli , you can use the context variable concept and please check the below link.

https://help.talend.com/reader/U5lNkhUnaW6RdpL8qxP61w/d0QVvShdlGcIqowdsla3lw

Thanks,

Manohar

Re: How can I make a job parametric?

DataTeam1 — Wed, 07 Oct 2020 18:50:53 GMT

@Barış Emeli you can use context as @Manohar B mentioned and in the query you can use it like here:

"select * from SOURCE_TABLE_1

where DATE > " + context.DATE_PARAMETER

but it is very important to understand that you have to prepare the date in format which will be understandable for your database so the best way is to have context.DATE_PARAMETER set as string (not as date) and in the query you should convert it to date in proper way (depend on database requirement).

For example if you use Oracle and you want to use date as string "2020-10-07" you should use:

"select * from SOURCE_TABLE_1

where DATE > TO_DATE(" + context.DATE_PARAMETER + ", 'YYYY-MM-DD')"

Re: How can I make a job parametric?

Baris1601965481 — Thu, 08 Oct 2020 06:04:26 GMT

Thank you for your warning. We use Oracle. I will consider your suggestion.