How to create a dynamic job with the ETL Talend

How to create a dynamic job with the ETL Talend

This tutorial will introduce how to create a dynamic job, in fact we will create a simple job that will launch a query type “select” on a table in an Oracle database, the feature of this application is that it contain a dynamic part entered by the end user

Add an oracle input component to query a db

image

Insert a simple query

image

 

execute the job and make sure it works

 

image

 

Now we go to the most interesting part, though this job is seen in addition to being simple, is quite closed, as it will always return the same result. To remedy this problem, we will make it dynamic.

For this we must change the SQL query and replace the value ‘cli001’ of the “where” clause by the input from the end user, this entry will be recovered through the “tMsgBox” component.

Enough talk, now go to practice. We slide a component “tMsgBox” from the palette to the designer of our job.

image

Leave a Reply