tOracleInput vs tOracleConenction

Four Stars

tOracleInput vs tOracleConenction

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?

Moderator

Re: tOracleInput vs tOracleConenction

Hi,

The tOracleClose component closes the transaction committed in the connected DB.

Usually, we use tOracleConnection to open a connection to the specified database that can then be reused in the subsequent subjob or subjobs.

The work flow looks like: tOracleconnection-->onsubjobok--> tOracleinput-->output

Best regards

Sabrina

 
 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now