topic tELTMSSqlinput with tELTOracleoutput ? in Talend Studio

tELTMSSqlinput with tELTOracleoutput ?

HanSolo44 — Fri, 15 Nov 2024 23:17:15 GMT

Hi,

I have MsSql in entry and Oracle in output.

I want to transfer a lot of informations with "ELT" components. Is it possible ?

Thanks

Re: tELTMSSqlinput with tELTOracleoutput ?

Anonymous — Mon, 24 Jan 2022 04:10:57 GMT

Hello,

ELT means the component creates actually nothing more than SQL statements which does the job. It has the advantage to avoid transferring the data outside the database but you lose the control over the flow and cannot say anything about the progress and of course it works only in one database which are connected to each other.

Please refer to this article: https://www.talend.com/resources/elt-vs-etl/

Best regards

Sabrina