Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Difference between ETL and non ETL components

Hi All,

 

I am new to Talend, so it might be a stupid question to which i can not find an answer or may be i am not searching it right.

 

I noticed there are some normal components on the palette and a ETL version of the same component is also available. For example there is tMysqlOutput component available  in Mysql group and, a tETLMysqlOutput component is also available.

 

How are the normal components different from ETL components. Also i noticed that the Link Connector is only available for ETL components. Is there a reason for it?

Labels (2)
3 Replies
aashish_21nov
Creator
Creator

Hi Mohit,

 

ETL component i:e;  tETLMysqlOutput is basically used for insert,update,delete purpose only on the other hand  tMysqlOutput used only for the purpose of insert data into the datase table.

Anonymous
Not applicable
Author

Thanks for responding Aashish. So what you are saying is tETLMysqlOutput is super set of tMysqlOutput. But the question arises than what is the need to tMysqlOutput when tETLMysqlOutput could do everything.

 

Does the same applies for all other ETL components as well.

Anonymous
Not applicable
Author

Hello,

ELT 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.

The ELT component should be used if you have a large amount of data. 

Best regards

Sabrina