Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
HanSolo44
Contributor II
Contributor II

tELTMSSqlinput with tELTOracleoutput ?

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

Labels (4)
1 Reply
Anonymous
Not applicable

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