tDBConnecion and tDBClose

Anonymous — Tue, 24 Sep 2019 13:10:43 GMT

Hey Community ,

I have a basic question , actually i run a simple project with 20 jobs . I use many TDBInput and tDBOutput in each job and it works .My question is what is the meaningful use of tDBConnection and tDBClose in a job ? If i initialize and close the connection , it will be advantagious to my jobs ?

Re: tDBConnecion and tDBClose

Anonymous — Wed, 25 Sep 2019 08:41:14 GMT

Hello,

We are supposing that you have already checked online cmponent references about:TalendHelpCenter:tDBConnection and TalendHelpCenter:tDBClose.

DB connections are a way to reuse the connectivity between database and Talend especially when the transaction need to be either committed or rollbacked in one shot. In an ideal method, if you can reuse the connection for collecting data from multiple tables (especially for lookups), then you should go for it. If you are connecting one connection for every table lookup, it is nothing but individual connection made through the component itself. It depends on your selection and please see the performance of the connections and DB queries using DB utility tools also. This will give the performance of each connection and show the corresponding performance.

Best regards

Sabrina

topic Re: tDBConnecion and tDBClose in Talend Studio

tDBConnecion and tDBClose

Re: tDBConnecion and tDBClose