topic Pass Oracle connection to Routine in Talend Studio

Pass Oracle connection to Routine

Anonymous — Wed, 30 Oct 2019 15:04:00 GMT

Hi Team,

Is there any sample code for passing oracle tDbConnection to rountine and prcoess db records (Do some select * from table query) in routine.

Re: Pass Oracle connection to Routine

Anonymous — Wed, 30 Oct 2019 17:41:26 GMT

Hi,

Why are you running the Oracle connection inside a routine? You can always extract the data set using Oracle native components like tOracleInput or tOracleRow and then you can use this result set for further processing.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Pass Oracle connection to Routine

Anonymous — Mon, 04 Nov 2019 06:04:15 GMT

Hi,

Though, We can extract data using Oracle components, But if required we can pass the connection to Talend Routines as well. Create a Db connection using tOracleConnection component. Then go to the code section of the job where you can get the object name which you can pass to your Talend routine.