https://community.qlik.com/t5/Talend-Studio/tOracleInput-vs-tOracleConenction/m-p/2258701#M40417 <P>I need to connect to database. So should I use tOracleConnection for making the DB connection or I should use the tOracleInput. Does the tOracleInput close the DB connection automatically after the job is completed?</P> Wed, 07 Jun 2017 05:07:27 GMT Anonymous 2017-06-07T05:07:27Z https://community.qlik.com/t5/Talend-Studio/tOracleInput-vs-tOracleConenction/m-p/2258701#M40417 <P>I need to connect to database. So should I use tOracleConnection for making the DB connection or I should use the tOracleInput. Does the tOracleInput close the DB connection automatically after the job is completed?</P> Wed, 07 Jun 2017 05:07:27 GMT https://community.qlik.com/t5/Talend-Studio/tOracleInput-vs-tOracleConenction/m-p/2258701#M40417 Anonymous 2017-06-07T05:07:27Z https://community.qlik.com/t5/Talend-Studio/tOracleInput-vs-tOracleConenction/m-p/2258702#M40418 <P>Hi,</P> <P>The tOracleClose component closes the transaction committed in the connected DB.</P> <P>Usually, we use tOracleConnection to open a connection to the specified database that can then be reused in the subsequent subjob or subjobs.</P> <P>The work flow looks like: tOracleconnection--&gt;onsubjobok--&gt; tOracleinput--&gt;output</P> <P>Best regards</P> <P>Sabrina</P> <DIV class="section" lang="en">&nbsp;</DIV> <DIV class="section" lang="en">&nbsp;</DIV> Wed, 07 Jun 2017 09:50:50 GMT https://community.qlik.com/t5/Talend-Studio/tOracleInput-vs-tOracleConenction/m-p/2258702#M40418 Anonymous 2017-06-07T09:50:50Z