TJDBC Components vs DB Native Components Working Principle & Difference in Talend
Hi Gurus,
In Talend , we have DB specific components as well as JDBC components. I'm trying to understand the principle based on which we can decide which component to use.
In General, it's always recommended to use DB native drivers to avoid unnecessary translation of JDBC to DB Specific calls.
In DB specific components , we have bulk Output Components ?
Can anyone explain the use cases where you explicitly selected JDBC Components
Generally speaking, it mainly depends on your job requirement.
For the generic JDBC component, you need to select the database type and its corresponding JDBC driver. The specific database components are a bit more comfortable.
The jobs will be much more portable if you combine this with context variables for jdbc connections and configuration instead of relaying on specific database components.
