Sharing database connection in Talend

Hi all,

Many times we work with multiple job and using same database table with many connections.

So here what I am going to tell you, how you can use db connection in many jobs.

Let say I have 5 jobs namely job0, job1, job2, job3 and job4.

In the below picture you can see a connection and 4 jobs, I am passing job0 connection into other jobs.

so in above picture we are making connection that will be share in other jobs. to do so just tick on checkbox use or register shared DB connection. this is job 0.

So now in above picture we just put connection component and use already created connection (in job0). we will do the same for job1,job2,job3 and job4 in order to use shared connection.