topic Re: Difference between ETL and non ETL components in Talend Studio

Difference between ETL and non ETL components

Anonymous — Fri, 15 Jun 2018 08:53:13 GMT

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?

Re: Difference between ETL and non ETL components

aashish_21nov — Fri, 15 Jun 2018 10:40:47 GMT

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.

Re: Difference between ETL and non ETL components

Anonymous — Mon, 18 Jun 2018 12:26:18 GMT

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.

Re: Difference between ETL and non ETL components

Anonymous — Tue, 19 Jun 2018 09:45:40 GMT

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