topic TJDBC Components vs DB Native Components Working Principle & Difference in Talend in Talend Studio

TJDBC Components vs DB Native Components Working Principle & Difference in Talend

ashif2 — Sat, 16 Nov 2024 00:00:40 GMT

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

Note:

https://www.talendforge.org/forum/viewtopic.php?id=3904

Re: TJDBC Components vs DB Native Components Working Principle & Difference in Talend

Anonymous — Fri, 09 Jul 2021 09:05:39 GMT

Hello,

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.

Best regards

Sabrina