Difference between ETL and non ETL components

[Anonymous]

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?

[aashish_21nov]

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]

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]

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