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.

Talend Date Functions

Here are some Talend useful functions...

1. TalendDate.getPartOfDate("DAY_OF_MONTH","2015-12-29");
Output: 29
Note: input date shuld be in date datatype.

2. TalendDate.getLastDayOfMonth("2015-12-13");
Output: 2015-12-31

3.TalendDate.getFirstDayOfMonth("2015-12-13");
Output: 2015-12-01

4. TalendDate.getCurrentDate();
Output: return current date in date datatype.

5. TalendDate.parseDate("yyyy-MM-dd HH:mm:ss","2015-12-23 15:12:11");
Output: Wed Dec 23 15:12:11 IST 2015 (in date datatype).

Talend IO Disc Space Error with mysql input

While working with huge data set we may face disc space error.

By enabling stream we can fix this error. See the below image for details.

Use of tHashOutput and tHashInput in Talend

These components can be used of temporary data storage like tBufferOutput and tBufferInput.

But tHashOutput and tHashInput are much faster than like tBufferOutput and tBufferInput.

tHashOutput and tHashInput not comes by defult in component list, you have to update settings

in order to activate them.

Following are the steps to activate them-

Click on Technical Folder icon and than click on right arrow icon.
Now its activated and you can use it in you jobs.